I am reading in a file that is basically a csv file but the delimiter is
spaces. I am also using fastercsv to parse the file into an array.
Before fastercsv reads it I am substituting all spaces into commas with
gsub
l.gsub!(" ", ",")
I have one column in each row that could contain spaces. For example
firstname,lastname,phonenumber,streetname,zip
john crichton 555-555-1234 ^A street name with spaces^ 12345
turns into
john,crichton,555-555-1234,A,street,name,with,spaces,12345
I can place the column that could contain spaces at the end of each row
and then call like this but I would like to preserve those spaces.
FasterCSV.parse(l) do |row|
name=row[1]
lastname=row[2]
phone=row[3]
zip=row[4]
street=row[6...10]
Each street name starts with a ^ and ends with a ^. Does anyone know if
there is way I can replace all spaces up until the first ^ and then
begin again after the last ^ so the street name is preserved with spaces
and each column is separated by commas so my result set looks like the
following?
john,crichton,555-555-1234,A street name with spaces,12345
Check out the docs for fastercsv - http://fastercsv.rubyforge.org/ -
it looks like the FasterCSV class has default values for separator and
quote characters. You should be able to change those to ' ' & '^',
respectively.
···
On Dec 13, 2:34 pm, Kvetch Kvetch <kve...@gmail.com> wrote:
I am reading in a file that is basically a csv file but the delimiter is
spaces. I am also using fastercsv to parse the file into an array.
On Dec 13, 2:34�pm, Kvetch Kvetch <kve...@gmail.com> wrote:
I am reading in a file that is basically a csv file but the delimiter is
spaces. �I am also using fastercsv to parse the file into an array.
Check out the docs for fastercsv - http://fastercsv.rubyforge.org/ -
it looks like the FasterCSV class has default values for separator and
quote characters. You should be able to change those to ' ' & '^',
respectively.
On Dec 13, 2:34�pm, Kvetch Kvetch <kve...@gmail.com> wrote:
I am reading in a file that is basically a csv file but the delimiter is
spaces. �I am also using fastercsv to parse the file into an array.
Check out the docs for fastercsv - http://fastercsv.rubyforge.org/ -
it looks like the FasterCSV class has default values for separator and
quote characters. You should be able to change those to ' ' & '^',
respectively.
Thanks yermej. I wasn't using the fastercsv separator because I was
performing some actions on the data before I read it in with fastercsv.
In the end it probably doesn't matter but thank you for your help.
On Dec 13, 2:34�pm, Kvetch Kvetch <kve...@gmail.com> wrote:
I am reading in a file that is basically a csv file but the delimiter is
spaces. �I am also using fastercsv to parse the file into an array.
Check out the docs for fastercsv - http://fastercsv.rubyforge.org/ -
it looks like the FasterCSV class has default values for separator and
quote characters. You should be able to change those to ' ' & '^',
respectively.
Thanks Yermej. I got the quote characters to solve my problem.
Appreciate it.
--
Posted via http://www.ruby-forum.com/\.
I am reading in a file that is basically a csv file but the delimiter is
spaces. �I am also using fastercsv to parse the file into an array.
Check out the docs for fastercsv - http://fastercsv.rubyforge.org/ -
it looks like the FasterCSV class has default values for separator and
quote characters. You should be able to change those to ' ' & '^',
respectively.
On Dec 13, 2:34�pm, Kvetch Kvetch <kve...@gmail.com> wrote:
I am reading in a file that is basically a csv file but the delimiter is
spaces. �I am also using fastercsv to parse the file into an array.
Check out the docs for fastercsv - http://fastercsv.rubyforge.org/ -
it looks like the FasterCSV class has default values for separator and
quote characters. You should be able to change those to ' ' & '^',
respectively.