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. Link to comment https://forums.phpfreaks.com/topic/290632-how-to-to-regex-here/ Share on other sites More sharing options...
requinix Posted August 25, 2014 Share Posted August 25, 2014 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. Link to comment https://forums.phpfreaks.com/topic/290632-how-to-to-regex-here/#findComment-1488832 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.