can awk print column using a variable ??


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting can awk print column using a variable ??
# 15  
Old 09-18-2006
i checked and written this script with assumption that field delimeter is space.
if your file has different delimeter then make the changes.
if delimeter is tab then use cut without -d option.

Last edited by Dhruva; 09-18-2006 at 05:11 AM.. Reason: typo
# 16  
Old 09-18-2006
Try...
Code:
awk -F '\t' 'FNR==1{split($0,a)}{for(x=1;x<=NF;x++)print $x>a[x]}' jam2.txt
paste $(<jam1.txt) > jam2.txt


Last edited by Ygor; 09-18-2006 at 05:29 AM..
# 17  
Old 09-18-2006
dhruv,
i have tried with cut -d '\t' and also with cut -d "\t"
it is saying invalid delimeter !! is there any other way out ! my real problem is here boss !


Yogor thanks for replay
i tried with your code as well
but it also giving me error.
awk: syntax error near line 1
awk: bailing out near line 1
paste: cannot open MANDT

---I am completely frustrated with this problem don't understand what to do here now plz assist.

I want to just print the selected column from a file which is delimited by tab and not space .
if you can explain me why
awk -v c1=$f1 -v c2=$f2 'BEGIN{FS=OFS="\t"}{print $c1,$c2}' jam2.txt
this is not working it will be of great help to me

Last edited by jambesh; 09-18-2006 at 05:52 AM..
# 18  
Old 09-18-2006
jambesh tab is default delimiter and you don't need to use -d option

Code:
cut -f1 jam2.txt>temp/tempjam0

or
Code:
cut -d 'tab' -f1 jam2.txt>temp/tempjam0

here press tab key in between single quotes.
# 19  
Old 09-18-2006
Try using nawk or gawk.
# 20  
Old 09-18-2006
Dhruv,
Thanks a lot for help , thanks for guiding me all through my problem too.

when i left -d option it said invalid range also when i give a tab in between ' ' and trying it give
cut: invalid character in range . i don't understand acttualy if default is tab delimeter why it is not accepting .

also when i am doing cut -f1 jam2.txt > one.txt
all the field of file jam2.txt is copying to one.txt instead of just column one

Real surprise !!!!! for me

please buddy guide me i am completely frustrated and bitting my head on desk for it

Yogor !!!

i have tried with nawk and gawk too nothing happend boss!

Last edited by jambesh; 09-18-2006 at 06:37 AM..
# 21  
Old 09-18-2006
check on your command line,tab key is pressed in between single and double quotes.

Code:
cut -f1 -d'     ' jamb2.txt

Code:
cut -f1 -d"     " jamb2.txt

if still problem persist then paste the command you are running.

Last edited by Dhruva; 09-18-2006 at 06:50 AM.. Reason: typo
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche

Example: I have files in below format file 1: zxc,133,joe@example.com cst,222,xyz@example1.com File 2 Contains: hxd hcd jws zxc cst File 1 has 50000 lines and file 2 has around 30000 lines : Expected Output has to be : hxd hcd jws (5 Replies)
Discussion started by: TestPractice
5 Replies

2. Shell Programming and Scripting

Awk: Print count for column in a file using awk

Hi, I have the following input in a file & need output as mentioned below(need counter of every occurance of field which is to be increased by 1). Input: 919143110065 919143110065 919143110052 918648846132 919143110012 918648873782 919143110152 919143110152 919143110152... (2 Replies)
Discussion started by: siramitsharma
2 Replies

3. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

4. Shell Programming and Scripting

awk print variable then fields in variable

i have this variable: varT="1--2--3--5" i want to use awk to print field 3 from this variable. i dont want to do the "echo $varT". but here's my awk code: awk -v valA="$varT" "BEGIN {print valA}" this prints the entire line. i feel like i'm so close to getting what i want. i... (4 Replies)
Discussion started by: SkySmart
4 Replies

5. Shell Programming and Scripting

awk command to print only selected rows in a particular column specified by column name

Dear All, I have a data file input.csv like below. (Only five column shown here for example.) Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 3,2,4,5,6 5,3,5,5,6 From this I want the below output Data1,StepNo,Data2,Data3,Data4 2,1,3,4,5 3,1,5,6,7 where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies

6. Solaris

awk - Print variable number of colums from a starting column

Hi guys, I usualy am able to google awk stuff but I can't find it so far and there are so many awking gurus here that I will give it a shot. I want to print $1;$3;"$5 up to the $NF". In other words, I can have 1000 colums, but need to have $5 up to the end. I started with the idea of... (2 Replies)
Discussion started by: plmachiavel
2 Replies

7. Shell Programming and Scripting

Print column with awk

Hi Masters , Need your help regarding the below issue . I am creating a new file with awk where diff rows in a particular column will different according to the user i/p. If user i/p is 10,11 and 12 and requests for 6 rows then in a particular column will print with 10 10 11 11 12... (6 Replies)
Discussion started by: Pratik4891
6 Replies

8. Shell Programming and Scripting

find expression with awk in only one column, and if it fits, print whole column

Hi. How do I find an expression with awk in only one column, and if it fits, then print that whole column. 1 apple oranges 2 bannanas pears 3 cats dogs 4 hesaid shesaid echo "which number:" read NUMBER (user inputs number 2 for this example) awk " /$NUMBER/ {field to search is field... (2 Replies)
Discussion started by: glev2005
2 Replies

9. Shell Programming and Scripting

to print column using awk

suppose u have a file aaaaa aswn 33332 aasdxe sssee 627627 qqhksd dljlljkl 38682682 so have a output 3332 627627 38682682 (2 Replies)
Discussion started by: cdfd123
2 Replies

10. UNIX for Dummies Questions & Answers

Print last 4 columns (variable column #)

I have rows of data with variable number of columns. Is there an easy way to print out the last 4 columns or rather the 4th and 3rd last column? data looks like this: 24 20:51 N 9 10.00 Overcast OVC110 27 11 30.04 1017.7 24 19:51 N 7 10.00 Mostly Cloudy BKN110 28 15... (19 Replies)
Discussion started by: Da_Duck
19 Replies
Login or Register to Ask a Question