Translate out embedded line feed in XML data field

David Paras

• October 25, 2012 18:42

I have a field like the following:

<ItemDescription>walking stick
Circa 1850</ItemDescription>

I can’t figure out how to remove the line feed after “walking stick”.

0

• 

  David Paras

  • October 25, 2012 18:42

  You can try using the normalize-space() or translate() string functions within the data mapper to remove the line feeds.

  Ex: normalize-space(ItemDescription) or translate(ItemDescription, '&#x20;&#x9;&#xD;&#xA;', ' ')

  0

Please sign in to leave a comment.