Compare the varaible & create the folder of that variable

[Crystina89]

Gents !!

I need a batch script that first pick the country code from the CSV file named as Country_Code.csv and then make a folder of that country code in this format AMX - <country_code>
e.g. i have one code EGT in the Country_code.csv file so it make a folder of this code as AMX - EGT and if this folder is already exist then that script don't allow me to recreate this folder.

In above script i also want one more thing like if the country code is UK then it always make a folder of this name AMX - ZZZ

Country_Code.csv has these values :

- UK
- US
- EGT

I am in very difficult situation due to this script .
Please advise me in this matter.I really appreciate your efforts in advance.

[Endoro]

Post the entire "Country_Code.csv".

[foxidrive]

Country_Code.csv has these values :

- UK
- US
- EGT

That is not a CSV format. Did you post the file correctly?

[Crystina89]

Here is the TEXT file values..

- NOR
- SW
- BE
- US
- UK
- EGT

Yes i didn't put csv values .Can you please assist me in this regard ? Like as i mentioned above that i have to create folder of that country code .

[foxidrive]

Try this. It assumes that the minus sign and space you showed is included in the "- code" on every line.

Code: Select all

@echo off
set "folder=C:\Batch\Script\ABC\CSVSPOOL\TEST"
for /f "delims=" %%a in (Country_Code.csv) do (
if /i "%%a"=="- UK" (
md "%folder%\AMX - ZZZ" 2>nul
) else (
md "%folder%\AMX %%a" 2>nul
)
)

[Crystina89]

Hey what if - i want this new folder should be create under the predefined path that is for example i have already defined the path like

@echo off
set LOCATION = C:\Batch\Script\ABC\CSVSPOOL\TEST

Now that new hard coded folder should create under TEST folder .In this case what should i do ?

[foxidrive]

I edited my post above to add that.

[Crystina89]

Do you think the below code is correct or make any sense ??Actually i cant try this code multiple times as i am doing work on PROD environment

@echo off
set folder = C:\Batch\Script\ABC\CSVSPOOL\TEST

REM Get Names of Affiliates to process from txt file
for /f "tokens=*" %%a in ('type Country_Code.txt') do (

set code=%%a
REM SET code=!code: =!
SET code=!code:-=!
echo Country Name : !code!

For /f "delims=" %%a in ('type Country_Code.txt') do (
IF /i "%%a"=="- UK" (
md "%folder%\AMX - ZZZ\Source Files\" 2>nul
) else (
GOTO : EXIST
)
)

echo Look for path : "AMX - %%a\Source Files\"
IF NOT EXIST "%folder%\AMX - %%a\Source Files\" (
echo Path Does not exist
echo .
)
: EXIST

IF EXIST "%folder%\AMX - %%a\Source Files\" (
echo Path exists

[foxidrive]

I'd like to see a 'Thank You' and a message saying if it worked for you.

It should do what you asked for, given the information you provided.

[Crystina89]

hahhahha..

Thank you so much for your quick help and guidance.

Cheers !!