Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Hopkin,
Use Subfield Function
Subfield(Form1,'-',1) as NewForm1,
subfield(To1,'-',1) as NewTo1,
then your script will be :
LOAD From,
To,
From1,
To1,
Subfield(Form1,'-',1) as NewForm1,
subfield(To1,'-',1) as NewTo1,
FROM
(
Regards,
Nilesh Gangurde
Hi Nilesh,
this is now my script..
[Expense Codes]:
LOAD From,
To,
From1,
To1,
F AS Desc,
Subfield(From1,'-',1) as NewFrom1,
Subfield(To1,'-',1) as NewTo1,
From1 + IterNo()- 1 as EC
FROM
(
While (From1 + IterNo()-1) <= To1;
but it still doesn't work...
have i done the script correctly?
.
Dont use while in your script,
No need of while..
just copy the script from my last post...
Nilesh Gangurde
but the while is to do a loop through the data of the 2 fields... i need to keep that otherwise i cant do what i need to do...
How about this?
I changed column names..
Example1:
LOAD Fromf,
To,
PurgeChar(From1,'-') as From2,
PurgeChar(To1,'-') as To2,
Fromf + IterNo()- 1 as CC
FROM Sample.xls (biff, embedded labels, table is Sheet2$)
While (Fromf + IterNo()-1) <= To;
This got rid of the - in the two fields..