I have managed to translate the majority of this script to work in a Windows 7 batch file. I have not tested this against any other version of Windows.
This program scans the command line sent to it and sets various
environment variables that coorespond to the settings.
It sets an OPTION_arg variable for each arg on the command line.
If a switch, the env var is set to 1. If a value is given via the colon sign,
it's set to that value. Note, there can not be any white space around the :
[Modification] This modified script also cannot handle option or parameter values containing spaces, even when encased in parenthesis. [/Modification]
Use If defined OPTION_arg
or if /i "%OPTION_arg%"=="value"
to test for options
It also sets a parameter variable for each paramater entered: PARAM_1
to PARAM_n
and
PARAM_0
is a special value that contains the number of PARAMs. Useful for looping
through all of them. For example for /l (1,1,%PARAM_0%) do ...
In your batch file call getopt as call GetOpt.bat %*
I also recommend setting setlocal
and endlocal
in the host batch file so that
the option and param variables do not stick around after the host batch files exits.
Example usage: HostBatchFile.bat /a /b:22 /longopt Parm1 Parm2
OPTION_a will equal 1.
OPTION_b will equal 22
OPTION_longopt will eqal 1.
PARAM_1 will equal Parm1
PARAM_2 will equal Parm2
PARAM_0 will be set to the number of parms, so 2 in this case
The parts I have not translated are:
- Incorporating any kind of DEBUG flag for screen output
- Being able to handle "strings with spaces" for either options or parameters as the initial separation of arguments fed in are split using
<SPACE>
Here is the translated script.
@echo off
cls
set getopt_ParmCounter=1
set paramc=1
set DEBUG=1
set argc=0
for %%x in (%*) do Set /A argc+=1
echo Number of arguments: %argc%
echo %*&echo.
set _myvar=%*
rem Loop through all command line arguments one at a time
:varloop
set isparam=1
for /f "tokens=1*" %%a in ('echo %_myvar%') DO (
set getopt_Parm=%%a
set _myvar=%%b
call :paramtype
rem shift along arguments and rerun loop
if NOT "%%b"=="" goto varloop
)
goto :eof
:paramtype
rem If first character starts with a - or / it must be an option
if /i "%getopt_Parm:~0,1%"=="-" call :option
if /i "%getopt_Parm:~0,1%"=="/" call :option
if /i "%isparam%"=="1" call :param
goto :eof
:option
set isparam=0
rem Set the Equal Index to the position of the colon. 0 means none was found
for /f %%j in ('findstring %getopt_Parm% :') do set getopt_EqIdx=%%j
rem If the index is GE 0 then we must have a colon in the option.
if /i "%getopt_EqIdx%"=="0" (call :nocolon) else (call :colon)
goto :eof
:colon
rem set the OPTION value to the stuff to the right of the colon
set /a getopt_ParmNameEnd=%getopt_EqIdx%-2
call set getopt_ParmName=%%getopt_Parm:~1,%getopt_ParmNameEnd%%%
call set getopt_ParmValue=%%getopt_Parm:~%getopt_EqIdx%%%
set OPTION_%getopt_ParmName%=%getopt_ParmValue%
goto :eof
:nocolon
rem This is a flag, so simply set the value to 1
set getopt_ParmName=%getopt_Parm:~1%
set getopt_ParmValue=1
set OPTION_%getopt_ParmName%=%getopt_ParmValue%
goto :eof
:param
rem There was no / or - found, therefore this must be a paramater, not an option
set PARAM_%getopt_ParmCounter%=%getopt_Parm%
set PARAM_0=%getopt_ParmCounter%
set /a getopt_ParmCounter+=1
goto :eof
This is how I did it:
- In my Spreadsheet, the audio files were in column F2.
So in a new column (F3) I added the following formula:
=SUBSTITUTE("[sound:#]", "#", F2)
So the final output was like this:
[sound:vocab13en.mp3]
In Anki, I went to my user folder. On a mac this is in USERNAME/ANKI/User1
.
In there, there is a folder called "Collection.media"
Pop all your audio files in that folder (It's worth renaming them with a prefix, so they don't get mixed up as you can't use separate folders. If you do this, rename them in the spreadsheet).
Open Anki and create a new Deck. Create a new card and make sure it has fields for Audio. Click on the "Cards..." button and add the audio field to your template.
Finally, import your spreadsheet making sure the audio column (created in column F3 in step 1) is mapped to your audio field (created in step 3).
Voila! Now all your Anki cards will be imported with audio files.
Best Answer
If you're using
GOTO EOF
at the end of your scripts that are executed, you can simply replace that withEXIT /B
instead and that should work for your need.Example Script