[SOLVED] Use of "sed" command

Thakowbbery · 11-16-2010, 08:08 AM

Greetings,

I'm working on a script to filter the output of a file.
If I explain the whole thing is gonna take a while, but to sum up:

I have a .csv file with lots of lines, with the following format:

username,someotherinfo

I need to prepare a script so:

1) The content of 'cat file.csv' goes to a variable (DONE)
2) Only the "someotherinfo" from the "cat" command above goes inside a second variable (NOT DONE)

For that I was wondering if I could use "sed", but I have no idea how to use it.

Any ideas?

Thank you very much

BenCollver · 11-16-2010, 08:15 AM

Yes, it is possible with the sed command.

Code:

someotherinfo=$(echo "$contents" | sed 's/.*,//')

It would also be possible to use the cut command.

Code:

someotherinfo=$(echo "$contents" | cut -d , -f 2)

Neither of these will work with data that has commas within quotes. For that there is Perl's Text::CSV.

Thakowbbery · 11-16-2010, 08:18 AM

Quote:

Originally Posted by BenCollver2

Yes, it is possible with the sed command.

Code:

someotherinfo=$(echo "$contents" | sed 's/.*,//')

It would also be possible to use the cut command.

Code:

someotherinfo=$(echo "$contents" | cut -d , -f 2)

Neither of these will work with data that has commas within quotes. For that there is Perl's Text::CSV.

That worked, thank you very much.