In Progress

Batch date adjustment in CSV files

Hi. I need a simple script (or VBA code) that will scan a folder for CSV folders and take each file and adjust the dates in them by a number of days (-10000 to +10000).

Dates are in [login to view URL] format.

The original date format and the rest of the values in each line of the CSV must be kept intact. Program should be able to handle leap years (which if using program function should be easy to calculate new date).

Script should be reasonably well optimized as file size can be around 350Mb. Don't use a language where I need to install heavy footprint to run the script / program! Excel is installed so can use VBA.

For simplicity the script/ program will run from the same folder as the CSV files and use that as the default path.

e.g. -10 days

2020.10.09 --> 2020.08.29

Skills: Visual Basic, Excel, PHP, Excel VBA, C Programming

See more: vbscript parse csv files, plotting csv files excel, google base csv files, net csv files parse, scripting reading csv files, uploading csv files xcart, compare csv files using, using csv files update inventory, compare csv files using excel, multiple csv files csv file using perl, import csv files using microsoft sql server 2005, using adonet csv files, convert text files csv files using vbnet, create table csv files using, collecting multiple csv files ouput excel using vbnet, using adonet read csv files, ebay bulk listing system using excel csv files, compare csv files using perl, using sap idoc create csv files, extract data from csv files using R

About the Employer:
( 40 reviews ) Lumpini, Pathumwan,, Thailand

Project ID: #27832951

10 freelancers are bidding on average $82 for this job


Hello!! I can surely do it. I am Full Stack Developer having more then 6 years experience with different CMS and frameworks. I can ensure you quality work with clean design. Skills: VBA, PHP, WordPress, HTML5/CSS3/ More

$100 USD in 2 days
(68 Reviews)

Why use VBA once you have excel? ♦ Excel Expert ♦ Microsoft Office Certifier ♦ Surely Delivery in 1 Days ♦ Immediate Start ♦ Offering you Professional IT Experience in Excel, data mining, web searching, Web scrapping More

$75 USD in 1 day
(5 Reviews)

Hi, How are you today? Thank you for posting this project, and I'm very happy to bid your project. I've read carefully your project details. I have rich experiences related with your project . Your satisfaction w More

$60 USD in 3 days
(15 Reviews)

❤️ Dear, How are you today? I had ever been made project like this with applescript. I can build with c++ I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. More

$100 USD in 7 days
(1 Review)

Hi client, I am intersting your project. If you give me a chance, I will complete your project with Python or Golang. I can complete it in a short time. Best regards, Alex

$100 USD in 1 day
(1 Review)

hi, i read all your requirement and want to work with you in your requirement for further work plz contact me. thaniks

$75 USD in 4 days
(0 Reviews)

Hello Good day! as I read your requirement I would like to solve the problem that you needed to, when do you need the project to be done?

$60 USD in 3 days
(0 Reviews)

I will do this work quickly as possible so you are interested to come here again and again. I will do this work with 100% accuracy. please inform me about this work soon

$75 USD in 7 days
(0 Reviews)

i am export in data entry and with 3 years experience in that field so i hope to be certified my clint with my work

$83 USD in 5 days
(0 Reviews)

Dear sir I have read your job description and I am very much interested in working your project. I have good experience of the works .

$89 USD in 5 days
(0 Reviews)