XpownX 8 Posted January 15, 2019 Report Share Posted January 15, 2019 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! Quote Link to post Share on other sites
bestmacros 60 Posted January 15, 2019 Report Share Posted January 15, 2019 try this regex ^.*?(?= Quote Link to post Share on other sites
XpownX 8 Posted January 15, 2019 Author Report Share Posted January 15, 2019 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! ---------------------- Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.