Shell Programming and Scripting

Hi,

I am amazed !!! It works. You people are really expert. Thanks.

Using the above command, I was able to remove quotes within the field. But I can see that there are some newline/breakline characters within the field, which makes a single line breaks into multiple line.

Is is possible to remove the these character as well?

Once again Thanks You.

Use

Code:

tr/"\n\r//d

Thanks it is working.

But I am seeing that it is removing the blank field completely, so field values are not matching up with headers. This is happening in both the cases:

(tr/"//d,$_) and (tr/"\n\r//d,$_ )

Previous:
"INTERNAL","Elsey Marilyn R","","CH "," ENTERPRISE"
After:
"INTERNAL","Elsey Marilyn R","CH "," ENTERPRISE"

Is there any way not to remove blank field completely?

I really appreciate your efforts.

I was confused about something. Use 1 instead of $_ inside grep.

Code:

grep { tr/"\n\r//d,1 }

You are Genius !!! It is working. Thanks.

I hope this is the last question:

What if I dont want to remove the quotes, but add another quotes to quotes, I mean escaping the quotes with quotes.. Something like this:

Previous:
"Internal","1234","HCM","John D","JOHN D","rocks" 12","seigo"

Expected:

"Internal","1234","HCM","John D","JOHN D","rocks"" 12","seigo"

Note: Quotes can occur multiple times within a field.

Then use s/"/""/g. To still handle the newlines, use both:

Code:

tr/\n\r//d,s/"/""/g,1

inside the grep {}

I tried at first, but it is not working.

Even this is not working:

tr/\n\r//d,s/"/""/g,1