Extracting data from Flat File

[Former Member]

Hi ,

I have a scenario in which I am getting data as a flat file and this needs to be mapped to the RFC . The flat file is comma separated . There is one field in the flat file known as message in which I am getting a chunck of data . This data is taken as a string , based on this data I need to perfom some mapping . The data in the message field is itself coming in a pipe separated format . It is somewhat like this

TWS001 1 20060701 20060701 115845 1000004 4 S201006790 2 0600000097|0600000097||||B1613845A||06A|*|1|1|7800|0|0|0|0|0||||0|E00054|1|2340|||||||||||||0|2|5460||

The last big stream being the message field please tell me how to segregate the data .

[Former Member]

I don't see the issue.. your fieldSeperator is comma.. so it will not look for the pipe to seperate the particular field msg..

it should be ok as long as you don't want to have function to split that particular msg.

-GS

[bhavesh_kantilal]

Anita,

If you can give us the source datatype format, we can help you will the exact content conversion parameters.

Regards,

Bhavesh

[Former Member]

Hi Bhavesh ,

The data type beimg given is of this format :

TLOG Root Node Structure 1..n

STORECODE

TILLID

TXDATE

POSTDATE

TXTIME

TXSERIAL

TXBATCH

DOCNO

VOIDDOCNO

TXTYPE

TXMSG

TMSG is the field conatinig the message ( stated in my mail ) .

Thanks

Anita Yadav