cancel
Showing results for 
Search instead for 
Did you mean: 

Does Pi supports '~'

Former Member
0 Kudos

Hi Folks,

I got a requirement like this File is sending data to sap(Idoc or BAPI).For this we need to finalize the inbound file format. The  Team is suggesting a new file format, where ‘At present it is comma delimited. Now new approach is it will be changed from ‘,’ to  ‘~’ .

Could you confirm, Is Pi capable to handle with ‘~’ delimiter ?

Thanks in advance

Regards

Kalyan

Accepted Solutions (0)

Answers (1)

Answers (1)

MichalKrawczyk
Active Contributor
0 Kudos

Hi,

if you only want to use it in FCC this should work

but why not "," ? (just curious)

BTW

maybe you can use fixed lengths instead and save youserself the issue with delimiters ?

Regards,

Michal Krawczyk

Former Member
0 Kudos

Hi Michal,

Thanks for the quick reply...In Fcc we should maintain any hexadecimal value ?

if it is then what is the value for this...?

MichalKrawczyk
Active Contributor
0 Kudos

hi,

tilde - http://www.ascii.cl/htmlcodes.htm

but you can try with the normal ~ first too, this does not work ?

Regards,

Michal Krawczyk

Former Member
0 Kudos

Hi Michal,

I used ~ in FCC PI able to pick file ,but in target server it is only we are getting ~,we are not getting any values.

I/p file is

SOBID~FEEDERCODE~TRANSACTIONCODE~CONVERSIONTYPE~CURRENCYCODE~

D~F~119~Y~CNY~

D~F~119~Y~CNY~

D~F~119~Y~CNY~

D~F~119~Y~CNY~

Please find the attatched doc and let me know if i am correct.

In output directory i am only getting this

Former Member
0 Kudos

Hi.

From documention.

http://help.sap.com/saphelp_nwpi711/helpdata/en/44/658ac3344a4de0e10000000a1553f7/frameset.htm

Special Characters in Strings for Separators - In all strings for separators (NameA.fieldSeparator, NameA.beginSeparator, NameA.endSeparator), you can specify non-printable ASCII characters. These characters can each be inserted individually in the strings in the form ´0xHH´ (including the quotation marks), where HHrepresents the character encoded as a hexadecimal value.

I guess you need to add the value(~) as hexadecimal value.

Try with this. http://www.string-functions.com/string-hex.aspx

or use the above link that provided by Michal.

Regards

Lucho

Former Member
0 Kudos

Hi Luis,

I tried using '0x7E' also ..but still i am not getting any data..

PI able to pick the data but its nt populating in target server:-(

MichalKrawczyk
Active Contributor
0 Kudos

Hi,

>>>PI able to pick the data but its nt populating in target server:-(

but does the FCC work ? do you see XML in monitoring correctly and just not in the destination ?

Regards,

Michal Krawczyk

Former Member
0 Kudos

Hi

In moni i am able to see payload..but not in target server.

Before that i tested the same interface in sandbox for xml to txt..and it is successful..

but txt to .txt pi able to pick file and in target server only ~ is generating.

guys need your help on this..

Former Member
0 Kudos

Hi.

As Michal ask you... Do you see the XML Input?. It seams is Mapping Problem. or configuration of FCC Receiver.

Post your input XML.

Regards

Lucho.

Former Member
0 Kudos

Yes i saw the XML input.Mapping is fine and its not throwing any error also.

I think FCC receiver might be a pblm..

i tested with following files in sandbox

1.xml to txt----successfull

2.txt to xml----successfull

3.txt to txt---unsucessfull

Former Member
0 Kudos

Hi,

It might be a FCC problem.

Please also try using a File Encoding ISO-8859-1.

Thanks,

Sudhansu