My boss has given me a data which has 3000 rows and a single column and asked me to separate name, zip code, mobile number, product in four columns but every row is different contains the same labels...
text to column has not proven optimal as it is not in the same position
What is the best solution for this..?
1.first row is
{"delivery_address": {"mobile": "1234567809", "city": "Bangkok", "address_string": "55 B ,beera Sar,zipcode:123456", "label": "home"}, "delivery_charges": 0.0, "total_price": 34.0, "is_cod": true, "sub_total": 34.0,, "discount": 0, "user": "hello", "delivery_slot": "In 2 to 5 days from 2012-10-13", "prod_string": "1 x Me-O Wet Cat Food Mackeral 80 G", "order_date": "13-10-2012", "reward": 0, "order_data": [{"name": "Me-O Wet Cat Food Mackeral 80 G", "price": 34.0, "old_price": 40.0, "discount": 15.0, "image": "product_images/Me-O_Wet_Cat_Food_Mackeral_80_g.jpeg", "total": 34.0, "id": 36968, "quantity": 1}], "uuid": "11004511"}
2. second is
{"delivery_address": {"city": "Hanoi", "name": "12-2 bake", "zip": 54321, "locality": "Meher stree ", "mobile": "1234657890", "landmark": "Meher street ", "address_line": "302,Ian Road,Meher street ,Hanoi,500028"}, "delivery_charges": 0.0, "total_price": 637.5, "is_cod": true, "payment_method": 0, "sub_total": 637.5, "discount": 0, "user": "tester", "delivery_slot": "In 2 to 5 days from 2012-10-21", "prod_string": "1 x Happy Cat Litter 10Kg", "order_date": " 21 October 2012", "reward": 0, "order_data": [{"name": "Happy Cat Litter 10Kg", "price": 637.5, "old_price": 750.0, "discount": 15.0, "image": "product_images/Happy_Cat_Litter_10kg.jpeg", "total": 637.5, "id": 36419, "quantity": 1}], "uuid": "11004589"}
Bookmarks