Suoritettu

CSV manipulation on windows

Required Skills:

windows command-line powershell batch shell-script

Need to do this :

Step 1. Add parent folder name to sub-folder as suffix

Step 2. Then add this updated sub-folder name to names of all files present inside sub-folder as suffix

Step 3. Also add the same updated sub-folder name to each cell of Column A as suffix, if the cell has value in it

Elaborating below:

Step 1. Add parent folder name to sub-folder as suffix

parent folder name = 2014

old sub-folder name = January

new sub-folder name = January 2014

old sub-folder name = February

new sub-folder name = February 2014

and so on..

Step 2. Then add this updated sub-folder name to names of all files present inside sub-folder as suffix

Inside sub-folder January 2014

old file name = CE [login to view URL]

new file name = CE 7900 January [login to view URL]

old file name = PE [login to view URL]

new file name = PE 8000 January [login to view URL]

and so on..

Step 3. Also add the same updated sub-folder name to each cell of Column A as suffix, if the cell has value in it

Inside file - CE 7900 January [login to view URL]

Column A

2700

2800

2900

3000

......and so on

New Column A

2700 January 2014

2800 January 2014

2900 January 2014

3000 January 2014

......and so on

Taidot: Microsoft, Powershell

Näytä lisää: how to open csv file without excel, notepad++ csv, lightweight csv editor, free software to open large csv files, csv filter tool, csv viewer, csv explorer, best csv viewer mac, php script read folder file details, html file script add information text file, parse file java add database, script add space lines file, need upload large audio file, folder file listing, need someone excel attached file, add class iif file, add things end file shell script, iis web server redirect folder file, add flv flash file, myspace add friends txt file

Tietoa työnantajasta:
( 4 arvostelua ) New Delhi, India

Projektin tunnus: #19924824

Myönnetty käyttäjälle:

khabibki06

Dear, I have many experience with Qt5/C++. I can create simple windows app GUI to you instead of batch scripts. Feel free to further discussion. Best Regards,

₹1050 INR 2 päivässä
(0 Arvostelua)
0.0

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

dany3j

Hi there! Dear colleague. I can help you with this project. I would like to know more about it. Contact me by Chat to get more information. My Best Regards

₹2050 INR 3 päivässä
(6 arvostelua)
3.3
AdrianCJ

I could append the folder name to files and *.csv. I will need a small sample of the files and folders for testing purposes (maybe zipped). It will be done in powershell. Please let me know when it needs to be ready

₹1350 INR 2 päivässä
(5 arvostelua)
2.3
stackstockers

Hello there, I'm a visual Basic expert, I can get this developed as an app instead of a batch script, all you need to do is copy the exe to the wanted folder, then all CSVs would be fixed I look forward to working wi Lisää

₹2250 INR 3 päivässä
(0 arvostelua)
0.0