Here's the AppleScript step that I am using, just as an initial test (just to see if I can get it to do anything).
do shell script "tr \"$\" \"\\t\" <\"/Users/Blah/Blah/M C/AIR prospect/aers_ascii_2010q4_done/ascii/DRUG10Q4.TXT \" >TEST_output.txt "
But it is giving me a file not found error. When I use that exact path in the shell itself, it finds it just fine. (I copy the path from the error message, paste it into the shell window, wrap it in quotes, hit return. Works fine.)
Doh! File not found appears to be caused by the trailing space after .TXT. But it seems like the command line wouldn't care about that...
Well, I removed that space and tried the file in a location without spaces in the path, to simplify things. It appears to run now, but there is no output file that I can see. Hmmm...what is the starting directory when you run a shell from AS?