Search found 4 matches
- 05 Jan 2018 11:12
- Forum: DOS Batch Forum
- Topic: New CSV column with todays date
- Replies: 4
- Views: 3280
Re: New CSV column with todays date
I am currently receiving help on stackoverflow.com and will update here if a solution is possible. Apologies to anyone frustrated by it being open on two forums.
- 04 Jan 2018 09:11
- Forum: DOS Batch Forum
- Topic: New CSV column with todays date
- Replies: 4
- Views: 3280
Re: New CSV column with todays date
Thank you for your help Squashman. All looked good in 'test' but now I've implemented the code in 'prod' with a 16000+row csv I have 334 rows that didnt get a date added to the end. I re-ran the bat file and the same 334 were missing again. All of the rows have data in column 1 and data upto the sam...
- 03 Jan 2018 06:49
- Forum: DOS Batch Forum
- Topic: New CSV column with todays date
- Replies: 4
- Views: 3280
Re: New CSV column with todays date
I've tried these so far but cant get them to work:
[/code]sed 'N;s/","/","DD/MM/YYYY","/5' file[/code]
Code: Select all
$ awk -F, 'NF>1{$0 = "\"DD/MM/YYYY"\" FS $0}1' file
- 03 Jan 2018 05:21
- Forum: DOS Batch Forum
- Topic: New CSV column with todays date
- Replies: 4
- Views: 3280
New CSV column with todays date
Hi, I only discovered how to create .bat files last week and its starting to change my world (in work). Excitedly I've written a few files to move, copy and rename documents but what I'm trying to now I cant find help with through searching google/forums... Please could a charitable sole help me wit...