on 04-22-2008 4:03 PM
Hi all,
does xi accept the files which are in "INVERTED COMMAS".LIKE..
"12345","6789",9.45,9.45,9.45
"12345","6789",3.45,3.45,3.45
"12345","6789",40.26,40.26,40.26.
PLEASE HELP.
regards,
rao
Hi
As long as your fieldSeparator is ",", it reads them as strings only so you get inverted commas als into
payload
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi rao,
you can delete your " just inside you mapping, for instance with function ReplaceString. with x= " and y = space, following by function Trim.
http://help.sap.com/saphelp_nw04/helpdata/en/43/c4cdfc334824478090739c04c4a249/content.htm
Be carefull if your text between " " contain also a " because it will be also replaced.
But there are many solution in the mappinf including the UDF (user defined function).
Regards
Mickael
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.