There is a caveat with using this method.
the last column of the spreadsheet must contain something or the
resultant lines in the block may be of different length.
Bill.
[EMAIL PROTECTED] wrote:
> Was this: convert-csv.r in lib?
>
> REBOL [
> Title: "Comma-Seperated-Values to REBOL converter"
> Date: 16-Jun-1999
> Author: "Bohdan Lechnowsky"
> Email: [EMAIL PROTECTED]
> File: %convert-csv.r
> Purpose: {
> Convert CSV files to REBOL blocks
> }
> ]
>
> csv: read/lines to-file ask "Filename to convert from CSV: "
>
> block: make block! 100
> headings: parse/all first csv ","
>
> foreach line next csv [append block parse/all line ","]
>
> save to-file ask "Filename to save to: " head insert/only block headings
>
> At 05:47 PM 4/30/2000 -0200, you wrote:
> >
> >Hello, I have a comma separated file which when read into Rebol is a
> string. I need some information on how one would separate this data. I
> have looked at the user guide in particular the series chapter but still
> can not make sense of how you would split up a string of characters. I
> know how to join them together thanks to help from this list. I know this
> should be easy to do.
> >
> >Thanks in advance,
> >Doug
> >
> >
>
> --------------------------------------
> Peter H. Geddes; Savannah, Georgia USA
> <mailto:[EMAIL PROTECTED]>
> --------------------------------------