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