AnsweredAssumed Answered

What's a good regular expression to match a csv line that is mostly empty?

Question asked by dan_moscu Employee on Aug 28, 2018
Latest reply on Aug 29, 2018 by leif_jacobsen

Hi there,

 

What's a good regular expression to match a csv line that is mostly empty?

My sample csv is:

5000091;24/08/2018;;;;;;;;;

 

I tested several expressions that work in Notepad++ and other tools, but not in Boomi.

Following did not work for me:

(?s).*;;;;;;;;;

(?s)(.*;)*;;;;;

 

And the output from the decision shape is something like this:

Result: 5000091;24/08/2018;;;;;;;;;
matches regular expression (?s)(.*;)*;;;;; = false

 

Thank you!

Outcomes