Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: AWK to classify a file into several ones ..
Top Forums Shell Programming and Scripting AWK to classify a file into several ones .. Post 302696677 by delugeag on Wednesday 5th of September 2012 09:19:25 AM
Old 09-05-2012
Quote:
Originally Posted by engkemo2002
awk -F, '{$3 = "LTE" ; print $0 }' $FILE_NAME >> LTE_alarms_.csv[/CODE]
It's a pretty good idea but you have to learn more about AWK:
Code:
echo 'a,b,c' | awk  -F, '{$3 = "LTE" ; print $0 }'
=> a b LTE

So if you wan to print only line with LTE in $3 there are a lot of solutions :
Code:
awk  -F, '{ if ($3 == "LTE") { print $0} }'
awk  -F, '$3 == "LTE" { print $0}'
awk  -F, '$3 == "LTE"'

please note that the awk basis syntax is :
Code:
awk 'expression {commands}'

the awk check the expression for every line and execute commands if the expression is true. If you don't put the expression (first awk) the commands will be executed on every lines. If you don't put command (so only the expression like the last awk) the "defaut" command is "print $0".

If I look your file you want *LTE* in $3. So you have to use regex with ~ :
Code:
awk  -F, '$3 ~ /LTE/'

 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parse file using awk and work in awk output

hi guys, i want to parse a file using public function, the file contain raw data in the below format i want to get the output like this to load it to Oracle DB MARWA1,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 MARWA2,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00 this the file raw format: Number of... (6 Replies)
Discussion started by: dagigg
6 Replies

2. Shell Programming and Scripting

How to use awk to classify file extension from input ls -l

i try to do this for a long time input is command ls -l and output is: Number of files : xx Number of file type – awk : 5 total size: 2345 bytes // file ex type .awk Number of file type – dat : 10 total size: 233 bytes // file ex type .dat ... Number of unknown file type... (1 Reply)
Discussion started by: retsuseiba
1 Replies

3. Shell Programming and Scripting

write awk command into file using awk

hi, i want to write my nawk command into a file. i want to write: awk 'NR==14 && $NF!="Set."{print "l ./gcsw "r" '"'"'lt all;"p"'"'"'"} NR==5{r=$2} NR==3{p=$2 FS $3 FS $4 FS $5}' $logfile > /home/gc_sw/again.mos'"'"' into gc.mos file. this is my code: awk '{print "awk 'NR==14 &&... (6 Replies)
Discussion started by: gc_sw
6 Replies

4. UNIX for Dummies Questions & Answers

Classify value to a range

Dear All, I need to classify my data into sets or ranges based on values in the second column of a file as - low medium and high. INPUT: file1.dat 1.tmp 1.03 2.tmp 0.38 3.tmp 3.23 4.tmp 1.34 I would like to classify all the numerical values into a range based on the followng... (3 Replies)
Discussion started by: chen.xiao.po
3 Replies

5. Shell Programming and Scripting

Split File by Pattern with File Names in Source File... Awk?

Hi all, I'm pretty new to Shell scripting and I need some help to split a source text file into multiple files. The source has a row with pattern where the file needs to be split, and the pattern row also contains the file name of the destination for that specific piece. Here is an example: ... (2 Replies)
Discussion started by: cul8er
2 Replies

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

7. Shell Programming and Scripting

Awk: Print count for column in a file using awk

Hi, I have the following input in a file & need output as mentioned below(need counter of every occurance of field which is to be increased by 1). Input: 919143110065 919143110065 919143110052 918648846132 919143110012 918648873782 919143110152 919143110152 919143110152... (2 Replies)
Discussion started by: siramitsharma
2 Replies

8. Shell Programming and Scripting

Classify lines in file using perl

The below perl executes and does classify each of the 3 lines in file.txt. Lines 2 and 3 are correct as they fit the criteria for Rule 2. The problem is that line one should be classified VUS as it does not meet the criteria for Rule 1, so Rule 3 is used. However, currently Rule 2 is changing the... (27 Replies)
Discussion started by: cmccabe
27 Replies

