RegEx expression from excel file

[paul.baltag1 (Paul Baltag)]

Hi all,

Could you please help me with a RegEx expression for extracting a company name from this:

"EXPERT SOLUŢII PUBLICITARE SRL
J03/825/2010
ROONRC.J03/825/2010
27325144

Municipiul Curtea de Argeş, Str. MIOARELE, Nr. 2, Județ Argeş"

The company name is EXPERT SOLUŢII PUBLICITARE SRL and can be found always on the forst row. Or if we can find a pattern for the expression that contains two “/” .

I have attached an excel with data that needs to be cleaned.
Thank you.

data.xlsx (9.0 KB)

[raja.arslankhan (Raja Muhammad Arslan khan)]

@paul.baltag1 are you sure company name will be present in first line.

[Gokul001 (Gokul Balaji)]

Can you share us the output also @paul.baltag1

[paul.baltag1 (Paul Baltag)]

@raja.arslankhan

company name will be present in first line

Yes, always will be in the first line.

[raja.arslankhan (Raja Muhammad Arslan khan)]

@paul.baltag1 so please use string split with new line, you will get string array and company name will be present in array first index.

[Gokul001 (Gokul Balaji)]

Hi @paul.baltag1

How about this expression?

System.Text.RegularExpressions.Regex.Match(YourString,"(\S.+)\n[A-Z]\d+\/\d{0,5}").Groups(1)

Regards
Gokul

[paul.baltag1 (Paul Baltag)]

@Gokul001

(\S.+)\n[A-Z]\d+\/\d{0,5}

Thank you, it works.