You are viewing limited content. For full access, please sign in.

Question

Question

Replacing line breaks from a multi line form field before save to database

Workflow Forms
Updated August 1, 2017
asked on August 1, 2017

Hi,

 

We have a LF Form with a multi line field. We are using workflow to write this data into a db field. The issue is users are entering line breaks/carriage returns. When exporting this data into Excel it does not line up correctly in colums and becomes unusable. Does anyone have any ideas in Workflow how to replace the line breaks with a pipe or space before writing to the database? I have had a play with pattern matching but can't seem to get it working.

cheers

0 0

Answer

SELECTED ANSWER
replied on August 1, 2017

Pattern Matching should be able to break it into a multi-value token containing each line as a separate value (looking for [^\r\n]+, aka "anything but a newline). Then you can reconstruct it into a single-value token with indexing on the Pattern Matching token and delimiting the values with space

1 0
replied on August 1, 2017

Thanks Miruna, I was thinking of going that way too, that has helped me nail it!

 

cheers

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...