| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Modifying large CSV files
Hello,
I'm an Excel novice, as I only work with it when I *have* to. I need to convert a comma delimited file to a slightly different format. It goes like this: Original Format: !PRODUCTID,!PRODUCTCODE,!PRODUCT,!IMAGE 510041235,510041235,FRIENDS Chevrolet Magazine March 1941 - Vivien Leigh,"P9225543_vintage_magazines_.jpg,P9225543a_v intage_magazines_.jpg,P9225544_vintage_magazines_. jpg,P9225544a_vintage_magazines_.jpg,P9225544aa_vi ntage_magazines_.jpg" 506230710,506230710,1958 Dodge - Christmas Music Record - Lawrence Welk,"P30520231.jpg" Desired Format: !PRODUCTID,!PRODUCTCODE,!PRODUCT,!IMAGE 510041235,510041235,FRIENDS Chevrolet Magazine March 1941 - Vivien Leigh,P9225545_vintage_magazines_.jpg ,,,P9225543a_vintage_magazines_.jpg ,,,P9225544_vintage_magazines_.jpg ,,,P9225544a_vintage_magazines_.jpg ,,,P9225544aa_vintage_magazines_.jpg 506230710,506230710,1958 Dodge - Christmas Music Record - Lawrence Welk,P30520231.jpg Any ideas? Thanks in advance for any suggestions! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't use large files including graphs | Excel Discussion (Misc queries) | |||
| Problelm with large files | Excel Discussion (Misc queries) | |||
| Copying Formulas in LARGE Files | Excel Worksheet Functions | |||
| Using large excel files | Excel Worksheet Functions | |||
| Exceptionally large files | New Users to Excel | |||
Threaded Mode
