cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Using Regular Expressions to get line breaks

Jump to solution

I am trying to load the contents of a CSV file to a SharePoint list.  I tried using the approach from Vadim Tabakman's blog post (Nintex Workflow - Parse CSV and Create a List) but ran into issues with splitting the CSV content into lines.  Per the directions in the blog post, I used a Regular Expression workflow action to identify the line break to split the content into lines.  I tried to check for the existence of line breaks and this is what I got.  I tried \r\n, \n, \r, but it seems like this is not the correct regular expression for identifying line breaks.  Does anyone know what the right expression is?

2015-03-12_9-41-42.png

0 Kudos
Reply
2 Replies
Workflow Hero

Re: Using Regular Expressions to get line breaks

Jump to solution

Hi Maureen

can You try

[\n\f\r]+

  • [\n\f\r]+ match a single character present in the list below
    • Quantifier: + Between one and unlimited times, as many times as possible, giving back as needed [greedy]
    • \n matches a line-feed (newline) character (ASCII 10)
    • \f matches a form-feed character (ASCII 12)
    • \r matches a carriage return (ASCII 13)

Kind regards

Manfred

Reply
Workflow Hero

Re: Using Regular Expressions to get line breaks

Jump to solution

Thanks Manfred.  I was able to make it work with just a "\n".  But your post is very helpful.

0 Kudos
Reply