Copy column string and put in different column

Hello

Here is my input:

SU3902 SU3902A NS29C (10) (00) Q1J1 0
SU3902 SU3902B VLR05 (20) (02) Q2H1 4
SU3902 SU3902C NBR22 (30) (06) Q3R5 8
SU3904 SU39047 NSV19 (11) (09) Q4k6 2
SU3904 SU39048 LB231 (12) (05) Q5k1 6
SU3904 SU39049 11VLT (13) (08) Q10C1 10
SU3904 SU3904A 25R05 (15) (06) Q12G1 0
SU3904 SU3904B TR236 (19) (54) Q7Y1 4
SU3904 SU3904C NN255 (28) (15) Q3Z5 25

Output:

SU3902 SU3902A NS29C (10) (00) 1 Q1J1 0
SU3902 SU3902B VLR05 (20) (02) 2 Q2H1 4
SU3902 SU3902C NBR22 (30) (06) 3 Q3R5 8
SU3904 SU39047 NSV19 (11) (09) 4 Q4k6 2
SU3904 SU39048 LB231 (12) (05) 5 Q5k1 6
SU3904 SU39049 11VLT (13) (08) 10 Q10C1 10
SU3904 SU3904A 25R05 (15) (06) 12 Q12G1 0
SU3904 SU3904B TR236 (19) (54) 7 Q7Y1 4
SU3904 SU3904C NN255 (28) (15) 3 Q3Z5 25

just copy number from column 6 after Q and put it before Column 6

Thanks

Hi,

Try this,

nawk '{t=$6;gsub(/[A-Za-z][0-9]$/,"",$6);a=substr($6,2,length($6));$6=a" "t;}1' file

I think you have asked the same kind of question yesterday right??

Cheers,
Ranga:)

Another way in awk using match function :

awk '{match($6,/Q[0-9]+/);$6=substr ($6,2,RLENGTH-1) FS $6}1' input

using sed

$ sed 's/\(.*)\) \([A-Z]\)\([0-9]*\)\(.*\)/\1 \3 \2\3\4/' input.txt
SU3902 SU3902A NS29C (10) (00) 1 Q1J1 0
SU3902 SU3902B VLR05 (20) (02) 2 Q2H1 4
SU3902 SU3902C NBR22 (30) (06) 3 Q3R5 8
SU3904 SU39047 NSV19 (11) (09) 4 Q4k6 2
SU3904 SU39048 LB231 (12) (05) 5 Q5k1 6
SU3904 SU39049 11VLT (13) (08) 10 Q10C1 10
SU3904 SU3904A 25R05 (15) (06) 12 Q12G1 0
SU3904 SU3904B TR236 (19) (54) 7 Q7Y1 4
SU3904 SU3904C NN255 (28) (15) 3 Q3Z5 25