Search Results

Follow these steps:

Make a copy of this column to another column
Select all data in the new column
Goto Data tab
Select Text to Columns
Specify hyphen - as delimiter
Click Finish

Now...

pamu's proposal works fine if there's always four digit numbers. Should that change, and should "GO" stay the substring where to split the line,try:$ awk '{gsub (/GO/, FS"GO");for (i=2; i<=NF; i++)...

Please give space between awk and filename.

try with..

awk '{for(i=1;i<=length($2);i+=7){print $1,substr($2,i,7)}}' AT.txt > ATTT.txt

ok i got it :)
i added a conditon to code..lets try this..(code still working :) )
# awk 'NR!=1{y=$1;gsub("[0-9]*","",y);split($1,s,"_");gsub("[^0-9]*","",$1);a[c++]=y FS $1}END{for(j=0;j<c;j++){...

Hi Abdul, I looked at your file, try this ;)
# awk 'NR!=1{y=$1;gsub("[0-9]*","",y);split($1,s,"_");gsub("[^0-9]*","",$1);a[c++]=y FS $1}END{for(j=0;j<c;j++){
y=split(a[j],s,"[_...

## A and C pair count ("A_" line and if next line "C_")
# awk '!/^ *$/{if(w==1){x1=xy;x2=$1}else{if($1)x1=$1;getline p;if(p)x2=substr(p,0,13);else...

Add this to the end:


awk '{print$1","$2","$3","$4","$5","$6","$7","$8","$9","$10","$11","$12","$13","$14","$15","$16","$17","$18$","$19","$20","$21","$22","$23","$24","$25","$26}'


Notice...

mysql -u username -ppassword instancename -e "select id,name from table;" |awk '{print$1","$2}'


The above will export those two columns from that table and then put a comma between each one. ...

awk '
{
x[$1]=x[$1] " " $2; # Append 2nd field to contents of x[$1] (followed by a space)
y[$2]=y[$2] " " $1; # Append 1st field to contents of y[$1] (followed by a space)
}
# Now:...