What is ASCII Foxed Width or comma delimited format?

G

Guest

I have to submit a table in either an ASCII Foxed Width or Comma delimited
format. MS-Excel worksheets are not permitted. Is tab-delimited the same as
comma-delimited?
 
D

Doug Robbins - Word MVP

That of course should be Ascii Fixed Width.

For such a file, each data field occupies the same number of spaces, so that
entries in each field are padded with spaces to make up the required number.

A comma delimited file is similar to a tab delimited file except that each
field is separated by a comma with the data being enclosed in quotation
marks

"this is the first field data","This is the second field data"¶


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
G

Guest

Yes - ASCII Fixed Wideth - sorry I was in a hurry!

How do I go about setting up these data fields? The instructions say that
each record must be 142 bytes in length. What does this mean?
 
D

Doug Robbins - Word MVP

In a text file, one character (or space) equals one byte.

See http://computer.howstuffworks.com/bytes4.htm

In your case, each record must contain 142 characters or spaces. Each
individual field in a record must contain the same number of characters or
spaces from one record to the next, and the total of characters or spaces in
all of the fields in a record must total 142.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top