Re: [xsl] Transforming field when parsing XML file with xsltproc

Subject: Re: [xsl] Transforming field when parsing XML file with xsltproc
From: "BR Chrisman brchrisman@xxxxxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx>
Date: Sun, 3 Jul 2022 03:08:09 -0000
It should be:

<xsl:value-of select="translate(--expression--, &#xA;, ' ')"/>
hex(A)=decimal(10)=ascii(LF)


On Sat, Jul 2, 2022 at 7:30 PM H agents@xxxxxxxxxxxxxx <
xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx> wrote:

> I am encountering a problem using xsltproc to parse an XML file generated
> on a server outside my control to create a text file for subsequent import
> into postgresql. The text file uses TAB for field separation and LF for
> record separation.
>
> Unfortunately one of the fields of the XML records occasionally contains
> LF characters which normally should not be part of the field. Can xsltproc
> be used to replace the LF in this single field with SPACE?
>
> The alternative would be to use awk to process the text file generated by
> xsltproc before importing using psql.
>
> Suggestions welcome.

Current Thread