Hi, I have some formatted strings that I'd like to split and get the meaningful data, here is the example of the string format. The big difference of these two line are the second double quote set at the second line 100-01001-001,"Diode,Small Signal,SOT-23",1,D46, 100-01004-001,"Diode,High Voltage General Purpose,600mA,200V,SOT-23", 3,"D24,D72,D104",
I want to split the string into the following format: '100-01001-001', 'Diode,Small Signal,SOT-23', '1', 'D46' '100-01004-001', 'Diode,High Voltage General Purpose,600mA, 200V,SOT-23', '3', 'D24,D72,D104' By doing so, the list then has the meaning of part #, description, quantity and reference. Here is the way I way to split: str2=line1.split(',\"', 1) # Split part# and the rest key = str2[0] str3 = str2[1] str4 = str3.split("\",", 1) Value1 = str4[0] str5 = str4[1] str6 = str5.split(",", 1) # QTY, PARTS & BOM_NOTES Quanty = str6[0] str7 = str6[1] # PARTS & BOM_NOTES if str7[0] == "\"" : str8=str7.split("\"", 2) str9=str8[1] else : str8=str7.split(",", 1) str9=str8[0] print(key, ":", str9) It seems work this way, but is there more elegant way to do this? Thanks, Leland -- http://mail.python.org/mailman/listinfo/python-list