File content conversion example

[Former Member]

If the first line in the FCC file is having some company Info. from the next lin onwards it is having the data. i have to avoid that info & transfer the data only Hoew can proceed?

[former_member614185 · Accepted solution]

In adapter configuration choose file content parameter and mention the structure that u want to remove and the field separator as 0

[Former Member]

Hi

if you have text file at the sender side use the folloeing parameters in the sender communication channel

RECORD.fieldSeparator :,

RECORD.fieldNames :KEY,FNAME,LNAME,AGE

RECORD.keyFieldValue :1

DETAIL.fieldSeparatr :,

DETAIL.fieldNames :KEY,SALARY,EMPID

DETAIL.fieldNames :2

Note:these parameters are accoding to the structure given below.

suppose you have a structure like as below

data (0..unbounded)

record (0..unbounded)

key (1..1)

fname (1..1)

lname (1..1)

age (1..1)

detail (0..unbounded)

key (1..1)

salary (1..1)

empid (1..1)

and the input file will look like as below

1,aaa,bbb,23

2,12000,10838

1,ccc,ddd,23

2,13000,10830

n if you have text file at the receiver side then use the following parameters at the receiver side.

childnodename.fieldFixedLength:10,10

childnodename.endSeparator:'nl'

parentnodename.endSeparator:'nl'

if you still face the problem please reply me back

thanks

Rinku

[Former Member]

Hi sudhakar velineni

if you want that the compnay info should not be available in the target side then in the graphical mapping do not map the company info with the target structure just map only the fields that you want in the target side.

if you still face the problem please reply me back

Thansks

Rinku

[Former Member]

Under Document Offset, specify the number of lines that are to be ignored at the beginning of the document.

This enables you to skip comment lines or column names during processing. If you do not make an entry, the default value is zero lines.