Sender file content conversion

[Former Member]

Hi All ,

File Sender:

If my file is having multiple lines for one row..how i should do file content conversion..

My file is having around 300 fields and comming in couple or 3 lines for one record..

how should I get the row\line separator..

Thanks in advance..

Ramesh.

[Former Member · Accepted solution]

Hi,

Refer below link

File Content Conversion for Unequal Number of Columns

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns - FCC

Content Conversion (Pattern/Random content in input file)

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file - FCC

/people/harrison.holland5/blog/2006/12/20/xi-configuration-for-mdm-integration--sample-scenario - FCC - MDM

Thanks

Swarup

[Former Member · Accepted solution]

Thanks for reply,.

But none of the blog has other options for 'nl'..

If i need to consider 2,or 3 lines for one row data..

Regards,

Ramesh.

[Former Member · Accepted solution]

Hi,

May I kindly request you to explain your requirment in more detail. possibly with some

example as sample input and required output data so probably I could add some light on it.

Thanks

Swarup

[Former Member]

Hi,

Check some links.

File content conversion sites

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Regards,

Phani

Reward points if Helpful

[deepak_shah]

hi i have sent u pdf related to file content conversion on your ID

rameshbabu.s@zensar.in

hope u find that useful.

thanks

[Former Member]

Ramesh:

Is the fields are of fixed length? If so did u try FCC using Fixed lengths?. Also check if writing Adapter module will help solve your problem. The only thing I can think of is make your file contents to single line by the sending application or system.

hey let me know how did you solve the problem if u get a solution