Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Columnn number gwak

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Columnn number gwak
# 1  
Old 12-07-2017
Columnn number gwak
Hello,

I've file with 42847 tab sep columns. For demo purpose I'm going to put 6 columns.
Input data (6 columns)

Code:
ABCA7   INDO    0.0316847       LARS    0.0400374       ADCK4
CD33    INDO    0.0266461       LARS    0.0970214       ADCK4
TREM2   INDO    0.0179237       LARS    0.0998961       ADCK4
ABCA7   INDO    0.0316847       LARS    0.0400374       ADCK4
CR1     INDO    0.0151277       LARS    0.0378186       ADCK4
PTK2B   INDO    0.0240611       LARS    0.0438327       ADCK4

Code:
cut -f -6  test_input_data.txt  | grep "CR1"  |  gawk -v OFS='\t' '{ for (i;i<=NF ;i++)  { if ( $i ~ /LARS/ ) {print i} } }'

I'm cutting 6 columns from input file so I can grep CR1.
Next I'm interested to get column number of LARS in the grepped output.

I get output as

Code:
4

1)
A blank line and 4. It looks OK, but I don't know why I get a blank line.

I got code from link


Moderator's Comments:
Mod Comment Please use correct CODE tags as required by forum rules!
Last edited by RudiC; 12-07-2017 at 01:17 PM.. Reason: Changed QUOTE to CODE tags.
# 2  
Old 12-07-2017
Try for (i=1; ...
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

List files with number to select based on number

Hi experts, I am using KSH and I am need to display file with number in front of file names and user can select it by entering the number. I am trying to use following command to display list with numbers. but I do not know how to capture number and identify what file it is to be used for... (5 Replies)
Discussion started by: mysocks
5 Replies

2. Shell Programming and Scripting

awk to find number in a field then print the line and the number

Hi I want to use awk to match where field 3 contains a number within string - then print the line and just the number as a new field. The source file is pipe delimited and looks something like 1|net|ABC Letr1|1530||| 1|net|EXP_1040 ABC|1121||| 1|net|EXP_TG1224|1122||| 1|net|R_North|1123|||... (5 Replies)
Discussion started by: Mudshark
5 Replies

3. UNIX for Advanced & Expert Users

Help with gwak command

Hello, I need help with gwak command. I have this output 123456_BLA_BLA I would like to print the first 6 charaters (123456) using gwak command. thanks for your help in advance (3 Replies)
Discussion started by: miltonrods
3 Replies

4. Shell Programming and Scripting

Help with sort word followed by exponential number and numeric number at the same time

Input file: ID_34 2E-69 2324 ID_1 0E0 3254 ID_1 0E0 5434 ID_5 0E0 436 ID_1 1E-14 2524 ID_1 5E-52 46437 ID_3 65E-20 45467 ID_1 0E0 6578 ... Desired output file: ID_1 0E0 6578 ID_1 0E0 5434 ID_1 0E0 3254 ID_1 5E-52 46437 ID_1 1E-14 2524 ID_3 65E-20 45467 (5 Replies)
Discussion started by: cpp_beginner
5 Replies

5. Shell Programming and Scripting

The difference between end number in the early row and the start number in the next

Hi Power User, I'm trying to compute this kind of text file format: file1: jakarta 100 150 jakarta 170 210 beijing 220 250 beijing 260 280 beijing 290 320 new_york 330 350 new_york 370 420 tokyo 430 470 tokyo 480 ... (2 Replies)
Discussion started by: anjas
2 Replies

6. Shell Programming and Scripting

AWK print number of records, divide this number

I would like to print the number of records of 2 files, and divide the two numbers awk '{print NR}' file1 > output1 awk '{print NR}' file2 > output2 paste output1 output2 > output awl '{print $1/$2}' output > output_2 is there a faster way? (8 Replies)
Discussion started by: programmerc
8 Replies

7. Shell Programming and Scripting

Perl : print the sequence number without missing number

Dear Perl users, I need your help to solve my problem below. I want to print the sequence number without missing number within the range. E.g. my sequence number : 1 2 3 4 5 6 7 8 11 12 13 14 my desired output: 1 -8 , 11-14 my code below but still problem with the result: 1 - 14 1 -... (2 Replies)
Discussion started by: mandai
2 Replies

8. Shell Programming and Scripting

changing number in bash (number is in form of string)

I have a txt file as database. when i run my program what it does is it ask me for 3 name and stored in the file as name1:name2:name3:1 when u enter 3 name it add those in file as above format and add 1 at the end. I what i want is if i enter same names again it changes that 1 to 2 and so... (3 Replies)
Discussion started by: Learnerabc
3 Replies

9. Shell Programming and Scripting

Number lines of file and assign variable to each number

I have a file with a list of config files numbered on the lefthand side 1-300. I need to have bash read each lines number and assign it to a variable so it can be chosen by the user called by the script later. Ex. 1 some data 2 something else 3 more stuff which number do you... (1 Reply)
Discussion started by: glev2005
1 Replies
Login or Register to Ask a Question