Problem With Csv, All Text Is Inside The First Column

[XpownX 8]

Hi to all!

 

I'm need of help!

I've a csv file with over than 4000 records, and they are formatted in this way:

L00000639;"item name N.195 item name";"factory name";"1

000021619;"item name N.195 item name";"factory name";"1

 

Note they are in different rows but all that text is inside the column A

 

How can I take the code only ( The one before the comma ;  )

I've tried using regEx but without any success --> /[A-Z][0-9]9/g

 

I want to put the codes into a list afterwards.

 

Thanks to anyone who can help me!

[bestmacros 60]

try this regex

^.*?(?=

[XpownX 8]

 

try this regex

^.*?(?=

 

Thank you very much Sir! It works well but has only one problem!

At the beginning it adds a "

Example: "L00000639 , need to be --> L00000639

 

I've found the right regex don't worry! FIXED!

 

----------------------