Catalogue organisation 2

We need an app running on our Linux server that do the following operations.

Starting from the file “input” attached.

1 – In some cells of the input file we have some “strange” characters �. We have to solve this problem: normally they are letters with the accent like ò à è ì.

2 – The app must add a column in the example file the column AK name of the column IVA and in each line a value X (in the example 22)

3 – Add a column AL with the formula that I added in the example. The approximation must be x,00

4 – Add a column AM with the formula that I added in the example. It must add a space between the elements so that the final result will be, for example “Ariete Yougurella 85/1 Yogurtiere”

5 – add a column AN with the formula that I added in the example

6 – add a column AO. In this column M we have to convert the characters in numbers following this schema: If in the column M there is alta, media or bassa in the column AO we have to insert the number 15. If in the column M there is critica in the column AO we have to insert the number 7

7 – add a column AP. In this column we have to merge the contents of the column F with the column P. for example for the line 2 in the cell AP2 we it will compare

Yogurtiera che permette di ottenere fino ad 1 chilo di yogurt denso e cremoso, dotata di 6 vasetti di vetro con coperchio a vite per essere facilmente trasportati anche fuori casa.

Caratteristiche:

Set di sei vasetti di vetro: Si

Dimensioni: 240x180x140 mm

Peso prodotto imballato: 1.8 kg

Dimensioni scatola: 258x195x139 mm

Cursore mnemonico: Si

capacità totale vasetti: 1kg

Pezzi per master: 6

Pezzi per pallet: 252

Peso Raee: 1,450kg

Marchi di conformità: VDE – CE

If in the line P there are

Pezzi per master: *

Pezzi per pallet: *

Peso Raee: *

We have to delete them. So that the result will be

Yogurtiera che permette di ottenere fino ad 1 chilo di yogurt denso e cremoso, dotata di 6 vasetti di vetro con coperchio a vite per essere facilmente trasportati anche fuori casa.

Caratteristiche:

Set di sei vasetti di vetro: Si

Dimensioni: 240x180x140 mm

Peso prodotto imballato: 1.8 kg

Dimensioni scatola: 258x195x139 mm

Cursore mnemonico: Si

capacità totale vasetti: 1kg

Marchi di conformità: VDE – CE

8 – We need the line spacing like in the result up

9 - Add a column AQ with the formula that I added in the example. It must add a space between the elements so that the final result will be, for example “Ariete Yougurella 85/1 Yogurtiere”

10 – Add a column AR “prezzo sito OK”. In this col AJ there is a number just copy the number. If in the col AJ there is “DA CONTROLLARE A MANO” we have to copy the number that is in the column AF

11 – We need to plan the time that the app will run.

If you have any questions contact me. Thanks! Marco

( 18 reviews ) Aosta, Italy

Project ID: #16498739

Awarded to:

urstealth

A proposal has not yet been provided

€30 EUR in 2 days
(15 Reviews)
4.3

6 freelancers are bidding on average €32 for this job

rinkul123

Hello, I am Debasish. I can make a catalogue organisation for you. I have more than 5 years of experience in working on professional websites and blog designs as well as on developments which consist of relevant ski More

€55 EUR in 10 days
(81 Reviews)
6.6
sushilweb

Hello, Having read your job description, I feel to be a good fit for this job, as I have hands on experience working on the PHP, Mysql, HTML, JQuery Frameworks, as well as Major CMS's like Joomla, WordPress and Magento More

€25 EUR in 10 days
(1 Review)
2.3
cre8ivelezend

Hello There, I read your job description. I am an experience designer. I am expert in Photoshop, Illustrator and coral draw. I am specialist in brochure, banner, logo design etc. Linux, PHP, More

€30 EUR in 0 days
(2 Reviews)
1.8
topmostdesigns

Hi, I am expert designer who can make custom designs. I am specialist in Photoshop, Illustrator and coral-draw. I am expert in Brochure, Flyer, Banner, Business card and logo etc…. Linux, PHP, Python, Software A More

€25 EUR in 0 days
(0 Reviews)
0.0
€25 EUR in 10 days
(1 Review)
0.0