Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk Help - toupper/tolower
Top Forums UNIX for Dummies Questions & Answers Awk Help - toupper/tolower Post 302652973 by vanand420 on Friday 8th of June 2012 08:01:20 AM
Old 06-08-2012
Quote:
Originally Posted by balajesuri
toupper($1) ~ /A/ => If the first field (converted to uppercase) contains 'A' ""anywhere"" in the string.

Try this instead: toupper($1) ~ /^A/ to filter out the first field ""starting"" with 'A'

And, I'm not able to understand the second requirement. Do you want to search in first field if the second character is 'a'?
My concern is that in first case, it should pick "A" only not "a" irrespective of the position.

Code:
$ awk '{if (toupper($1) ~ /A/) print $0}' inv -- Why this output
Jan  13  25  15 115
Mar  15  24  34 228
Apr  31  52  63 420
May  16  34  29 208
Aug  15  34  47 316
Jan  21  36  64 620
Mar  24  75  70 495
Apr  21  70  74 514

It should be like this.
Apr  31  52  63 420
Aug  15  34  47 316
Apr  21  70  74 514

In second case, it should not pic "A" but "a"

Code:
$ awk '{if (tolower($1) ~ /a/) print $0}' inv  ---why this output
Jan  13  25  15 115
Mar  15  24  34 228
Apr  31  52  63 420
May  16  34  29 208
Aug  15  34  47 316
Jan  21  36  64 620
Mar  24  75  70 495
Apr  21  70  74 514

It should be like this.
Jan  13  25  15 115
Mar  15  24  34 228
May  16  34  29 208
Jan  21  36  64 620
Mar  24  75  70 495

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to apply a "tolower" AWK to a few parts of a document

Hi people, i have a nice problem to solve.. in an text page i must change all the "*.php" occourences to the respective lowercase.. Example: ... <tr><td> <form action="outputEstrazione.php" method="get"> <table cellspacing='0,5' bgcolor='#000000'><tr><td> <font size='2'... (5 Replies)
Discussion started by: marconet85
5 Replies

2. Shell Programming and Scripting

Awk problem: How to express the single quote(') by using awk print function

Actually I got a list of file end with *.txt I want to use the same command apply to all the *.txt Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics. For example: I got the file below: file1.txt file2.txt file3.txt... (4 Replies)
Discussion started by: patrick87
4 Replies

3. Shell Programming and Scripting

Handling multiple fields of a database file for toupper() function in awk

hello everyone.... script is: To convert the contents of a database file into uppercase my code is: printf "%s\n" , $2 | awk '{print toupper($2)}' emp.lst i m able to do only for one field.....didn't get any sources for handling multiple fields. please suggest me for multiple... (1 Reply)
Discussion started by: Priyanka Bhati
1 Replies

4. Programming

tolower (static pointer + malloc + realloc)

N00B here. This function would be easier using a char pointer along with free. But I wish to learn how to use char static pointers (they do not require free, right ?). How do I erase the content of a static pointer ? Terminating the string works but the static pointer's content is not being... (4 Replies)
Discussion started by: limmer
4 Replies

5. Shell Programming and Scripting

issue with toupper in nawk

Hi All, I am seeing an issue while using toupper in nawk. Below is the code that I am using.Toupper method is not working as expected in this case.nawk 'NR==FNR{a=$4" "$5}NR>FNR{print NF?$0:a"\n";if(/^cn:/) x=toupper($0)}' FS="" id_list.txt attributes.txt > out In the above script, id_list... (9 Replies)
Discussion started by: Samingla
9 Replies

6. Shell Programming and Scripting

toupper or tolower case of first letter of the line depending on another file

Hi I would like to read if the first letter of a line in a first file (gauche.txt) is uppercase or lowercase, and change consequently the first letter of the corresponding line in the second file (droiteInit.txt). I have done this but it won't work (I launch this using gawk -f... (16 Replies)
Discussion started by: louisJ
16 Replies

7. Shell Programming and Scripting

awk command to compare a file with set of files in a directory using 'awk'

Hi, I have a situation to compare one file, say file1.txt with a set of files in directory.The directory contains more than 100 files. To be more precise, the requirement is to compare the first field of file1.txt with the first field in all the files in the directory.The files in the... (10 Replies)
Discussion started by: anandek
10 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

awk output yields error: awk:can't open job_name (Autosys)

Good evening, Im newbie at unix specially with awk From an scheduler program called Autosys i want to extract some data reading an inputfile that comprises jobs names, then formating the output to columns for example 1. This is the inputfile: $ more MapaRep.txt ds_extra_nikira_usuarios... (18 Replies)
Discussion started by: alexcol
18 Replies

LEARN ABOUT MOJAVE

datetime::locale::af_na

DateTime::Locale::af_NA(3)				User Contributed Perl Documentation				DateTime::Locale::af_NA(3)

NAME

       DateTime::Locale::af_NA

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'af_NA' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Afrikaans Namibia.

DATA

       This locale inherits from the DateTime::Locale::af locale.

       It contains the following data.

   Days
       Wide (format)

	 Maandag
	 Dinsdag
	 Woensdag
	 Donderdag
	 Vrydag
	 Saterdag
	 Sondag

       Abbreviated (format)

	 Ma
	 Di
	 Wo
	 Do
	 Vr
	 Sa
	 So

       Narrow (format)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

       Wide (stand-alone)

	 Maandag
	 Dinsdag
	 Woensdag
	 Donderdag
	 Vrydag
	 Saterdag
	 Sondag

       Abbreviated (stand-alone)

	 Ma
	 Di
	 Wo
	 Do
	 Vr
	 Sa
	 So

       Narrow (stand-alone)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

   Months
       Wide (format)

	 Januarie
	 Februarie
	 Maart
	 April
	 Mei
	 Junie
	 Julie
	 Augustus
	 September
	 Oktober
	 November
	 Desember

       Abbreviated (format)

	 Jan
	 Feb
	 Mar
	 Apr
	 Mei
	 Jun
	 Jul
	 Aug
	 Sep
	 Okt
	 Nov
	 Des

       Narrow (format)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

       Wide (stand-alone)

	 Januarie
	 Februarie
	 Maart
	 April
	 Mei
	 Junie
	 Julie
	 Augustus
	 September
	 Oktober
	 November
	 Desember

       Abbreviated (stand-alone)

	 Jan
	 Feb
	 Mar
	 Apr
	 Mei
	 Jun
	 Jul
	 Aug
	 Sep
	 Okt
	 Nov
	 Des

       Narrow (stand-alone)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

   Quarters
       Wide (format)

	 1ste kwartaal
	 2de kwartaal
	 3de kwartaal
	 4de kwartaal

       Abbreviated (format)

	 K1
	 K2
	 K3
	 K4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 1ste kwartaal
	 2de kwartaal
	 3de kwartaal
	 4de kwartaal

       Abbreviated (stand-alone)

	 K1
	 K2
	 K3
	 K4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 voor Christus
	 na Christus

       Abbreviated

	 v.C.
	 n.C.

       Narrow

	 v.C.
	 n.C.

   Date Formats
       Full

	  2008-02-05T18:30:30 = Dinsdag 5 Februarie 2008
	  1995-12-22T09:05:02 = Vrydag 22 Desember 1995
	 -0010-09-15T04:44:23 = Saterdag 15 September -10

       Long

	  2008-02-05T18:30:30 = 5 Februarie 2008
	  1995-12-22T09:05:02 = 22 Desember 1995
	 -0010-09-15T04:44:23 = 15 September -10

       Medium

	  2008-02-05T18:30:30 = 5 Feb 2008
	  1995-12-22T09:05:02 = 22 Des 1995
	 -0010-09-15T04:44:23 = 15 Sep -10

       Short

	  2008-02-05T18:30:30 = 2008-02-05
	  1995-12-22T09:05:02 = 1995-12-22
	 -0010-09-15T04:44:23 = -010-09-15

       Default

	  2008-02-05T18:30:30 = 5 Feb 2008
	  1995-12-22T09:05:02 = 22 Des 1995
	 -0010-09-15T04:44:23 = 15 Sep -10

   Time Formats
       Full

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

       Short

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 09:05
	 -0010-09-15T04:44:23 = 04:44

       Default

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = Dinsdag 5 Februarie 2008 18:30:30 UTC
	  1995-12-22T09:05:02 = Vrydag 22 Desember 1995 09:05:02 UTC
	 -0010-09-15T04:44:23 = Saterdag 15 September -10 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 5 Februarie 2008 18:30:30 UTC
	  1995-12-22T09:05:02 = 22 Desember 1995 09:05:02 UTC
	 -0010-09-15T04:44:23 = 15 September -10 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 5 Feb 2008 18:30:30
	  1995-12-22T09:05:02 = 22 Des 1995 09:05:02
	 -0010-09-15T04:44:23 = 15 Sep -10 04:44:23

       Short

	  2008-02-05T18:30:30 = 2008-02-05 18:30
	  1995-12-22T09:05:02 = 1995-12-22 09:05
	 -0010-09-15T04:44:23 = -010-09-15 04:44

       Default

	  2008-02-05T18:30:30 = 5 Feb 2008 18:30:30
	  1995-12-22T09:05:02 = 22 Des 1995 09:05:02
	 -0010-09-15T04:44:23 = 15 Sep -10 04:44:23

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 Di
	  1995-12-22T09:05:02 = 22 Vr
	 -0010-09-15T04:44:23 = 15 Sa

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 nm.
	  1995-12-22T09:05:02 = 9:05 vm.
	 -0010-09-15T04:44:23 = 4:44 vm.

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 nm.
	  1995-12-22T09:05:02 = 9:05:02 vm.
	 -0010-09-15T04:44:23 = 4:44:23 vm.

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = Di, 2-5
	  1995-12-22T09:05:02 = Vr, 12-22
	 -0010-09-15T04:44:23 = Sa, 9-15

       MMdd (MM-dd)

	  2008-02-05T18:30:30 = 02-05
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 09-15

       MMM (LLL)

	  2008-02-05T18:30:30 = Feb
	  1995-12-22T09:05:02 = Des
	 -0010-09-15T04:44:23 = Sep

       MMMd (MMM d)

	  2008-02-05T18:30:30 = Feb 5
	  1995-12-22T09:05:02 = Des 22
	 -0010-09-15T04:44:23 = Sep 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = Di Feb 5
	  1995-12-22T09:05:02 = Vr Des 22
	 -0010-09-15T04:44:23 = Sa Sep 15

       MMMMd (d MMMM)

	  2008-02-05T18:30:30 = 5 Februarie
	  1995-12-22T09:05:02 = 22 Desember
	 -0010-09-15T04:44:23 = 15 September

       MMMMdd (dd MMMM)

	  2008-02-05T18:30:30 = 05 Februarie
	  1995-12-22T09:05:02 = 22 Desember
	 -0010-09-15T04:44:23 = 15 September

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = Di Februarie 5
	  1995-12-22T09:05:02 = Vr Desember 22
	 -0010-09-15T04:44:23 = Sa September 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = Di, 2008-2-5
	  1995-12-22T09:05:02 = Vr, 1995-12-22
	 -0010-09-15T04:44:23 = Sa, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 Feb
	  1995-12-22T09:05:02 = 1995 Des
	 -0010-09-15T04:44:23 = -10 Sep

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = Di, 2008 Feb 5
	  1995-12-22T09:05:02 = Vr, 1995 Des 22
	 -0010-09-15T04:44:23 = Sa, -10 Sep 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 Februarie
	  1995-12-22T09:05:02 = 1995 Desember
	 -0010-09-15T04:44:23 = -10 September

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 K1
	  1995-12-22T09:05:02 = 1995 K4
	 -0010-09-15T04:44:23 = -10 K3

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

       yyyyMM (yyyy-MM)

	  2008-02-05T18:30:30 = 2008-02
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -010-09

       yyyyMMMM (MMMM y)

	  2008-02-05T18:30:30 = Februarie 2008
	  1995-12-22T09:05:02 = Desember 1995
	 -0010-09-15T04:44:23 = September -10

   Miscellaneous
       Prefers 24 hour time?

       Yes

       Local first day of the week

       Maandag

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.18.2							    2017-10-06						DateTime::Locale::af_NA(3)
All times are GMT -4. The time now is 10:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy