Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
| 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 |
 |
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
03-19-2009
|
|||||
|
|||||
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 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 |
|
03-19-2009
|
||||
|
||||
|
Add another variable
Replace
your line :user_prog_name=$(echo ${line} | awk '{print $3}') by :user_prog_name=$(echo ${line} | awk '{print $3 $4 $5 $6}') (or) user_prog_name=$(echo ${line} | awk '{print $3 " " $4 " " $5 " " $6}') to provide single space " " between $3,$4,$5 and $6 when the values are store in variable. I am post this script after check. It is running fine. concept: here we join the remaining last n coloumn and save it in a variable. byebye.. |
|
03-19-2009
|
|||||
|
|||||
|
Quote:
It can contain 1, 2 or even 5 words with spaces seperating them.  So basically what I want is: from $3 to end of line. How exactly can I achieve it? TIA, Regards, Praveen |
|
03-23-2009
|
||||
|
||||
|
Hi,
Now Replace your line :user_prog_name=$(echo ${line} | awk '{print $3}') by :user_prog_name=$(echo ${line} | awk '{for (a = 3; a <= NF; a++) print $a }') |
| Sponsored Links | ||
|
|
|
| Bookmarks |
| Tags |
| awk, whitespace |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
