Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk - trim white space from a field / variable
Top Forums Shell Programming and Scripting awk - trim white space from a field / variable Post 302666531 by Storms on Wednesday 4th of July 2012 04:25:20 PM
Old 07-04-2012
awk - trim white space from a field / variable
Hi,

Consider the data (FS = |):
Code:
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)
Code:
England
New Zealand
Australia
Some Made Up Country
West Indies

any ideas on how its done in awk??

---------- Post updated at 03:25 PM ---------- Previous update was at 03:07 PM ----------

this works
Code:
BEGIN {
        FS = "|"
        OFS = "|"
}
{
gsub(/^[ \t]+|[ \t]+$/, "", $2); print $2
}

Last edited by Storms; 07-04-2012 at 05:20 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to trim space in output variable ?

Hi , I have a code like this: uid=scott password=tiger database=db01 cat >runid_val.sql<<-EOA SET ECHO OFF SET FEEDBACK OFF SET HEADING OFF SELECT trim(runid_seq.nextval) FROM dual; EXIT EOA echo `cat runid_val.sql` V_RUNID=`sqlplus -s $uid/$password@$database @runid_val.sql`... (5 Replies)
Discussion started by: vj_76
5 Replies

2. 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

3. Shell Programming and Scripting

Unix code to fetch the first field till space in a variable

Hi, I want to get the value of the first field till space in a variable. e.g x=323 /test/personel/logs/File1 I want to get the first field till space i.e 323 in another variable ,lets say y. echo $x|cut -d' ' -f1 gives 323 but when I'm trying y=`echo $x|cut -d' ' -f1 its giving... (3 Replies)
Discussion started by: autosys_nm
3 Replies

4. Programming

How to trim the white space around a string in C program

I am coding a C program to read a plain text file. There are a lot of blank fields or a string with white spaces. I want to know is there such a function called trim() in C to clean the white space around a string? Or some other way can do this efficiently? Thanks. (18 Replies)
Discussion started by: hxm1303
18 Replies

5. Shell Programming and Scripting

awk get rid of space in end of field

Hello. I'm using a file to "grep" in a 2nd one (with awk) cat file1 2 first user 9 second user 1 third user (with a space after user) I want to get the line except the 1st field so I do : field=$(gawk '{$1 =""; print $0}' file | sed 's/^ //') It works but it deletes... (5 Replies)
Discussion started by: xanthos
5 Replies

6. Shell Programming and Scripting

nested double quota and white space inside variable

I have a question about nested double quotes. Any help is appreciated. Here are my commands on Mac OS. # string="Ethernet \"USB Ethernet\" \"Bluetooth DUN\" AirPort FireWire \"Bluetooth PAN\"" # echo $string Ethernet "USB Ethernet" "Bluetooth DUN" AirPort FireWire "Bluetooth PAN" #... (3 Replies)
Discussion started by: lindazhou
3 Replies

7. Shell Programming and Scripting

awk: Eliminating white space while setting variable

Hi, I have a large flat file from host without delimiter. I'm transforming this file to a csv file using statements like # Row 03: Customer / field position 3059 +20 WOFABNAM=substr( $0, 3059, 20 ); and deleting the trailing whitespaces before and after with that sub( /^ +/, "",... (4 Replies)
Discussion started by: Celald
4 Replies

8. Shell Programming and Scripting

AWK - Ignoring White Space with FS

I have an AWK script that uses multiple delimiters in the FS variable. FS="+" My awk script takes a file name such as this: 12345_smith_bubba_12345_20120215_4_0.pdf and parses it out based on the under score. Each parsed field then has some code for data validation etc. This script has... (12 Replies)
Discussion started by: reno4me
12 Replies

9. Shell Programming and Scripting

Undesired removal of white space with awk

Hi, I'm fairly new to scripting and I have a problem that I am having difficulty solving. What I'd like to do is run an awk script to adjust the string in the first field depending on the string in another field. This is best explained with an example: Here is my script: cat... (4 Replies)
Discussion started by: calbrex
4 Replies

10. Shell Programming and Scripting

Removing white space in awk

Hi How to remove white space from this input:|blue | 1| |green| 4| |black| 2| I like to search for green and get 4not 4 How to modify this to work correct:awk -F"|" '/green/ {print $3} (7 Replies)
Discussion started by: Jotne
7 Replies

LEARN ABOUT MOJAVE

ip::country::maxmind5.18

IP::Country::MaxMind(3) 				User Contributed Perl Documentation				   IP::Country::MaxMind(3)

NAME

       IP::Country::MaxMind - Look up country by IP Address

SYNOPSIS

	 use IP::Country::MaxMind;

	 my $gi = IP::Country::MaxMind->new(GEOIP_STANDARD);

	 # look up IP address '65.15.30.247'
	 # returns undef if country is unallocated, or not defined in our database
	 my $cc1 = $gi->inet_atocc('65.15.30.247');
	 my $cc2 = $gi->inet_atocc('yahoo.com');

DESCRIPTION

       This module adapts the Geo::IP module to use the same interface as the IP::Country modules; thus allowing users to easily switch between
       using the two underlying databases.

DATABASE UPDATES

       Free monthly updates to the database are available from

	 http://www.maxmind.com/download/geoip/database/

       If you require greater accuracy, MaxMind offers a Premium database on a paid subscription basis.

       The author of this module is in no way associated with MaxMind.

CLASS METHODS

       $gi = IP::Country::MaxMind->new( $flags );
	   Constructs a new IP::Country::MaxMind object with the default database located inside your system's datadir, typically
	   /usr/local/share/GeoIP/GeoIP.dat.

	   Flags can be set to either GEOIP_STANDARD, or for faster performance (at a cost of using more memory), GEOIP_MEMORY_CACHE.  When using
	   memory cache you can force a reload if the file is updated by setting GEOIP_CHECK_CACHE.

       $gi = IP::Country::MaxMind->open( $database_filename, $flags );
	   Constructs a new Geo::IP object with the database located at $database_filename.

OBJECT METHODS

       All object methods are designed to be used in an object-oriented fashion.

	 $result = $object->foo_method($bar,$baz);

       Using the module in a procedural fashion (without the arrow syntax) won't work.

       $cc = $gi->inet_atocc(HOSTNAME)
	   Takes a string giving the name of a host, and translates that to an two-letter country code. Takes arguments of both the 'rtfm.mit.edu'
	   type and '18.181.0.24'. If the host name cannot be resolved, returns undef.	If the resolved IP address is not contained within the
	   database, returns undef.

       $cc = $gi->inet_ntocc(IP_ADDRESS)
	   Takes a string (an opaque string as returned by Socket::inet_aton()) and translates it into a two-letter country code. If the IP
	   address is not contained within the database, returns undef.

       $cc = $gi->db_time()
	   Returns zero. For compatibility only.

COPYRIGHT

       Copyright (C) 2002,2003 Nigel Wetters Gourlay. All Rights Reserved.

       NO WARRANTY. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.18.2							    2006-04-06						   IP::Country::MaxMind(3)
All times are GMT -4. The time now is 08:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy