Shell Programming and Scripting

You can unite all commands in one sed invocation like this (with every command on a separate line):

Code:

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

Hi Yazu

Thanks for your valuable input..I agve the sed command like this below


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

Its working for our scenerio, i will test the original file and get back to you in case of queries..

Thank you
much apprciated
Babu

Hi Yazu/Experts

Any help would be much appreciated!!!

Yazu , some how i could unite all the sed commands like this below


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

It works for some records in file but it rejects for some records in file.
I have attached two files in which Test.txt will work fine with the above sed command,but Sample.txt will reject the records.
No idea why its rejecting..
Can any one please help on this..
Thanks in Advance

Code:

# echo '"(49,076)" ,"(1,746)"'
"(49,076)" ,"(1,746)"
# echo '"(49,076)" ,"(1,746)"' | sed 's/(/-/g;s/)//g'
"-49,076" ,"-1,746"

Hi All

I have input like this "(49,076.25)" ,"(100,74,60)",-4,620.55
I need the otput as -49076.25,1007460,-4620.55

I used the below sed command..
sed -e ':a' -e 's/\("[^"][^"]*\),\([^"][^"]*"\)/\1\2/;ta' test | sed -e 's/\("[^,]*\)[,]\([^"]*"\)/\1\2/g' | sed 's/"//g' | sed 's/(\([0-9.][0-9.]*,\{0,1\}[0-9.]*\))/-\1/g' > new

I am getting almost 95 percent output as -49076.25,1007460,-4,620.55
But if you can see -4,620.55 the comma is not been removed

Please help on this

you dont need to save any reference so can try just sed substitute string

Code:

# a='"(49,076.25)" ,"(100,74,60)",-4,620.55'

Code:

# echo "$a"|sed 's/,\|["()]//g;s/-/,&/;s/^/-/;s/ /,/'
-49076.25,1007460,-4620.55

regards
ygemici

[QUOTE=bshivali;302533846]Hi All

I have input like this "(49,076.25)" ,"(100,74,60)",-4,620.55
I need the otput as -49076.25,1007460,-4620.55

I used the below sed command..
sed -e ':a' -e 's/\("[^"][^"]*\),\([^"][^"]*"\)/\1\2/;ta' test | sed -e 's/\("[^,]*\)[,]\([^"]*"\)/\1\2/g' | sed 's/"//g' | sed 's/(\([0-9.][0-9.]*,\{0,1\}[0-9.]*\))/-\1/g' > new

I am getting almost 95 percent output as -49076.25,1007460,-4,620.55
But if you can see -4,620.55 the comma is not been removed

its only "(49,076.25)" ,"(100,74,60)",-4,620.55
previous quote by y gemici gives me null command on excution

i have concatenated like this

sed -e 's/\("[^,]*\)[,]\([^"]*"\)/\1\2/g' test | sed -e ':a' -e 's/\("[^"][^"]*\),\([^"][^"]*"\)/\1\2/;ta' | sed 's/,\|["()]//g;s/-/,&/;s/^/-/;s/ /,/'
> new

thanks in advance