marcorodas
/ Make Diretory With Filenames.bat
Last active
January 20, 2019 18:45
Batch directory creation based on filenames in title case
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| powershell -command "Get-ChildItem . -File | %%{$_.Name.TrimEnd($_.Extension)} | %%{(Get-Culture).TextInfo.ToTitleCase($_.ToLower())} | ForEach-Object {new-item -Name $_ -ItemType directory}" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| TRUNCATE TABLE dua_xlsx; | |
| LOAD DATA | |
| LOCAL INFILE 'C:\\Users\\skynet\\AppData\\Local\\Temp\\dua_xlsx.csv' | |
| INTO TABLE `file_collection`.`dua_xlsx` | |
| CHARACTER SET latin1 | |
| FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' | |
| IGNORE 1 LINES; | |
| SELECT COUNT(*) FROM dua_xlsx; |
marcorodas
/ Microsoft software products for FREE
Created
March 29, 2019 07:20
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| https://msguides.com/ |
OlderNewer