Skip to main content
Nintex Community Menu Bar

Using Regular Expressions to get line breaks

  • March 12, 2015
  • 2 replies
  • 48 views

Forum|alt.badge.img+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

Forum|alt.badge.img+9
  • March 13, 2015

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


Forum|alt.badge.img+1
  • Author
  • May 28, 2015

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