Tab Delimited File?

[Former Member]

Hi All,

I am trying to create a tab delimited file using Sender File adapter using <b>File content Conversion in Adapter Module</b>. I want a constant space beteween the fields of length 8 spaces. When i use ' ' as field seperater , the file that is generated is <b>19' 'Stringtest14,Hiring' '09/03/2007' 'Managing Dir, Operations</b>. I want the file without colons i.e <b>19 Stringtest14,Hiring' 09/03/2007 Managing Dir, Operations</b>.

Please Advice...

Regards,

XIer

[Former Member]

Hi,

If it is a Tab delimited then use '0X09'

if u want seperator as Space then use '0X20'

Regards,

Phani

Reward points if Helpful

[Former Member]

Hi Xler

<b>content conversion parameters ,, just like</b>

Recordset structure = DT_PRY,*

DT_PRY.fieldnames = ID,empname,empno,country

DT_PRY.fieldSeparator = '0x09' (tab delimited)

DT_PRY.endSeparator = 'nl'

<b>

The FCC...</b>

Document Name : MT_PRY

Document Namespace : http://product.com/prvsoup

Recordset Name : recordset

Recordset structure = DT_PRY,*

DT_PRY.fieldnames = ID,empname,empno,country

DT_PRY.fieldSeparator = '0x09'

DT_PRY.endSeparator = 'nl'

ignoreRecordsetName = true

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

<b>can take the help of this blog</b>

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

<b>Conversion agent</b>

/people/william.li/blog/2006/03/17/how-to-get-started-using-conversion-agent-from-itemfield

/people/paul.medaille/blog/2005/11/18/conversion-agent-a-free-lunch

/people/alexander.bundschuh/blog/2006/03/14/integrate-sap-conversion-agent-by-itemfield-with-sap-xi

/people/paul.medaille/blog/2005/11/17/more-on-the-sap-conversion-agent-by-itemfield

Thanks!

Questions are welcome here!!

<b>Also mark helpful answers by rewarding points</b>

Regards

Abhishek Agrahari

[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