Bulk text changing script
$10-30 USD
Paid on delivery
Hello,
I have an excel file with Json Object as text in one of the columns. Looks like this:
{"uploads\/images\/tmp_upload\/Lotus_LE80_Authentic_Box_Mod_26":{"filename":"uploads\/images\/100_100\/","alt":"","caption":""},"uploads\/images\/tmp_upload\/Lotus_LE80_Authentic_Box_Mod_25":{"filename":"uploads\/images\/100_100\/[url removed, login to view]","alt":"","caption":""},"uploads\/images\/tmp_upload\/Lotus_LE80_Authentic_Box_Mod_8":{"filename":"uploads\/images\/100_100\/[url removed, login to view]","alt":"","caption":""},"uploads\/images\/tmp_upload\/Lotus_LE80_Authentic_Box_Mod_24":{"filename":"uploads\/images\/100_100\/[url removed, login to view]","alt":"","color":{"color_name":"Blue","color_hex":"#0099CC","selected":"true","primary_image":"[url removed, login to view]"},"caption":""},"uploads\/images\/tmp_upload\/Lotus_LE80_Authentic_Box_Mod_20":{"filename":"uploads\/images\/100_100\/[url removed, login to view]","alt":"","caption":""},"uploads\/images\/tmp_upload\/Lotus_LE80_Authentic_Box_Mod_11":{"filename":"uploads\/images\/100_100\/[url removed, login to view]","alt":"","caption":""}}
I need someone who knows how to replace this text with:
[url removed, login to view]
Then the script should create an additional row with the 2nd image:
[url removed, login to view]
and so on...
The color should also be extracted from the json object into another column
If you have any questions, please write them in the offer itself.
I'm attaching a CSV with 3 rows as an example, the actual file will have about 2000 rows.
Good luck!
Project ID: #11916091
About the project
22 freelancers are bidding on average $29 for this job
Hello Good Day I just had a look at the csv file. I can write the script to do it. I can finish it today itself. Looking forward to work with you. Thanks Rinsad
Yes i can do this in excel by splitting and replacing and then combining while we can also extract color If you like please share file i'll show you demo of 100 rows I am looking to hear from you Thx
Hi there, I would like to complete your project regarding of extracting and replacing of JSON object from excel. Please contact me to start working right now
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y More
Hello. I can help you with this task. I can write a script in AutoIt to handle this. contact me by chat to get more information. Best Regards
Hi, I've done several works similar to this in the past, using VBA. Let me know if you'd like to see some samples. Can start immediately. Available online now, to get started.