Unable to assign value to variable using awk coz of whitespace in value

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Unable to assign value to variable using awk coz of whitespace in value

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Assign o/p of awk to a variable	c2b2	Shell Programming and Scripting	8	04-01-2009 07:50 AM
assign a value to a variable	Shivdatta	Shell Programming and Scripting	10	01-17-2007 07:40 AM
assign value to variable using AWK	HAA	Shell Programming and Scripting	4	12-06-2006 11:43 AM
assign a value to variable	markjason	Shell Programming and Scripting	3	10-10-2006 02:05 PM
assign to variable	AkumaTay	UNIX for Dummies Questions & Answers	1	05-18-2002 02:11 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

03-19-2009

sunpraveen sunpraveen is offline

Registered User

Join Date: Jan 2009

Location: Pruthvi

Posts: 85

Unable to assign value to variable using awk coz of whitespace in value

Unix gurus,

I have a file as below, which is basically the result set obtained from a sql query on an Oracle database.

Code:

ID           PROG_NAME      USER_PROG_NAME
-------- --------------- ----------------------------------------
33045      INCOIN             Import Items
42690      POXPOPDOI       Import Standard Purchase Orders

I want to assign the results to variables. Something like:

Code:


cat filename | tail +4 | while read line ## tail +4 because the first 3 lines are the heading!
do
id=$(echo ${line} | awk '{print $1}')
prog_name=$(echo ${line} | awk '{print $2}')
user_prog_name=$(echo ${line} | awk '{print $3}')

However, I am unable to assign the 3rd column to variable user_prog_name since it has spaces.

How can I overcome this problem?

TIA,

Regards,

Praveen

Bookmarks

Tags

awk, whitespace

« retrieve part of file path | Easy Checkup Script »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 09:29 AM.