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?
Page 1 / 1
Hi Maureen
can You try
[
f
]+
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
Thanks Manfred. I was able to make it work with just a "
". But your post is very helpful.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.