Search Results

Hi all,

I have written the script to check the connectivity of the Database ,the scripts show me the correct error when i try to give the wrong credential's but it also show Connected and...

Thanks Scrutinizer for the reply, Sorry i am new to scripting i did not even start with head , please help me out

Hi Unix Gurus,

I have a requirement to write a script, Oracle DB gets referesh every 6hrs, hence we need write a script to connect to the database , if it connects it should generate a file to...

Thanks yazu

Hi Experts ,

My requirement is like this ..
I have source comming as 4,234.55
I need and out put = 4234.55
I need to write a sed command ..

I have already used sed command for multiple...

[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...

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...

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...

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...

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...

Hello Yazu,
I am giving the command as same as you
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
"(49,067)","(1,746)"
...

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...

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 :-
...

Hi Yazu,
Many Thanks!!!
I have a question what will be the code if i want to implement for 1, 2 and 3 columns

Appreciate it !!!

---------- Post updated at 11:02 AM ---------- Previous...

Thanks panyam fro your quick reply!!!
here is the sample data

Input file
first,"Street1,City1,Country1",test1
second,"Street2,City2","test2"
third,"Street3,City3,Country3","A,B,C,D,E"...

Hi Experts,
I actually need to remove multiple commas within the column not the entire row. Its comma delimited file
Actually the value seems to look like 1,006,000, when we open this in notepad or...