Thanks.
Is there an easy way of removing these?
The actual problem I have is that I am trying to parse an XML file. One of the elements contains lots of text that is formatted on the file as:
Code: Select all
<textElement>
Lots of text starts here and goes on and on.
Then a new bit starts here, causing problems. The lines have
0A control characters for line feed.
</textElement>
When I run this through the XMLInput stage, it parses ok, but the output (sequential) file shows the rows:
Code: Select all
Row1:Lots of text starts here and goes on and on.
Row2:
Row3:Then a new bit starts here, causing problems. The lines have
Row4:0A control characters for line feed.
What I want is:
Code: Select all
Row1: Lots of text starts here and goes on and on. Then a new bit starts here, causing problems. The lines have 0A control characters for line feed.
So... my idea was to use convert to remove the control characters from the input XML...
Thanks again.
Edit to add:
When I run the convert on the small test file, but use CHAR(13) rather than CHAR(10), it does remove the 0D CR characters..