RE: create a null character in tab delimited text file - Client Acces s Express

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

Larry Wagner wrote:

>I'm told I need a tab delimited file 
>with spaces before the tabs and null
>values in fields with no data. 

Go back to "who told you" and find out what they mean by "null values."
They may mean (<space><tab>x'00'<space><tab>) or they may mean no character
at all (<space><tab><space><tab>).  If "who told you" can't tell you what
they mean <grin> then have them give you an example from somebody else that
they used successfully.  If they can't do that, have them export one from
their database as an example.  If they can't do that, then it's time to
experiment.  Get a good hex file viewer/editor for the PC you're using and
your life will be much nicer.

Typical comma delimited "nulls" look like this:  "Name","Addr1",,"City"  The
field between Addr1 and City is "null".

Buck Calabro
Aptis; Albany, NY
"We are what we repeatedly do.
 Excellence, then, is not an act, but a habit." --Aristotle


Billing Concepts Corp., a NASDAQ Listed Company, Symbol: BILL
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---