on 07-03-2015 6:49 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajendar,
As Praveen and Sendhil said, you could either go for java mapping or else you could try the FCC parameter to achieve your requirement.
I want to tell one more approach for this, which is Use ReplaceString text function in graphical mapping, and replace all occurrences of " with blank value. Since your's field separater, extract the whatever value in the source file to XML and use ReplaceString function in graphical mapping, you can transform to target accordingly. But the Con here is that if you have more number of fields like this, then it becomes tedious for you to follow this way..
Regards
VIshnu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajendar,
Try this in your FCC.
Reference: Converting File Content in the Sender Adapter - SAP XI: Runtime - SAP Library
| · Specify YES if the text delimiter is to be removed when the files are transferred or if the escape character is to be replaced. · EnterNO if the character is to be transferred unaltered. If you specify xml.enclosureSign=“ and xml.enclosureSignEsc=““, text enclosed in quotation marks is transferred unchanged and the quotation marks are removed. If the escape character for a quotation mark (““) itself occurs in the text, it is replaced by the quotation mark during the transfer. This parameter is optional. |
Hope this helps.
Oops, the " to be removed from between the data,
If you have less number of fields then you can UDF and handle it this way. If it has many fields, you can follow Praveen's suggestion.
pattern you can have it as " (quotes)
--
Sendhil
Message was edited by: Sendhil Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.