Friday, April 4, 2008

Replace " (double quotes) from Field Elements with Xslt

Situation:
I receive a CSV file, all string values are surrounded by " (double quotes).
This is normal for a CSV file, to use with Excel. But when I need the values of these fields in my Xml to send to SharePoint, you can understand that I don't want to have those double quotes in the fields.

Problem:
I didn't find in my map a functiod to Replace those double quotes

Solution:
I created a map with a Custom Xlst, and used the function Translate for each field



I added this map to the receive port. Once the Xml file arrives in my Orchestration,the double quotes are gone.

1 comment:

Andy C. Mater said...

You can simply use the Default Wrap Character property in the schema definition.