AnsweredAssumed Answered

How to Parse a CSV file with comm and double quote

Question asked by venkatesh.rupanagudi080702 on Mar 3, 2017
Latest reply on Mar 9, 2017 by venkatesh.rupanagudi080702

Hello Guys,

 

I have a csv file which has both commad delimited and also double quote delimited within { } as shown below. How do I parse this file , the last column has prices_json has values between {"PHP":0,"MYR"0 etc}?.

 

ID used in MDM application_id name partner edition_name edition_code edition_id prices_json
23436863 2343 AfterShot Pro 3 for Mac APPDIRECT AfterShot Pro 3 AfterShot Pro 3 6863 {"PHP":0,"MYR":0,"NZD":0,"SEK":0,"JPY":8332.41,"AUD":0,"CAD":91.42,"USD":69.99,"DKK":0,"GBP":54.16,"CNY":0,"MXN":0,"EUR":68.05,"CHF":0,"NOK":0}
23476867 2347 AfterShot Pro 3 for Windows APPDIRECT AfterShot Pro 3 AfterShot Pro 3 6867 {"PHP":0,"MYR":0,"NZD":0,"SEK":0,"JPY":8332.41,"AUD":0,"CAD":91.42,"USD":69.99,"DKK":0,"GBP":54.16,"CNY":0,"MXN":0,"EUR":68.05,"CHF":0,"NOK":0}
799 799 Bamboo Paper APPDIRECT Mobile app Bamboo Paper
795 795 Wacom Inkspace App APPDIRECT Wacom Inkspace app*
14676497 1467 Corel Painter® 2017 for Mac APPDIRECT Corel Painter® 2017 CorelPainterMac 6497 {"NZD":0,"GBP":333.33,"SEK":0,"AUD":0,"USD":429.99,"EUR":386.55,"CHF":0,"CNY":0,"PHP":0,"MYR":0,"JPY":47073.15,"NOK":0,"DKK":0,"CAD":561.9,"MXN":0}
14754327 1475 Corel Painter® 2017 for Windows APPDIRECT Corel Painter® 2017 CorelPainterWin 4327 {"NZD":0,"GBP":333.33,"SEK":0,"AUD":0,"USD":429.99,"EUR":386.55,"CHF":0,"CNY":0,"PHP":0,"MYR":0,"JPY":47073.15,"NOK":0,"DKK":0,"CAD":561.9,"MXN":0}
20195883 2019 CorelDRAW Graphics Suite X8 for Windows APPDIRECT CorelDRAW Graphics Suite X8 CorelDRAW Graphics Suite X8 5883 {"GBP":370.83,"EUR":462.18,"JPY":46758.33,"CAD":652.37,"USD":499.99,"CNY":0}
20235887 2023 CorelDRAW Graphics Suite X8 for Windows (Japan, China Edition) APPDIRECT CorelDRAW Graphics Suite X8 CorelDRAW Graphics Suite X8 5887 {"GBP":370.83,"EUR":462.18,"JPY":46758.33,"CAD":652.37,"USD":499.99,"CNY":0}
7794240 779 Inkspace APPDIRECT Inkspace Plus Smartpad* plus_columbia 4240 {"MXN":2.99,"PHP":2.99,"GBP":2.49,"NOK":2.99,"CNY":15.39,"JPY":272.73,"USD":2.99,"EUR":2.51,"NZD":2.99,"AUD":2.99,"CHF":2.99,"CAD":2.85,"SEK":2.99}
20155879 2015 Mosketch™ Light for Mac APPDIRECT Mosketch™ Light - 2 Year License Mosketch Light MAC 5879 {"GBP":55.83,"EUR":64.70,"JPY":7304.63,"USD":71.99,"CAD":94.28,"CNY":477.78,"CHF":0,"SEK":0,"MYR":0,"AUD":0,"MXN":0,"DKK":0,"NZD":0,"NOK":0,"PHP":0}
20115871 2011 Mosketch™ Light for Windows APPDIRECT Mosketch™ Light - 2 Year License Mosketch Light WIN 5871 {"GBP":55.83,"EUR":64.70,"JPY":7304.63,"USD":71.99,"CAD":94.28,"CNY":1195.73,"CHF":0,"SEK":0,"MYR":0,"AUD":0,"MXN":0,"DKK":0,"NZD":0,"NOK":0,"PHP":0}
14484268 1448 Muvizu: Pro APPDIRECT Muvizu: Pro MuvizuPro 4268 {"GBP":49.99,"JPY":7271.82,"CNY":0,"CAD":104.75,"USD":79.99,"EUR":75.62}
21556303 2155 Painter® Essentials™ 5 for Windows APPDIRECT PAINTER® ESSENTIALS™ 5 FOR MAC Painter Essentials 5 WIN 6303 {"EUR":25.2,"USD":29.99,"CNY":255.56,"CAD":39.04,"GBP":23.33,"JPY":3054}
21596307 2159 Painter® Essentials™ 5 for Mac APPDIRECT PAINTER® ESSENTIALS™ 5 FOR MAC Painter Essentials 5 MAC 6307 {"EUR":25.2,"USD":29.99,"CNY":255.56,"CAD":39.04,"GBP":23.33,"JPY":3054}
14794331 1479 PaintShop Pro X9 for Windows APPDIRECT PaintShop Pro X9 PaintShopProX9 4331 {"EUR":72.26,"USD":79.99,"CNY":529.06,"CAD":104.75,"GBP":61.66,"JPY":8147.22}
23496869 2349 ParticleShop for Windows APPDIRECT ParticleShop ParticleShopWIN 6869 {"CNY":0,"NOK":0,"DKK":0,"CHF":0,"USD":49.99,"EUR":37.81,"AUD":0,"JPY":5091.67,"GBP":39.16,"SEK":0,"MXN":0,"PHP":0,"NZD":0,"MYR":0,"CAD":65.7}
803 803 sign pro PDF for mobile APPDIRECT sign pro PDF
9032791 903 sign pro PDF for Windows WACOM Recurring Edition* MONTHLY 2791 {"GBP":3.5,"USD":4.09,"CNY":30,"JPY":462,"CAD":4.09,"EUR":4.09}
9032795 903 sign pro PDF for Windows WACOM Yearly* yearly 2795 {"USD":40.9,"JPY":4620,"EUR":40.9,"CNY":300,"GBP":35,"CAD":40.9}

 

Thanks a lot

Venkatesh

Outcomes