Search found 4 matches

by Ghaty
31 Jan 2017 22:17
Forum: DOS Batch Forum
Topic: add a string or any character in excel row used batch file
Replies: 9
Views: 7705

Re: add a string or any character in excel row used batch file

Hi Steffen,

Thanks for the solution. It's working fine!!
Can set the 'SALDUMMYSN' value only in row 2 and ignore other rows. Because my CSV file is very huge (3000 KB)
and it's taking some time to generate the file. Thanks.
by Ghaty
26 Jan 2017 03:09
Forum: DOS Batch Forum
Topic: add a string or any character in excel row used batch file
Replies: 9
Views: 7705

Re: add a string or any character in excel row used batch file

Below is the requirement: The script will be placed in the folder with CSV files. These CSV files are supposed to contain string (with the prefix “SAL”) on the first column of the 2nd row. If the string is not present, the script will add in a Dummy string (“SALDUMMYSNN”) to the new file. I have att...
by Ghaty
18 Jan 2017 21:59
Forum: DOS Batch Forum
Topic: add a string or any character in excel row used batch file
Replies: 9
Views: 7705

add a string or any character in excel row used batch file

sorry for the inconvenience caused. actually it is csv file. I've configured to read the column 3,5 and 7 to extract the Date,E.Time and Job from the files. The files without SN will cause the row shifted by one column. The parser cannot handle both. Is it possible to add a string (or any character)...