A quick post for my own future reference, primarily.
After banging me face off the desk for a while trying to figure out how to batch-convert a heaping spoonful of space-laden-named Excel files to CSV for a project I’m doing for my wife, I found a solution in the $IFS environment variable. Thus:
#!/bin/bash IFSTMP=$IFS; IFS=$(echo -en "\n\b"); for i in $(ls -1 *.xls); do xls2csv $i > $i.csv 2>/dev/null; done; IFS=$IFSTMP;
Easy as pie. And I don’t mean like a mince pie or something that many folks don’t even like, but like convincing toddler to eat a chocolate cream pie. Yeah, that easy.