|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
AWK - Ignoring White Space with FS
Post 302598748 by reno4me on Wednesday 15th of February 2012 10:34:39 AM
02-15-2012
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 been working fine until I got a file name like this:
12345_smith johnson jones_bubba_12345_20120215_4_0.pdf
Where the last name field has three last names separated by a space.
Is there a way in my FS assignment to tell AWK to ignore the whitespace and just use the period "." and underscore "_" as the only delimiters?
FYI this is my first post!
Randy
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 been working fine until I got a file name like this:
12345_smith johnson jones_bubba_12345_20120215_4_0.pdf
Where the last name field has three last names separated by a space.
Is there a way in my FS assignment to tell AWK to ignore the whitespace and just use the period "." and underscore "_" as the only delimiters?
FYI this is my first post!
Randy
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi everyone,
$ more abcdefg.ksh
abcdef
alpha beta gamma
abcdef
abcdef
lmnop
$ wc sachin1.ksh
5 7 132 abcdefg.ksh
if you see it shows that file has got 240 characters. I actually want to count how many characters... (1 Reply)
Discussion started by: sachin.gangadha
1 Replies
2. UNIX for Dummies Questions & Answers
Dear Members,
Suppose i have a variable test which stores a string as below:
test='John drives+++++++++a+++++car'
now i want to use sed on the above variable and replace + with a white space, so that i get
echo $test should give me
'john drives a car'
Between... (1 Reply)
Discussion started by: sandeep_1105
1 Replies
3. Shell Programming and Scripting
Hi,
What sed command (if sed is the right command) can remove ALL white space from my file. I have a csv, except I want to remove all white space between commas and characters.
My idea (without testing)
sed 's/ //g'
Is there a better way? (18 Replies)
Discussion started by: mcclunyboy
18 Replies
4. Shell Programming and Scripting
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
5. Post Here to Contact Site Administrators and Moderators
Hi ,
I want a tcl script to search a string ignoring whitespaces in a .log file . It should correctly match . The string are as follows
"Output-Maps 1 1 0 0 0" 1
and
Active Intermediate-Maps 0 0 0 ... (1 Reply)
Discussion started by: kulua
1 Replies
6. UNIX for Advanced & Expert Users
Hi ,
I want to search a string in a file ignoring white spaces in TCL.
My string is as follows
Ouput-Maps " 1 1 1 0 " 1i am doing following
set a *1*1*1*0* " }1 abc.log}] but it is not working.
What is the wrong with the tcl script
Thanks
Gouranga
Video... (0 Replies)
Discussion started by: mybapa3000@gmai
0 Replies
7. Shell Programming and Scripting
Hi All,I am facing the below problem I have set a variable:
a=`cat a.txt| grep "mad" | cut -c 30-50`the output is coming
echo $a1
10 Mad300 3215however the actual ouput is
1.10 Mad300 3215There are 4spaces between 300 and 3215 so if i do:
echo "$a" I am getting correct output:
1.10... (3 Replies)
Discussion started by: mad_man12
3 Replies
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
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 REDHAT
tzselect
TZSELECT(8) System Manager's Manual TZSELECT(8) NAME
tzselect - select a time zone SYNOPSIS
tzselect DESCRIPTION
The tzselect program asks the user for information about the current location, and outputs the resulting time zone description to standard output. The output is suitable as a value for the TZ environment variable. All interaction with the user is done via standard input and standard error. ENVIRONMENT VARIABLES
AWK Name of a Posix-compliant awk program (default: awk). TZDIR Name of the directory containing time zone data files (default: /usr/local/etc/zoneinfo). FILES
TZDIR/iso3166.tab Table of ISO 3166 2-letter country codes and country names. TZDIR/zone.tab Table of country codes, latitude and longitude, TZ values, and descriptive comments. TZDIR/TZ Time zone data file for time zone TZ. EXIT STATUS
The exit status is zero if a time zone was successfully obtained from the user, nonzero otherwise. SEE ALSO
newctime(3), tzfile(5), zdump(8), zic(8) TZSELECT(8)