DosTips.com

Hi Team, I have a requirement where I need to change the date format of the columns. Here I have provided my script, input file, output file and the desired output file. Please suggest the changes required in my script to get the desired output. Currently I am getting the output in the MM/DD/YY form...

You are going to kick yourself for not seeing how obvious this is. setLocal EnableDelayedExpansion for /f "tokens=1-7 delims=|" %%a in ('parseCSV.bat "/o:|" ^<INPUT.csv') do ( Set str1=%%b set str1=!str1:SALE=SELL! set str1=!str1:PURCHASE=BUY! echo "%%~a",!str1!,"...

Dave Benham Thanks a lot for your help. With your help I could convert the D-Mon-YY ==> MM/DD/YY format. But currently in some of my requirement I need this as MM/DD/YYYY format. Is there any way that I can convert my MM/DD/YY to MM/DD/YYYY format. Or it will be nice if I can directly convert D-Mon...

Why are you not using 7 tokens and a comma as the delimiter. Your examples shows that you are only changing those values in the 2nd field. So you should only be assigning the token %%b to an environmental variable and doing string replacement on that environmental variable. Then you will echo out a...

Could you please post the code you have tried so far. Hi, Please find the code below and the resulted output. Please suggest the changes required in my code to get the desired output. Thanks..!! CODE: setLocal EnableDelayedExpansion For /f "tokens=1-2 delims= " %%a in (INPUT.csv) do ( Set...

Hi Team, I have a requirement where I need to change some of the values of a column of a file. I want SALE to be changed as SELL and PURCHASE to be changed as BUY only in a specific column. Please find my input file and desired output file for clear understanding of my requirement. Please suggest me...

. http://www.dostips.com/forum/viewtopic.php?p=42985#p42985 Hi, I have tried by using the help of the script in the link, please find my script, input and output file. Script: @echo off setlocal enableDelayedExpansion :: Define LF to contain a linefeed (0x0A) character set ^"LF=^ ^" The e...

Since your new revised input data has spaces in it and is not surrounded by quotes, the existing code you are using is not going to work. Hi Squashman, I am currently modifying my script with the help of the link you have provided, but somehow I am still not getting the desired output. I'll do some...

This program fail if wildcard characters (asterisk or question-mark) are included in the fields. Also, it remove exclamation marks. Antonio Hi Antonio, Your code helped me a lot for resolving my issue, but currently I am facing some issue while the input file format is slightly changes. You can fin...

Look at my example. I have replaced the %line% with %%a and %%d for date1 and date2 respectively, but still the script is somehow not correct. Could you please let me know where I'm going wrong? @echo off setlocal EnableDelayedExpansion set m=100 for %%a in (Jan Feb Mar Apr May Jun Jul Aug Sep Oct ...

The above line of code will be used twice inside this FOR /F command. As per your suggestion I have done few changes but I think I'm wrong as the output I'm getting after executing the script is shown below: ",516121,PSAM,",O,Option,42655,"8/21/15 ",516121,PSAM,",CU,Currenc...

Post your code and we will guide you on what you are doing wrong. Hi, Please find the attached code, input file and the output file that i'm getting while executing the script. Script: @echo off setlocal EnableDelayedExpansion set m=100 for %%a in (Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec) d...

Antonio gave you the code to change the date format in your previous thread! http://www.dostips.com/forum/viewtopic.php?p=42984#p42984 You have been given several examples of all the commands you need to use in all your previous threads. Please make an attempt to solve it yourself. Hi Squashman, I ...

Hi Team, I have a requirement where I need to change the date format of the columns. Here I have provided the input file and the desired output file. Please suggest me a script that will do this work. Input File: 17-Aug-15,516121,PSAM,14-Aug-15,O,Option,42655,8/21/15 21-Jan-11,516121,PSAM,17-Aug-15,...

I think those two examples should give you enough information to adjust the script according to the data. Hard to write anything more dynamic without really knowing what all the data actually looks like. Thanks a lot Squashman. Your inputs really helped me a lot. As per changed or different input f...