creating tab delim file
Walter Vaughan
wvaughan at steelerubber.com
Wed Oct 24 05:07:18 PDT 2007
Kenneth Brody wrote:
> Quoting scooter6 at gmail.com (Tue, 23 Oct 2007 22:10:27 -0400):
>>I am familiar with using export for ascii and other files -- I predominantly
>>use it to create comma delim files.
>>How would you create a tab delimitted file? I know it's with the delimiter
>>flag but do you use the ascii code for a tab instead of
>>what I normally put as a ',' ??
> f=\t
Here's the fundamental problem (unless it's been fixed since 5.0-ODBC)...
EXPORT ASCII alias = name R=n F=m O=y C=z
Example: Export word-processing files, where "R" is record
indicator, "F" is field separator, "O" is opening
field delimiter, "C" is closing delimiter.
It didn't go on to exlain what the possible values are for "nmyz"
Any modern IDE with command completion would have that.
So even if someone who was going to be a smart alec (like I was) and were to
say, "Put your cursor on a "Then" line and hit F10, then F9, and type EXPORT"
But it really doesn't tell you, and whats worse is below is this
Syntax
EXPORT WORD assign = filename
EXPORT ASCII assign = /pathname r=N f=,
Which I belive would put "N"'s between the records for the bottom example. I
havent tested it but kosher would be EXPORT ASCII assign = /pathname r=\n f=,
Stuff like this is what makes the 20 somethings I show filePro laugh at me for
clinging to my old fashioned ways.
--
Walter
...who has no clue as to why he wrote this message.
More information about the Filepro-list
mailing list