Processing and Conversion of Excel Data
1 .Basic data
2ndHow should it look in the outcome table:
Initially, the picture list is like:
1 .If one image is AB-0203.jpg
2ndIf two or more images - AB-0203.jpg, AB-0203+1.jpg, AB-0203+2.jpg, AB-0203+3.jpg .... etc.that is.dop images are marked as +1, +2, +3...
You need to do:
1 .Column 1-Articles (clean the values of the column with the names of the images to the symbol "+" included or the extension ".jpg" if there is no "+").If in the second column was AB-0203+1.jpg, then in the first should be AB-0203
If in the second column was AB-0203.jpg, then in the first should be AB-0203.
2ndColumn 2 - leave the name of the images, as is AB-0203+1.jpg, AB-0203.jpg....
ThreeColumns 3, 4, 5.... - we form links to the images and we put each into our column consistently - everything should be in one line with the article!The link looks like: https://autotools.in.ua/images/intertool/image name
- https://autotools.in.ua/images/intertool/AB-0203.jpg
- https://autotools.in.ua/images/intertool/AB-0203+1.jpg
- https://autotools.in.ua/images/intertool/AB-0203+2.jpg
- https://autotools.in.ua/images/intertool/AB-0203+.jpg and so on
Work results
Client's review of cooperation with Leonid B.
Processing and Conversion of Excel DataThe task is done according to the description. Everything is fine, I hope for further cooperation.
Freelancer's review of cooperation with Aleksey O.
Processing and Conversion of Excel DataClear TZ, a minimum of questions. In connection ! Pleased with cooperation.
-
744 99 0 Hello to you,
I do it quality and quickly.
Experience in Excel VBA over 5 years. You can see in the reviews.
I will be happy to help!
-
421 13 0 Hello to you!
I work with Excel and Google tables.
Ready to help with the formula or macro (scripts).
I will be happy to cooperate.
-
2073 116 0 Good morning, I can write a program to process the Excel file. Please call me, I'll be glad to help!
-
345 22 0 Hello to you. Ready to fulfill your task. If you are interested in the candidacy, write to L.S.
-
157 5 0 Hello to you!
Study the task, manipulations generally unmistakable are required. Ready to fulfill this order!
-
228 Hello to you!
Ready to fulfill your task.
I have a great experience in working with formulas in MS Excel.
It requires some clarification. This does not affect time and cost.
-
238 5 1 Hi, there is experience contact I will be happy to help.
...
...
-
8205 381 0 1 Good day . Interested in your project. Ready to discuss and implement.
Current freelance projects in the category Desktop Apps
Add pauses of 10-30 seconds between sending emails.Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 2 days 9 hours back ∙ 10 proposals |
Reverse engineering of console utilities for querying SSD controllers (Flash ID)1. Purpose of the work Extraction of the application programming interface (API) for interaction with SSD/NVMe controllers from the provided set of console utilities (Phison, Silicon Motion, Realtek, Maxiotek, Marvell, JMicron, etc.). The result should be working code in C/C++… C & C++, Desktop Apps ∙ 2 days 20 hours back ∙ 5 proposals |
Modification in the emulator's operation
45 USD
Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save… Desktop Apps ∙ 10 days 10 hours back ∙ 10 proposals |