Shell Programming and Scripting

Hi Experts ,

We have a reuirement that we have to remove multiple comma's within double quotes in the columns as we have already taken care through our sed command .

Here is my code :-

sed -e ':a' -e 's/\("[^"][^"]*\),\([^"][^"]*"\)/\1\2/;ta' $Orign_File > $dummy
sed 's/"//g' $dummy > $Process_file

We have four amount columns that the value comes in negative in Excel it looks like -49,076 .If it is normal negative my script will handle .but the values are formatted in such a way when we look in text pad it looks like “(49,076)” .Can we handle this brackets and retain my negative value , please help in this resolution as i have target date over.

Thanks for your help in advance

Try this:

Code:

% echo '(49,076), (45), (0,123)' | sed 's/(\([0-9][0-9]*,\{0,1\}[0-9]*\))/-\1/g' 
-49,076, -45, -0,123

Hi Yazu/experts,

Thanks for your quick reply , This command woll not work..

I had given values like this
"(49,076)" ,"(1,746)"

but your below command will not work for this
sed 's/(\([0-9][0-9]*,\{0,1\}[0-9]*\))/-\1/g'

Can you please help me out to solve this issue..

How did you check this command? What sed do you have? It works for me:

Code:

% echo '"(49,076)" ,"(1,746)"' | sed --posix 's/(\([0-9][0-9]*,\{0,1\}[0-9]*\))/-\1/g' 
"-49,076" ,"-1,746"

Hello Yazu,
I am giving the command as same as you

Code:

sed 's/(\([0-9][0-9]*,\{0,1\}[0-9]*\))/-\1/g'  file name

and the file name is minus and the values are given like this

Code:

"(49,067)","(1,746)"

And also please see echo why we have that ' " ? its only embeded in double quotes,its comma delimited file
thanks in advance

It's quoted for the shell.

I don't understand:

Code:

% cat filename
"(49,076)" ,"(1,746)"

% sed 's/(\([0-9][0-9]*,\{0,1\}[0-9]*\))/-\1/g' filename
"-49,076" ,"-1,746"

Give an example of the real input.

Hi Yazu ,

I appologise ,it works for me ..Sorry for the confusion..
quick question.., I have wrriten two other sed commands..plus our command ,how do i put all this in loop to check for all this and do the work...

first command replaces multiple comma's
second command replaces double quotes
third command that is your command to retain negative values

sed -e ':a' -e 's/\("[^"][^"]*\),\([^"][^"]*"\)/\1\2/;ta'
sed 's/"//g'
sed 's/(\([0-9][0-9]*,\{0,1\}[0-9]*\))/-\1/g'

Thanks Yazu , you solved my 95 percent of the work!!!