The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Google UNIX.COM


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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
help me in sending parameters from sqlplus script to unix shell script Hara Shell Programming and Scripting 2 01-29-2008 12:31 PM
Shell Script: want to insert values in database when update script runs ring Shell Programming and Scripting 1 10-25-2007 12:06 AM
here document to automate perl script that call script hogger84 Shell Programming and Scripting 3 10-22-2007 07:15 AM
returning to the parent shell after invoking a script within a script gurukottur Shell Programming and Scripting 5 09-26-2006 04:05 AM
return valuse from child script to parent script borncrazy Shell Programming and Scripting 1 08-20-2004 12:39 PM

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 12-21-2007
Registered User
 

Join Date: Apr 2007
Location: Kolkata
Posts: 81
Thumbs up awk script

Dear All,

i have a awk script and where i want to do all the operation in inside the awk script itself...like i have to pick a certain column then have to delete the trailing space of that column and then have to proceed...

i have tried with sub function but every time i'm getting wrong out put

for e.g.

myfile name is XYZ.txt

here the data of the file

6622880188|2 |5265510105746
6461082164|3 |5265510105746

inside the awk script i want to pick the 2nd field and want to delete the trailing space of 2nd filed.

can any body plz help...

i'm placing my sample script also

awk -v DATE="$CURRDATE" -F'|' 'BEGIN {
while(( getline < "XYZ.txt" ))
{
VALUE=$2 sub(/[ \t]+$/,VALUE "")
print VALUE
.......
.......
}

}' >> FILE_OUT_FINAL.txt


thanks,
Regards,
Pankaj
Reply With Quote
Forum Sponsor
  #2  
Old 12-21-2007
Registered User
 

Join Date: Sep 2006
Posts: 1,580
GNU awk
Code:
awk 'BEGIN{FS="[| ]"} {print $2, length($2)}' file
or
Code:
awk 'BEGIN{FS="|"}
{ 
 sub(/ +/,"",$2)
 print $2
}
' file
Reply With Quote
  #3  
Old 12-21-2007
Registered User
 

Join Date: Apr 2007
Location: Kolkata
Posts: 81
Thumbs up awk script

Dear ghostdog,

thanks for ur reply...
but i'm getting one problemm here...its giving extra number 1
e.g

2
1

3
1

4
1

like this

i'm really soory but i'm not getting the problem. can u plz help?

Thanks,
Regards,
Pankaj
Reply With Quote
  #4  
Old 12-21-2007
Registered User
 

Join Date: Apr 2007
Location: Kolkata
Posts: 81
Question awk script

Dear ghostdog,

after deleting the spaces of the 2nd field the delimiter of the file getting changed...
i want to keep the delimiter as it was

plz help regarding this...

Thanks,
Regards,
Pankaj
Reply With Quote
  #5  
Old 12-21-2007
Registered User
 

Join Date: Dec 2007
Posts: 1
Hi remove the length and try

use the following:
awk 'BEGIN{FS="[| ]"} {print $2}' file
Reply With Quote
  #6  
Old 12-21-2007
Moderator
 

Join Date: Feb 2007
Posts: 2,329
If you have one space in your file:

awk '{print $1$2}' file

Regards
Reply With Quote
  #7  
Old 12-21-2007
Registered User
 

Join Date: Sep 2006
Posts: 1,580
Quote:
Originally Posted by panknil View Post
Dear ghostdog,

after deleting the spaces of the 2nd field the delimiter of the file getting changed...
i want to keep the delimiter as it was

plz help regarding this...

Thanks,
Regards,
Pankaj
Use OFS. Read here for more info. Then try to put it inside this code. Have a shot at it. good luck
Code:
awk 'BEGIN{FS="|"}
{
 sub(/ +/,"",$2)
 print $0
}
' file1
Reply With Quote
Google The UNIX and Linux Forums
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes




All times are GMT -7. The time now is 07:25 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0