Shell Programming and Scripting

Hi All

I need to put some sed together for a task and its a bit advanced for me, so I thought I'd ask if anyone here could help.

I have a csv file with content like this -

Code:

"['1235','3234']","abcde","[1234]","['1235','3234']"
"'","abcde","[1235]","['1236','2234']"
"[1236]","['1237','1234']","","1234"
"'e'","[1237]","['1238','0234']",""

I need to remove any single quotes that fall between [ ], and also the [ ] themselves.

so -

Code:

"['1238','0234']"

Would become -

Code:

"1238,0234"

While -

Code:

"[1234]"

Becomes -

Code:

"1234"

The other fields containing single quotes are unchanged and no double quotes are removed. Quoted nulls are unaffected as well.

I'd like to do this in sed as it I need to squeeze some performance out of it.

Any help greatly appreciated

Brad

Can something like "'e','e'" show up in your input data?

Hi

Thanks for the response

I'll go with yes on that.

To be honest I'm trying to anticipate some content that a bunch of developers are currently working on. I'm still unclear on exactly what they are going to do but they suggest I need to allow for at least a double quoted string that contains a single quote, so I guess two single quotes in a double quoted string is a possibility.

Cheers

Brad

I guess this is too easy?

Code:

sed "s/[][']//g" myFile

I don't think I completely understand your scenario... I tried and came up with below solution... hope this helps.. I am very new to Unix world, so my apologies for silly things.,

sed -e 's/\[//g' -e 's/\]//g' -e "s/\'//g" testFile

Output:

Code:

"1235,3234","abcde","1234","1235,3234"
"","abcde","1235","1236,2234"
"1236","1237,1234","","1234"
"e","1237","1238,0234",""

regards,
juzz4fun

Afraid you're right, it stripped the single quotes form around the "'e'"

Thanks anyway

Try this:

Code:

perl -nle '@out=();while (/"([^"]*)"/g) {$x=$1;$x=~s/[\047\[\]]//g if $x=~/^\[/;push @out,"\"$x\""}; print join ",", @out' input