![]() |
|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | 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 here. |
|
|
||||
| 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 |
|
|
Submit Tools | LinkBack | Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
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 |
| Forum Sponsor | ||
|
|
|
#2
|
|||
|
|||
|
GNU awk
Code:
awk 'BEGIN{FS="[| ]"} {print $2, length($2)}' file
Code:
awk 'BEGIN{FS="|"}
{
sub(/ +/,"",$2)
print $2
}
' file
|
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
Hi remove the length and try
use the following:
awk 'BEGIN{FS="[| ]"} {print $2}' file |
|
#6
|
|||
|
|||
|
If you have one space in your file:
awk '{print $1$2}' file Regards |
|
#7
|
|||
|
|||
|
Quote:
Code:
awk 'BEGIN{FS="|"}
{
sub(/ +/,"",$2)
print $0
}
' file1
|
|||
| Google The UNIX and Linux Forums |