Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Trim inside awk
Top Forums Shell Programming and Scripting Trim inside awk Post 302192172 by subin_bala on Tuesday 6th of May 2008 07:45:20 AM
Old 05-06-2008
Trim inside awk
Hi all,

I am using qwk to parse the logfile.
The code like
awk ' {
if($0 > " ")
{
MSISDN=substr($0,1,10)
HOUR=substr($0,11,6);
ID_SA_SOURCE=substr($0,17,18);
ID_SA_DEST=substr($0,35,18);
ID_VIR_PORTAL=substr($0,53,18);
NW_BEARER=substr($0,71,4);
TERMINAL_TYPE=substr($0,75,1);
TRADE_MODEL=substr($0,76,30);
print HOUR";"MSISDN";"ID_SA_SOURCE";"ID_SA_DEST";"ID_VIR_PORTAL";"NW_BEARER";"TERMINAL_TYPE";"TRADE_MODEL >> "OFR.txt"
}
}' logger_fe.log.199804261105


How can i trim all my variables inside the awk ?

Thanks in advance
Subin
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Trim white spaces using awk

Hi, I have a CSV file with footer information as below. The third value is the number of records in the file. Sometimes it contains both leading and trailing white spaces which i want to trim using awk. C,FOOTER , 00000642 C,FOOTER , 00000707 C, FOOTER,... (2 Replies)
Discussion started by: mona
2 Replies

2. Shell Programming and Scripting

cutting fields and doing trim in awk

hi, I have this code: #!/usr/bin/ksh #SERVICES gzcat *SERVICES* | awk ' { SUBSCRIBERNUMBER=substr($0,1,20) SUBSCRIBERNUMBER=trim(SUBSCRIBERNUMBER) SERVICECODE=substr($0,22,61) SERVICECODE=trim(SERVICECODE) STARTDD=substr($0,63,72) STARTDD=trim(STARTDD) STARTDT=substr($0,74,81)... (1 Reply)
Discussion started by: naoseionome
1 Replies

3. UNIX for Dummies Questions & Answers

Trim String in 3rd Column in Tab Delimited File...SED/PERL/AWK?

Hey Everybody, I am having much trouble figuring this out, as I am not really a programmer..:mad: Datafile.txt Column0 Column1 Column2 ABC DEF xxxGHI I am running using WGET on a cronjob to grab a datafile, but I need to cut the first three characters from... (6 Replies)
Discussion started by: rickdini
6 Replies

4. UNIX for Dummies Questions & Answers

Awk inside Awk expression

Hi, It can be used awk inside other Awk?. I need to get another text processing while other text process. Thank you. (2 Replies)
Discussion started by: pepeli30
2 Replies

5. Shell Programming and Scripting

awk inside another awk statement

hi all, i have two files 1) a.txt one two three 2) abc "one" = 10 pqr "three" = 20 345 "two" = 0 this is what i want in third file (3 Replies)
Discussion started by: shishirkotkar
3 Replies

6. Shell Programming and Scripting

Help with awk trim

I am trying to trim spaces for the fixed width file starting from location 129 and of length 20. I am expecting only around 40 records that will have length greater than 9. But i am getting around 4000 records. Please help me correct the following. nawk '{if (a=length(gsub(/... (2 Replies)
Discussion started by: pinnacle
2 Replies

7. Shell Programming and Scripting

awk - trim white space from a field / variable

Hi, Consider the data (FS = |): 1| England |end 2| New Zealand |end 3|Australia|end 4| Some Made Up Country |end 5| West Indies|end I want the output to be (i.e. without the leading and trailing white space from $2) England New Zealand Australia Some Made Up Country West... (4 Replies)
Discussion started by: Storms
4 Replies

8. Shell Programming and Scripting

HELP with AWK one-liner. Need to employ an If condition inside AWK to check for array variable ?

Hello experts, I'm stuck with this script for three days now. Here's what i need. I need to split a large delimited (,) file into 2 files based on the value present in the last field. Samp: Something.csv bca,adc,asdf,123,12C bca,adc,asdf,123,13C def,adc,asdf,123,12A I need this split... (6 Replies)
Discussion started by: shell_boy23
6 Replies

9. Shell Programming and Scripting

Passing awk variable argument to a script which is being called inside awk

consider the script below sh /opt/hqe/hqapi1-client-5.0.0/bin/hqapi.sh alert list --host=localhost --port=7443 --user=hqadmin --password=hqadmin --secure=true >/tmp/alerts.xml awk -F'' '{for(i=1;i<=NF;i++){ if($i=="Alert id") { if(id!="") if(dt!=""){ cmd="sh someScript.sh... (2 Replies)
Discussion started by: vivek d r
2 Replies

10. Shell Programming and Scripting

Trim using sed/awk

How to remove using the sed/awk if the rows are starting with any numbers till "-" character. from the below sample output and expected results. Sample looks like below : 704 - sample - test 5500 - line2 449 - line3 44 - line4 Line5 Expected - sample - test line2 line3 line4... (5 Replies)
Discussion started by: kiran_hp
5 Replies

LEARN ABOUT CENTOS

tapset::string

tapset::string(3stap)													     tapset::string(3stap)

NAME

       tapset::string - systemtap string tapset

DESCRIPTION

       strlen Returns the length of a string

	      See function::strlen(3stap)
	       for details.

       substr Returns a substring

	      See function::substr(3stap)
	       for details.

       stringat
	      Returns the char at a given position in the string

	      See function::stringat(3stap)
	       for details.

       isinstr
	      Returns whether a string is a substring of another string

	      See function::isinstr(3stap)
	       for details.

       text_str
	      Escape any non-printable chars in a string

	      See function::text_str(3stap)
	       for details.

       text_strn
	      Escape any non-printable chars in a string

	      See function::text_strn(3stap)
	       for details.

       - strtol
	      Convert a string to a long

	      See function::-strtol(3stap)
	       for details.

       isdigit
	      Checks for a digit

	      See function::isdigit(3stap)
	       for details.

SEE ALSO

	 function::strlen(3stap),    function::substr(3stap),	function::stringat(3stap),  function::isinstr(3stap),  function::text_str(3stap),
       function::text_strn(3stap),  function::-(3stap),  function::strtol(3stap),  function::isdigit(3stap),  stap(1), stapprobes(3stap)

IBM
									---						     tapset::string(3stap)
All times are GMT -4. The time now is 09:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy