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

["H agents@xxxxxxxxxxxxxx" <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx>]

On 07/02/2022 11:08 PM, BR Chrisman brchrisman@xxxxxxxxx wrote:
> 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 <mailto:agents@xxxxxxxxxxxxxx> <xsl-list-service@xxxxxxxxxxxxxxxxxxxxxx <mailto: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.
>
>
> XSL-List info and archive <http://www.mulberrytech.com/xsl/xsl-list>
> EasyUnsubscribe <http://lists.mulberrytech.com/unsub/xsl-list/3480550> (by email <>)

Thank you, worked great!