Using Regular Expressions to get line breaks

  • 12 March 2015
  • 2 replies
  • 11 views

Badge +1

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 , , , 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


2 replies

Badge +9

Hi Maureen

can You try

[ f ]+

  • [ f ]+ 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]
    • matches a line-feed (newline) character (ASCII 10)
    • f matches a form-feed character (ASCII 12)
    • matches a carriage return (ASCII 13)

Kind regards

Manfred

Badge +1

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

Reply