Tab delimiter for File Content Conversion

[Former Member]

Hello everyone,

Could anybody tell me how do i use tab delimiter for file content conversion.

Thanks,

Chinna

[Former Member]

Hello everyone,

Thanks for your valuable replies. The problem is solved.

Thanks,

Chinna

[Former Member]

Hello Aamir,

Thanks for your reply. As you said i have given the <i>Recordset structure</i> as DT_Vendor,* . I didn't specify the keyFieldName and keyFieldValue parameters. Could you pls tell me what could be the issues with these parameters and what exactly do i need to specify.

The sample file is tab delimited file, i'm sure of it.

Would appreciate more help on this issue.

Thanks,

Chinna

[Former Member]

Hi Nisar,

I've tried using quotes and without quotes. It didn't work even then. Could you pls tell me what do you mean by HT.

Thanks,

Chinna

[Former Member]

to me it looks like an issue with your keyFieldName and keyFieldValue parameters.

you might have given the <i>Recordset structure</i> as DT_Vendor,* in the sender file adapter(FCC configurations) and due to which it is putting all the values in a single tag.

if this is the case you might need to use the above said parameters

secondly the sample file you have provided doesn't looks like a tab delimited file instead it looks more like a space delimited file,a tab has usually 8 spaces and in your case it has only 1 space between different entries.

Thanx

Aamir

Message was edited by:

Aamir Suhail

[Former Member]

Hi Nisar,

I tried using 0x09, but i'm unable to get the fields separated.

Any suggestions would be appreciated.

Thanks,

Chinna

[nisarkhan_n]

did u try giving in Single quotes and without quotes, check giving HT also

[Former Member]

Hello everyone,

Thanks for the replies. I have tried using the '0x09' and also the tab space as the fieldseparator. The fields are not getting separated. I'm receving the output in a single field.

This is the incoming file structure

S2430112 0021-90016 2007 DC2007051145 2 08F1 20070524 20070524 1 QUANTUM LEAP 13030 ³¯¤¤¤¸ 58373 650804 Lª´Öq(36020/8736020) Y

S00019616 3690-91182 2007 DC2007051145 3 08F1 20070524 20070524 10 QUANTUM LEAP 13030 ³¯¤¤¤¸ 58373 650804 ªLª´Öq(36020/8736020) Y

This is the way i configured my CC

ignoreRecordSetName : true

DT_Vendors.fieldNames:CUST_PN,AMT_PN,YEAR,DOC_NO,DOC_ITEM,PLANT,POST_DATE,REQ_DATE,REQ_QTY,MACH_CODE,RQNER_ID,RQNER_NAME,RQNER_EXT,COST_CTER,PLANNER,PART_DESC

DT_Vendors.fieldSeparator : (TabSpace)

DT_Vendors.endSeparator : 'nl'

This is the ouput from the moni

-

I would appreciate your help on this issue.

Thanks,

Chinna

[nisarkhan_n]

instaed of giving the blank space try giving the value 0x09, as pointed in the earlier replies.

[Former Member]

Hi Reddy,

can u pls give some details regarding the fields u are using in source and target side ................

[Former Member]

hi ,

you can go for the <b>hexadecimal value of tab</b> . it will work .

dont use fieldSeparator : '0x09'.

just try like fieldSeparator : 0x09

hope it will help.

regrads

honey

Message was edited by:

Honey Gyanani

Message was edited by:

Honey Gyanani

[Former Member]

Hello MK,

I tried that, I'm unable to separate the fields by using the fieldSeparator : '0x09'.

I would appreciate if you could give more information on that.

Thanks,

Chinna

[Shabarish_Nair]

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter - if you have ref. my weblog, i have also used the CNTL+ C & CNTL + V of a tab space from notepad to the FCC.

Did you try that ?

Is there any specific error that you are getting ???

[Former Member]

Hi

The hexadecimal notation for the TAB is 0x90.

Specify the (substructure).fieldSeparator as ‘0x09’.

Refer

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

Thanks

[bhavesh_kantilal]

Probably by using search on SDN.

Here is the blog that will help you,

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

Regards

Bhavesh