Hi,
i have a requriement where i need to lists all the job in a project.
For this i have used DSGetProjectInfo(DSJ.JOBLIST) function in the transformer and capturing the output in one column in a comma delimated sequential file.
I am getting outpur like this
column1
=========
A,B,C,D,E,F etc
But i need output like following
column1
=====
A
B
C
D
E
F
etc
Please advise me how to acheive this.
thanks in advance
Regards,
Rafiq
spliting a string in one column into many rows
Moderators: chulett, rschirm, roy
This is answered in the FAQ forum. Basically all you need to do is replace the commas with the EOR characters for your O/S - in your case <CR><LF> pairs. Write out one record like that and it will read back in as many.
Use functions like Convert or EReplace along with CHAR(13):CHAR(10).
Use functions like Convert or EReplace along with CHAR(13):CHAR(10).
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
This is the FAQ post I mentioned, in case you hadn't found it yet.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks Chulett,chulett wrote:This is the FAQ post I mentioned, in case you hadn't found it yet.
I implemented ur logic and it's working fine.
Once again thanking you.
Regards,
Rafiq