delimiters -- Irish Dancing Webbies

[ Show ]

Support VoyForums

[ Shrink ]

VoyForums Announcement: Programming and providing support for this service has been a labor of love since 1997. We are one of the few services online who values our users' privacy, and have never sold your information. We have even fought hard to defend your privacy in legal cases; however, we've done it with almost no financial support -- paying out of pocket to continue providing the service. Due to the issues imposed on us by advertisers, we also stopped hosting most ads on the forums many years ago. We hope you appreciate our efforts.

Show your support by donating any amount. (Note: We are still technically a for-profit company, so your contribution is not tax-deductible.) PayPal Acct: Feedback:

Donate to VoyForums (PayPal):

[ Login ] [ Contact Forum Admin ] [ Main index ] [ Post a new message ] [ Search | Check update time | Archives: 1, [2], 3 ]

[ Next Thread | Previous Thread | Next Message | Previous Message ]

Date Posted: 09:37:30 07/18/02 Thu
Author: Jenny
Subject: delimiters
In reply to: jessie-rae 's message, "oooooooooooooooooohhhh." on 09:11:56 07/16/02 Tue

a delimiter is something that separates data. for example this line is delimited by a comma:

CUSTOMERID,FIELDTYPE,FIELDNAME,FIELDSIZE,LATITUDE,LONGITUDE,COUNTY,STATE,PRODUCTTYPE,ELEV,TWN,RNG,SEC

that's what it would look like in a text file. for excel, just identify each header cell by the actual name (ie CUSTOMERID) and don't put any comma's or extra columns in. a few other things to know about excel if you want to make csv files: 1) only one worksheet at a time can be converted into a csv file; the others would be lost, so if you have more than 1, make them all separate files before converting them to csv files. 2) all formatting will be lost, as in colors, fonts, etc. 3) don't use comma's or tabs in the actual data cells, for example, for a column called NAME this is okay:
JENNY CONNORS

and this is okay:
CONNORS; JENNY

but this is NOT okay:
CONNORS, JENNY

that comma would tell the program that "Jenny" belongs in the next column!

once you have your excel spreadsheet set up okay, "save as" and pick CSV (Comma delimited)(*.csv) as the type of file. You could then open this file in excel or in notepad, as well as import it to dreamweaver

if you or your friend need more information on how to do this, let me know! i'd be glad to help.

[ Next Thread | Previous Thread | Next Message | Previous Message ]