LEARN ABOUT REDHAT

pilot-addresses

pilot-addresses(1)					      General Commands Manual						pilot-addresses(1)

NAME

       pilot-addresses	- read and write address book databases to and from a Palm handheld device, such as those made from Palm, Handspring, Han-
       dera, TRGPro, Sony or other Palm Compatible Handheld PDA device

SYNOPSIS

       pilot-addresses -p <port> [-c category ] [-d category ] [-r file | -w file ]

       (Note that some options are not shown above)

DESCRIPTION

       pilot-addresses allows the user to read all entries in the Palm address book database, write new entries into the database,  and  delete  a
       category or delete all entries in the database.

TARGET DEVICE

       The  default  serial  device  used to communicate with a Palm is /dev/pilot.  If the environment variable $PILOTPORT is set, its value will
       override the default. A serial device specified on the command-line will be used regardless of any $PILOTPORT setting.

OPTIONS

       Several options exist, including...

       -p --port <port>,
	      Use device file port to communicate with the Palm handheld device. If this is not specified, will look for the  $PILOTPORT  environ-
	      ment variable. If both are not found, will fall back to /dev/pilot.

       -h --help
	      Display help synopsis for pilot-addresses

       -v --version
	      Display version of pilot-addresses

       -a     Augments	fields in address book records with additional information.  The augmented information is placed before and separated from
	      the field with a semi-colon, (;).

	      Augmented information includes:
	      category_name - placed in front of each record or

	      ["Work" | "Home" | "Fax" | "Other" | "E-mail" | "Main" | "Pager" | "Mobile" ] - placed in front of each phone number field.

	      Empty fields are not augmented.

       -c category
	      Install records to category category by default. Normally pilot-addresses uses Unfiled as the default category. This option is over-
	      ridden by the category specified in the record with the -a option.

       -d category
	      Delete all records in the specified category before installing new records.

       -D     Delete all address book records in all categories. Obviously, be very careful with this one.

       -e     Escape  all  special  characters	with a backslash. This enables you to read and write entries with newline characters in a field or
	      note.

       -q     Causes pilot-addresses to be quiet and not prompt you to press the HotSync button.

       -r file
	      Reads records from file and install them to the Palm address book database. (Use the -w file  to	get  a	template  file	for  input
	      records.)

       -t delim
	      Include  category  in  each record, use the delimiter specified to separate all fields of a record. Delimiters are specified as fol-
	      lows: 3=tab, 2=;, 1=,.  This overrides the default delimiter of comma between fields and	semi-colon  between  a	field's  augmented
	      information. (Please note that this may generate confusing results when used with the -a option.)

       -T     Write a header line with field titles as the first line of the data file.

       -w file
	      Get all address book records from the Palm address book database and writes them into file

USAGE

       The  program will connect to a target device and port, prompt the user to HotSync, and perform the requested read or write operation speci-
       fied by the user.

EXAMPLES

       To write all address records in a Palm to the file addrbook.csv:
	      pilot-addresses -w addrbook.csv
       or
	      pilot-addresses -p /dev/irnine -w addrbook.csv

       To read the address book records in the file addrbook.csv and install them on a Palm:
	      pilot-addresses -r addrbook.csv

       To read the address book records in the file addrbook.csv and place them into the Palm address book database category Special  after  first
       deleting all current records in the Special category on the palm:
	      pilot-addresses -c Special -d Special -r addrbook.csv

SEE ALSO

       pilot-link(7)

KNOWN BUGS

       pilot-addresses has no known bugs.

REPORTING BUGS

       Report bugs at http://bugs.pilot-link.org/

AUTHOR

       pilot-addresses originally written by Kenneth Albanowski, manual page was written by Robert Wittig <bob.wittig@gt.org>.

Free Software Foundation				    Palm Computing Device Tools 					pilot-addresses(1)
All times are GMT -4. The time now is 07:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy