Hi All,

I am new to XSL transformations. I had gone through some tutorials and most of them talk about XSLT transformations applying on XML file.

My requirement here is transforming a .txt which has PIPE delimited values to same file with COMMA as the delimiter. i.e need to replace all PIPEs with COMMAs

For ex:

From -> 1|ABC|XYZ|123|GOOD
         2|SDF|WEW|432|BAD

To -> 1,ABC,XYZ,123,GOOD
          2,SDF,WEW,432,BAD

Thanks for your help in advance.

~Satish

XSLT is a transformation language designed for manipulating XML. You could do this problem in XSLT but I can't see why you would want to: there are other languages such as Perl which seem much better suited to the task.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thanks for your time and suggestion Michael.

Actually we have got a new interface recently, for this we receive files in PIPE delimited. The current process supports only XSLT as pre-process step, that is the only reason I am thinking about XSLT.

Regards,
Satish

In XSLT 2.0 it's easy enough to read a text file using unparsed-text() and to parse its structure using xsl:analyze-string; it's also easy to write text output using the text output method.

But there's something very odd about this. It makes sense to build a processing pipeline in which the data is passed around as XML and processed using XSLT. It seems very peculiar to design the pipeline around XSLT and then push non-XML data through it.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference