Bulk text changing script

Completed Posted 7 years ago Paid on delivery
Completed 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!

Excel JSON PHP Shell Script VB.NET

Project ID: #11916091

About the project

22 proposals Remote project Active 7 years ago

Awarded to:

gayuh

Hi! I would like to offer my service to write Excel VBA script to extract the image URLs from the column with JSON text into separate rows. I am a programmer for client/server, web & mobile applications. Proficie More

$30 USD in 1 day
(78 Reviews)
5.9

22 freelancers are bidding on average $29 for this job

rinsadsl

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

$30 USD in 1 day
(733 Reviews)
8.2
sy3d

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

$50 USD in 1 day
(254 Reviews)
7.0
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Wai More

$30 USD in 1 day
(135 Reviews)
6.3
MyBB

Hi employer. I am a professional developer in PHP, Yii, Wordpress, Laravel, Magento, Joomla, Prestashop, OpenCart, CSS3, HTML5, Jquery. I think i can do this project. Please hire me. You will contentment with my skills More

$35 USD in 1 day
(71 Reviews)
5.7
maha88a

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

$28 USD in 1 day
(27 Reviews)
4.8
MohsanEijaz

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

$30 USD in 1 day
(33 Reviews)
4.6
zkutch

Hello. More 20 years programming experience. I need more details to set real time and price. Regards. -------------------------------------------------------------------------------------------------------------- More

$25 USD in 1 day
(18 Reviews)
4.9
shafimsp

Hi, I have did like this one, you can see "lead manager" in my profile. This project is importing leads and sent bulk mail I have 3+ years experience in web and mobile application development. Looking forward More

$25 USD in 1 day
(3 Reviews)
3.2
dany3j

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

$35 USD in 2 days
(3 Reviews)
2.9
cracken

Hi, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements More

$29 USD in 0 days
(7 Reviews)
2.4
loganup1

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.

$25 USD in 0 days
(1 Review)
1.0
arator

Good afternoon. I understand how to extract particular JSON values and have an examples of code for this in Python. Also I understand how to automate all the process. But I have to undestand a consistent pattern. I di More

$20 USD in 1 day
(0 Reviews)
0.0