File Content Conversion -tab delimiter

[Former Member]

Hello Everyone,

I have a scenario where i have a tab delimited file on the sender side. But the problem is tab is not of uniform length. Can anyone of u suggest me what is the parameter i shud use.

sample data:

Haritha 709 78

Regards,

Hema

[Former Member]

Hi Hema

please mark the question as answered.

Thanks

Rinku

[Former Member]

Hi ,

>>tab delimited file on the sender side.But the problem is tab is not of uniform length

Why dont you confirm from the third party from where you are getting the file . Let them know that tab is not of uniform length.

Regards,

Sumit Khetawat

[Former Member]

Hi

you can use the fiollowing parameters at the sender side.

and on the sender side use the content conversion

RECORD.fieldFixedLength :10,20

RECORD.fieldNames :KEY,FNAME,LNAME,AGE

RECORD.keyFieldValue :1

DETAIL.fieldFixedLength :10,20

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 19138

Thanks

Rinku

[Former Member]

Hi Hema

please mark the question as answered if solved.

Thanks

Rinku

[Former Member]

Hi Hema,

I guess you have not seen your test file correctoly. it seems that your file is of fixd field length and this is the reason it is not of uniform length.

Just check it once again.

Just in case if your file is of fixed field length use below mentioned FCC parameters in your <b>Sender CC</b>.

Below is the example when you have HEADER & ITEM structure.

FCC is case sensitive, give all the names in FCC same as your Data Type.

In Recordset Structure = Header,1,Item,*

Header.fieldFixedLengths = (field lengths) e.g. 1, 4, 7

Header.fixedLengthTooShortHandling=ignore

Header.endSeperator='nl'

Item.fieldFixedLengths = give the item field length as shown above

Item.endSeparator = 'nl'

Item.lastFieldsOptional = YES

Regards,

Sarvesh

*****Reward points, if found helpful.

[Former Member]

hi

you just count the spaces and use the fieldfixedlengthfunction in the sender side.

please reply me back if you still face the problem.

Thanks

Rinku