Subject:Text file to CSV to xml Author:Pravin Tailor Date:12 Jun 2012 08:13 PM
Hi,
I have a text file with the following separator: ñ
Questions:
1. How do I set this as one of the separator in the drop down list.
2. How can I replace this character with a 'comma'?
Would it be better to convert to csv first and then to xml or can I go directly to xml by using 'ñ' as the field separator when creating a convert file?
To change the separator you can pipe the input document into an identity transformation than pipe-out into the CSV converter using a different separator.
If you share sample of your data we will show you how.
Subject:Text file to CSV to xml Author:Pravin Tailor Date:14 Jun 2012 12:05 AM
Hi Ivan,
That is great.
Are you able to provide me with some explanation on how the porject is set up, how the 'ñ' character is setup in the project to be converted to a comma.
I am very new to this conversion procedure and it would help me great deal with some explanation. I have gone through the video on csv to xml conversion and need to look at it again and use the output of this test data to generate xml output.
Subject:Text file to CSV to xml Author:Pravin Tailor Date:14 Jun 2012 01:43 AM
Hi Ivan,
That is great.
Are you able to provide me with some explanation on how the porject is set up, how the 'ñ' character is setup in the project to be converted to a comma.
I am very new to this conversion procedure and it would help me great deal with some explanation. I have gone through the video on csv to xml conversion and need to look at it again and use the output of this test data to generate xml output.
Subject:Text file to CSV to xml Author:Pravin Tailor Date:17 Jun 2012 09:08 PM Originally Posted: 17 Jun 2012 08:17 PM
Hi Ivan,
Many thanks for the explanation.
I have one question and that is, how or why is the character ñ in the original file converted to ñ in the converter? Is this some kind of character translation? If so, what is this conversion?