Trim white spaces using awk - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Trim white spaces using awk

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
How to trim the white space around a string in C program	hxm1303	High Level Programming	18	10-17-2008 11:43 AM
Two or more white spaces in string	harish_oty	Shell Programming and Scripting	2	10-04-2006 04:29 AM
trimming white spaces	briskbaby	Shell Programming and Scripting	9	09-23-2006 07:10 PM
delete white spaces	DebianJ	Shell Programming and Scripting	2	10-12-2005 02:30 PM
deleting white spaces	cary530	UNIX for Dummies Questions & Answers	10	02-17-2004 01:22 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

07-28-2006

mona

Registered User

Join Date: Nov 2005

Location: Singapore

Posts: 96

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, 42
C, FOOTER, 129

Code:

eval `awk -F,  ' /FOOTER/ {print "set RecordsFound=" $3} 
/HEADER/ { print "set FileBusinessDate=" $4} END{ print "set ActualRecords=" NR-2 }  ' ${SourceDir}/${FileCsv} `

Above is the command which is already present in production and this statement fails since the $3 has spaces in it. So far we didn't get any spaces in the CSV, so this statement was working fine for the past 1 year.

Is there any way to trim the spaces(both leading and trailing spaces) in AWK?

I tried gsub(/ /,"",$3) but it doesn't work

Any help is much appreciated

Thanks in Advance
Mohana

Bookmarks

Tags

awk, awk trim, trim, trim awk

« Different in typing command and using shell script | String matching »

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 03:51 AM.