mrwaqasbaig Posted August 25, 2014 Share Posted August 25, 2014 I have a CSV file which has more than 50k records and i want to convert this using regex Item Code,,Qty CMAC-389109,,6 ,Serial No., ,954zg5, ,ffnaw8, ,gh8731, ,gxj419, ,hc6y9q, ,y65vh8, CMAC-394140,,1 ,Serial No., ,4cu3z7, and I want to convert this data to below format: ItemCode,Serial Number,Qty CMAC-389109,"954zg5, ffnaw8, gh8731, gxj419, hc6y9q, y65vh8",6 CMBM-394140,"4cu3z7",1 Can i achieve this using find and replacement ? Any help will be highly appreciated. Quote Link to comment Share on other sites More sharing options...
requinix Posted August 25, 2014 Share Posted August 25, 2014 (edited) This is not a job for regular expressions. Read the file line by line and build up a list of serial numbers for each item. When you're done accumulating for each one (ie, when you read a new item or hit the end of the file), write the complete item back out to a new file. Or not a new file and read everything before you re-open and write. Edited August 25, 2014 by requinix Quote Link to comment Share on other sites More sharing options...
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.