on 07-25-2012 9:04 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
tilde - http://www.ascii.cl/htmlcodes.htm
but you can try with the normal ~ first too, this does not work ?
Regards,
Michal Krawczyk
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
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.