NiAdgHuX

1SamplesPrimeAudio[Pack Name]Drums[Sub Category]
2	
3"File" (the file name), "Publisher", "Pack", "Category", "Type"
4	
5"superkick_43.wav", "PrimeAudio", "[Pack Name]", "Drums", [Sub Category]
6	
7PrimeAudio.csv
8	
9@echo off
10
11SET fld="C:UsersCiniqueDesktopNew folder"
12
13FOR /D %%A IN (%fld%*) DO (sqlite3 "%%A%%~nxA.sqlite" "CREATE TABLE IF NOT EXISTS %%~xnA (File TEXT PRIMARY KEY NOT NULL, Publisher TEXT, Pack TEXT NOT NULL, Category TEXT,Type TEXT, Size INT); INSERT INTO `%%~xnA` (File,Pack) VALUES ('This','%%~xnA'); .quit")`
14	
15@echo off
16
17setlocal enabledelayedexpansion
18
19set PassedString=%~1
20set DelimString=%~2
21
22set splitsub=@
23call set tempstring=!PassedString:%DelimString%=%splitsub%!
24
25for /f "tokens=1* delims=%splitsub%" %%A in ("%tempstring%") do set part1=%%A & set part2=%%B
26
27echo Passed = %PassedString%
28echo Part1  = %part1%
29echo Part2  = %part2%
30
31
32PAUSE