Shell Programming and Scripting

you are correct,

but wouldn't be even more precise if the command is

Code:

sed -e 's/[ ]*"/"/g' inputfile>outputfile...

yah....but as in the file was contaning one space before "...but yah it would be better as sed -e 's/[ ]*"/"/g' inputfile>outputfile

Thanks to all of you, I do not have words to express.

Hopefully I can make contribution one day too

Hello Again,

One little change, hopefully this would be an easy one.

The very data element in my file is "1" or "space" and I need this space in the very last field.

I am sure all of you can come up with a solution.

thanks

can u provide the data..and by example what u really want.....can't get urs requirements

Here is my data

I have a file in the format below with about 15 fields per each record. I have 2 records displayed below.

"1234","Andy ","Rich ","0001","123 Main Street ","Dallas ", "1"
"2345","Andrew ","Richter ","0002","234 First Ave ","Kirby ", " "

My Final output needs to be as follows

"1234","Andy","Rich","0001","123 Main Street","Dallas","1"
"2345","Andrew","Richter","0002","234 First Ave","Kirby"," "

I am using the following Sed command and it works excep it also deletes the space in the field and I need the last data element to stay like it is either a "1" or a " " (space).


sed -e 's/[ ]"/"/g' inputfile>outputfile...


what do I need to change in the sed command that I am using to get the result that I am looking for. The above is just the sample of the data, and it is not all data elements, there are quite a few additional fields but the last field is what I have in my data sample.

Thanks