extract string

[Zhao Peng]

Kenny,

Thank you for your suggestion.

The following line works:
grep univ abc.txt | cut -f3 -d, >> dev.txt.


While the following line intended to remove quotes does NOT work:
grep univ abc.txt | cut -f3 -d, | sed s/\"//g >> dev.txt
It resulted in a line starts with ">" prompt, and not output dev.txt

Could you please double-check or modify it?

Also, if one column is missing, and "," is used to indicate that missing 
column, like the following (2nd column of 3rd line is missing):

"name","age","school"
"jerry" ,"21","univ of Vermont"
"jesse",,,"Dartmouth college"
"jack","18","univ of Penn"
"john","20","univ of south Florida"

Does the "cut" approach still apply? If not, what command would you 
suggest to address this missing issue?

Thank you again.
Zhao


klussier at comcast.net wrote:
> Actually, if you are looking for only lines that contain the string "univ", then you would want to grep for it:
>
> grep univ abc.txt | cut -f3 -d, >> dev.txt.
>
> Paul's example would give you the third field of each line, even if they don't have "univ" in them. Now, if you wanted to remove the quotes, then you would need something like:
>
>
> grep univ abc.txt | cut -f3 -d, | sed s/\"//g >> dev.txt 
>
> FYI,
> Kenny
>
>  -------------- Original message ----------------------
> From: "Whelan, Paul" <Paul.Whelan at fmr.com>
>   
>> Like so: cat abc.txt | cut -d, -f3
>>
>> Thanks.
>>
>> -----Original Message-----
>> From: Zhao Peng [mailto:greenmt at gmail.com] 
>> Sent: Tuesday, January 10, 2006 11:51 AM
>> To: gnhlug-discuss at mail.gnhlug.org
>> Subject: extract string
>>
>> Hi
>>
>> Suppose that I have a file called abc.txt, which contains the following 
>> 5 lines (columns are delimited by ",")
>>
>> "name","age","school"
>> "jerry" ,"21","univ of Vermont"
>> "jesse","28","Dartmouth college"
>> "jack","18","univ of Penn"
>> "john","20","univ of south Florida"
>>
>> My OS is RedHat Enterprise, how could I extract the string which 
>> contains "univ" and create an output file called def.txt, which only has
>>
>> 3 following lines:
>>
>> univ of Vermont
>> univ of Penn
>> univ of south Florida
>>
>> Please suggest the simplest command line approach.
>>
>> Thank you.
>> Zhao
>> _______________________________________________
>> gnhlug-discuss mailing list
>> gnhlug-discuss at mail.gnhlug.org
>> http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss
>>
>> _______________________________________________
>> gnhlug-discuss mailing list
>> gnhlug-discuss at mail.gnhlug.org
>> http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss
>>     
>
>
>
>