creating tab delim file

[scooter6 at gmail.com]

On 10/24/07, Walter Vaughan <wvaughan at steelerubber.com> wrote:
>
> 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.



FWIW - I did look at the help in processing for the proper way to create
what I wanted but the
help for export is pretty limited in that it doesn't tell you much other
than how to use a comma as a delimiter -- what if you wanted to use a pipe
or some other character (which oddly enough I have gotten requests for from
other databases I work with, etc)
Thanks again

Scott
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20071024/372be1c7/attachment.html