awk print specific columns one row at a time Post: 302543944

Sponsored Content

Top Forums Shell Programming and Scripting awk print specific columns one row at a time Post 302543944 by pr0tocoldan on Tuesday 2nd of August 2011 12:57:58 PM

08-02-2011

Registered User

awk print specific columns one row at a time

Hello,

I have the following piece of code:

roleName

=`cat $inputFile | awk -F';' '{ print $1 }'`

roleDescription

=`cat $inputFile | awk -F';' '{ print $2 }'`

roleAuthProfile

=`cat $inputFile | awk -F';' '{ print $3 }'`

mappedUserID

=`cat $inputFile | awk -F';' '{ print $4 }'`

mapType

=`cat $inputFile | awk -F';' '{ print $5 }'`
userID=`cat $inputFile | awk -F';' '{ print $6 }'`

What I'm trying to do is extract input from specific columns for a script. I'm using the ";" as my delimeter.

The problem I'm having is that even though I'm putting this code in a loop, I'm getting the value of the whole column as my variable rather than the string within the delimiter.

(for properties in $inputfile
do: the piece of code above
done)

I want to get one line at a time from the specified column.

Does anyone know what I could be doing wrong?

pr0tocoldan

View Public Profile for pr0tocoldan

Find all posts by pr0tocoldan

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Insert a text from a specific row into a specific column using SED or AWK

Hi, I am having trouble converting a text file. I have been working for this whole day now, still i couldn't make it. Here is how the text file looks: _______________________________________________________ DEVICE STATUS INFORMATION FOR LOCATION 1: OPER STATES: Disabled E:Enabled ...

2. Shell Programming and Scripting

shell script(Preferably awk or sed) to print selected number of columns from each row

Hi Experts, The question may look very silly by seeing the title, but please have a look at it clearly. I have a text file where the first 5 columns in each row were supposed to be attributes of a sample(like sample name, number, status etc) and the next 25 columns are parameters on which...

3. Shell Programming and Scripting

Print columns from each row

I have awk command to print column 8 awk '/select/ {print $8}' which will print column 8 But I need to print 3, 5 and 8 column in a row and each column should be de-limited by "\t" Hope anyone help me quickly.

4. Shell Programming and Scripting

Need awk help to print specific columns with as string in a header

awk experts, I have a big file of 4000 columns with header. Would like to print the columns with string value of "Commands" in header. File has "," separator. This file is on ESX host with Bash. Thanks, Arv

5. Shell Programming and Scripting

awk compare specific columns from 2 files, print new file

Hello. I have two files. FILE1 was extracted from FILE2 and modified thanks to help from this post. Now I need to replace the extracted, modified lines into the original file (FILE2) to produce the FILE3. FILE1 1466 55.27433 14.72050 -2.52E+03 3.00E-01 1.05E+04 2.57E+04 1467 55.27433...

6. Shell Programming and Scripting

Print unique names in each row of a specific column using awk

Is it possible to remove redundant names in the 4th column? input cqWE 100 200 singapore;singapore AZO 300 400 brazil;america;germany;ireland;germany .... .... output cqWE 100 200 singapore AZO 300 400 brazil;america;germany;ireland

7. Shell Programming and Scripting

Grep and print only certain columns from a row

Hi Friends, This is my input chr1 100 200 + gene_name "alpha"; protein_name "alpha"; level 2; tag "basic"; info "known"; chr1 245 290 + gene_name "alpha-1"; protein_name "alpha-2"; level 9; tag "basic"; info "uknown"; chr1 310 320 + gene_name "alpha"; protein_name "alpha-4"; level 2; info...

8. Shell Programming and Scripting

Match columns and print specific field

Hello, I have data in following format. ...

9. Shell Programming and Scripting

Convert Second Column Date Into EPOCH Time And Print Complete Row

Hello Team, I am stuck in getting the required output in the following case. Please help. My input file is aa|08/01/2016 bb|08/15/2016 I wish to convert the file into aa|epoch time bb|epoch time I am using following code:

10. Shell Programming and Scripting

Using awk to change a specific column and in a specific row

I am trying to change the number in bold to 2400 01,000300032,193631306,190619,0640,1,80,,2/ 02,193631306,000300032,1,190618,0640,CAD,2/ I'm not sure if sed or awk is the answer. I was going to use sed and do a character count up to that point, but that column directly before 0640 might...

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Insert a text from a specific row into a specific column using SED or AWK

Discussion started by: Issemael

2. Shell Programming and Scripting

shell script(Preferably awk or sed) to print selected number of columns from each row

Discussion started by: ks_reddy

3. Shell Programming and Scripting

Print columns from each row

Discussion started by: elamurugu

4. Shell Programming and Scripting

Need awk help to print specific columns with as string in a header

Discussion started by: arv_cds

5. Shell Programming and Scripting

awk compare specific columns from 2 files, print new file

Discussion started by: jm4smtddd

6. Shell Programming and Scripting

Print unique names in each row of a specific column using awk

Discussion started by: quincyjones

7. Shell Programming and Scripting

Grep and print only certain columns from a row

Discussion started by: jacobs.smith

8. Shell Programming and Scripting

Match columns and print specific field

Discussion started by: Pushpraj

9. Shell Programming and Scripting

Convert Second Column Date Into EPOCH Time And Print Complete Row

Discussion started by: angshuman

10. Shell Programming and Scripting

Using awk to change a specific column and in a specific row

Discussion started by: juggernautjoee