on 03-15-2010 8:52 AM
Hi Experts,
I have the following structure
DATA (1..n)
...Result (1..1)
The Result field contains a string like below
a,b,c,d,e,f,g,h,i,j
How do I put this into File Content Conversion when I want the receiver to be a CSV file? One cell per letter.
Thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Outbound: you could convert your flat file to xml at first. Make the necessary mapping to the destination structur.
http://www.riyaz.net/blog/xipi-file-content-conversion-for-simple-structure/
Inbound: Content convernsion from xml to csv.
/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion
/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2
/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file
Cheers
Serdar
> How do I put this into File Content Conversion when I want the receiver to be a CSV file? One cell per letter.
Ask the receiver of the file, what is expected in this case.
Maybe you use a semicolon as divider?
The receiver has the structure above.
And the "Result" field contains a string like below
a,b,c,d,e,f,g,h,i
So they are separated by commas. I want to put each letter in one cell of the CSV.
> So they are separated by commas. I want to put each letter in one cell of the CSV.
No I get the point.
Just treat this as one field in FCC.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.