cancel
Showing results for 
Search instead for 
Did you mean: 

PI 7.1 Sender File Adapter - FCC field seprator

Former Member
0 Kudos

Hi ,

I need to use Tabs as field seprators in send adapter FCC. So Please help me to find out the value for TABS.

<node>.fieldSeparator =

Regards

Mohit

Accepted Solutions (1)

Accepted Solutions (1)

PriyankaAnagani
Active Contributor
0 Kudos

Hi Mohit,

You can use the hexadecimal notation for the TAB which is 0x90. Please see the below link it may help you.

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

Regads

Priyanka

markangelo_dihiansan
Active Contributor
0 Kudos

Hello,

You can use the hexadecimal notation for the TAB which is 0x90

Tab is 0x09 in hexadecimal notation. It is also equivalent to 9 spaces.

Hope this helps,

Mark

Former Member
0 Kudos

Hi Priyanka,

thanks for your reply.

Is it work for 2,or 3 tabs.

Actually i have recived file like this:

IFO BC2RWEY 1-ZZ61T 1000210160130004 Y

IFO LN4RZ59 1-ZZ74E 1000210063250008 Y

IFO BC2SB26 1-ZZF97 1000211454950008 Y

IFO BC2RZ2C 1-ZZFQZ 1000215424460006 Y

IFO LN4S682 1-ZZZCY 1000210088900009 Y

IFO BC2T9QX 1-4A9675 1000258780420008 Y

IFO BC2T9QZ 1-4A8O6T 1000258784330005 Y

IFO BC2T9QY 1-4A90T9 1000258785330004 Y

IFO BC2T9R5 1-4A0DFM 1000258487700009 Y

I want to ask , there is 1 tabs but some time 2,3 tabs is also in file format.

Regards

Mohit

Former Member
0 Kudos

You will get multiple tabs if the value for the field is empty (null) FCC will place another tab for next separator

Regards

Raj

former_member191435
Contributor
0 Kudos

Hi Mohit,

When ever you will give field separator as tab it will applicable for all fields which you have mention for fieldnames.

Example :

Record.fieldnames : field, field2, field3

Record.fieldSeparator : tab or 0x09

this tab will work for all the 3 fields which u have given in record.fielnames.

Hope now you will understand. If you have any queries please post

Thanks,

Enivass

PriyankaAnagani
Active Contributor
0 Kudos

Hi Mohit,

Whatever the field seperator you are giving, it'll be applicable for all the fields of that recordset structure not for one single field. In your case use one tab i.e '0X09' as field seperator and read the data to respective fields of source structure. And then in your message mapping you can use trim() function to remove the whitespaces at the starting of the string.

Thanks

Priyanka Anagani.

Answers (2)

Answers (2)

Former Member
0 Kudos

thanks

former_member854360
Active Contributor
0 Kudos

Just type tab in notepad and then copy it and paste it in Module config

see this blog

SAP Network Blog: NAB the TAB (File Adapter)

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