IMPORTANT ANNOUNCEMENT

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)

Page 2 of 2 < 1 2
Topic Options
#58191 - 10/29/21 08:33 AM Re: PressTalk Carriage Return or Feed Line not working [Re: phinix_mike]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 681
Loc: Québec, Canada
Problem is that in a CSV file, CRLF duo are used to separate the lines. The problem here is to known when it is a end of line CRLF and a end of line in your "message" field.

Your best bet would be to replace your CRLF inside your "message" field by any other string like {CRLF}, in Workflow using Regex and then use my solution in PPress.
_________________________
♪♫♪♫
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code
♪♫♪♫

Top
#58192 - 10/29/21 08:58 AM Re: PressTalk Carriage Return or Feed Line not working [Re: phinix_mike]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 681
Loc: Québec, Canada
Here is how I did it:
  1. steps up to here
  2. Advanced Search and Replace using REGEX (explanation below)
  3. Advanced Search and Replace using REGEX (explanation below)
  4. Advanced Search and Replace using REGEX (explanation below)
  5. steps continue


So, I used REGEX:

In step 2., I used:
-String to search = "(\r\012)
-Replace with = "{goodCRLF}
which replace the end of line CRLF by {goodCRLF}

In step 3., I used:
-String to search = (\r\012)
-Replace with = {CRLF}
which replace the end of line CRLF, from the "message" field by {CRLF}

In step 4., I used:
-String to search = \{goodCRLF\}
-Replace with = \n
which replace the end of line {goodCRLF} from earlier back into a end of line

and then that works with my previous PressTalk smile
_________________________
♪♫♪♫
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code
♪♫♪♫

Top
Page 2 of 2 < 1 2