Bulk text changing script

$10-30 USD

Ολοκληρώθηκε

Αναρτήθηκε

πάνω από 7 χρόνια πριν

$10-30 USD

Πληρωμή κατά την παράδοση

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\/[login to view URL]","alt":"","caption":""},"uploads\/images\/tmp_upload\/Lotus_LE80_Authentic_Box_Mod_8":{"filename":"uploads\/images\/100_100\/[login to view URL]","alt":"","caption":""},"uploads\/images\/tmp_upload\/Lotus_LE80_Authentic_Box_Mod_24":{"filename":"uploads\/images\/100_100\/[login to view URL]","alt":"","color":{"color_name":"Blue","color_hex":"#0099CC","selected":"true","primary_image":"[login to view URL]"},"caption":""},"uploads\/images\/tmp_upload\/Lotus_LE80_Authentic_Box_Mod_20":{"filename":"uploads\/images\/100_100\/[login to view URL]","alt":"","caption":""},"uploads\/images\/tmp_upload\/Lotus_LE80_Authentic_Box_Mod_11":{"filename":"uploads\/images\/100_100\/[login to view URL]","alt":"","caption":""}} I need someone who knows how to replace this text with: [login to view URL] Then the script should create an additional row with the 2nd image: [login to view URL] 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!

Ταυτότητα εργασίας: 11916091

Σχετικά με την εργασία

22 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 7 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@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. Proficient in Office VBA, Microsoft .NET + MS SQL Server, PHP + MySQL, and Android platform, I also do graphic design works, primarily UI designs and image editing. I have good attention to details in client's requirements, and once a project starts, I am 100% committed to its completion. I live in Indonesia, my timezone is GMT +7. I look forward to hearing from you. Thank you.

$30 USD σε 1 ημέρα

5,0

(78 αξιολογήσεις)

5,9

22 freelancers δίνουν μια μέση προσφορά $29 USD για αυτή τη δουλειά

@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 σε 1 ημέρα

4,9

(733 αξιολογήσεις)

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 σε 1 ημέρα

4,9

(254 αξιολογήσεις)

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. Waiting for your positive response. Thanks.

$30 USD σε 1 ημέρα

4,9

(135 αξιολογήσεις)

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 if you hire me. Thanks

$35 USD σε 1 ημέρα

4,9

(71 αξιολογήσεις)

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 σε 1 ημέρα

5,0

(27 αξιολογήσεις)

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 your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz

$30 USD σε 1 ημέρα

5,0

(33 αξιολογήσεις)

4,6

@zkutch

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

$25 USD σε 1 ημέρα

4,6

(18 αξιολογήσεις)

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 Regards Shafi

$25 USD σε 1 ημέρα

5,0

(3 αξιολογήσεις)

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 σε 2 ημέρες

4,9

(3 αξιολογήσεις)

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 and we can move forward to the next step. Thanks, Joseph C Ocero

$29 USD σε 0 ημέρα

5,0

(7 αξιολογήσεις)

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 σε 0 ημέρα

5,0

(1 αξιολόγηση)

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 did not find a regularity between input and output in your described example. Can you please reveal me it? After this I can scale a template using Python quite easily.

$20 USD σε 1 ημέρα