These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#57368 - 12/27/19 11:46 AM XML CRLF between tags
Stephenlnoe Offline
OL Newbie

Registered: 11/07/19
Posts: 20
The source XML contains CRLF between the XML tags so instead of the null tag looking line this:


It looks like this:


Is there a way to strip the CRLF for some fields in the custom data selection where the CRLF scenario would return a NULL ''? I thought of using the STRIP command but cannot strip CRLF and I though of reformatting the field to strtocur/curtostr (it is a monetary value in the source XML).

no dice.

#57376 - 12/31/19 11:40 AM Re: XML CRLF between tags [Re: Stephenlnoe]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 681
Loc: Québec, Canada
You would need to use the Advanced Search and Replace plugin and have all CRLF found before a < replaced by a single <. You could use the following regex. Tested it and it works for me smile ) :

([\r\n ]+<)

and replace it by

99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code