Search Results

You are doing it wrong!

To update string: sample to data, use below SQL:
update clusters set name = replace(name, 'sample', 'data');
Before committing select & verify the output:
select name,...

siya,
Your description of what you are trying to do is not at all clear. Looking at the "required result" in message #4 in this thread, I'm guessing that you want to replace PH01 immediately...

One way would besed 's:.:& :10' fileto split, and sed 's: ::' file to merge again.

What makes you think you need to split the 1st column before modifying it?

Why not just modify the 1st 10 characters on the line instead of splitting, modifying the 1st 10 characters on the line,...

If your example is correct, it seems that you basically want to print out everything except the uppercase lines, which could be done easily with
grep -v '^[A-Z]' filename.txt

try:
grep -E "^gi_|^series_|^pattern_" input.txt

Hi rdrtx1,
At least on OS X this doesn't work. Since a is created by a call to sub(), it is being treated as a string instead of as a number in the comparisons that set the minimum and maximum...

How about:
sort -k1.8n infile
Here is the o/p:
# cat infile
>string2991 234445
>string224 470561
>string121 675386
>string4098 177229
>string8049 255838
>string8 672382
>string1115 578415
...

also, another awk example without the need to pipe to sort and sed:
awk '{a=$1;sub("^[^0-9]*","",a);b[a]=$0; m?(0):(m=a); if (a<m) m=a; if (a>x) x=a;}
END{for (i=m; i<=x; i++) {if (b[i])print...

try:
awk '{a=$0;sub("^[^0-9]*","",a);b[a$1]=a":::"$0} END{for (i in b) print b[i]}' infile | sort -n | sed 's/.*::://'

or
sed 's/^\([^0-9]*\)\([0-9]*\)/\2 :::\1\2/' infile | sort -n | sed...