06-06-2008
I think it can be done in this way....
This is for file having three fields (columns) and the command will display
only the column with maximum length.
awk -F"|" '{ l1=length($1) ; l2=length($2) ; l3=length($3) ;
if (l1>l2) { if (l1>l3) {print $3}
else print $1 }
else { if (l2>l3) {print $2} else print $3 } }' File.txt
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
Hi Experts,
I am adding a column of numbers with awk , however not getting correct output:
# awk '{sum+=$1} END {print sum}' datafile
2.15291e+06
How can I getthe output like : 2152910
Thank you..
# awk '{sum+=$1} END {print sum}' datafile
2.15079e+06 (3 Replies)
Discussion started by: rveri
3 Replies
3. Shell Programming and Scripting
I want to filter 2nd column = 2 using awk
$ cat t
1 2
2 4
$ VAR=2
#variable worked in print
$ cat t | awk -v ID=$VAR ' { print ID}'
2
2
# but variable didn't work in awk filter
$ cat t | awk -v ID=$VAR '$2~/ID/ { print $0}' (2 Replies)
Discussion started by: honglus
2 Replies
4. Shell Programming and Scripting
Hi
I have many problems with a script. I have a script that formats a text file but always prints the same error when i try to execute it
The code is that:
{
if (NF==17){
print $0
}else{
fields=NF;
all=$0;
while... (2 Replies)
Discussion started by: fate
2 Replies
5. Shell Programming and Scripting
I have two files which I would like to compare and then manipulate in a way.
File1:
pictures.txt 1.1 1.3
dance.txt 1.2 1.4
treehouse.txt 1.3 1.5
File2:
pictures.txt 1.5 ref2313 1.4 ref2345 1.3 ref5432 1.2 ref4244
dance.txt 1.6 ref2342 1.5 ref2352 1.4 ref0695 1.3 ref5738 1.2... (1 Reply)
Discussion started by: linuxkid
1 Replies
6. Shell Programming and Scripting
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
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
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
Hi,
I am trying to pass awk field to a command line executed within awk (need to convert a timestamp into formatted date).
All my attempts failed this far.
Here's an example.
It works fine with timestamp hard-codded into the command
echo "1381653229 something" |awk 'BEGIN{cmd="date -d... (4 Replies)
Discussion started by: tuxer
4 Replies
10. Shell Programming and Scripting
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 DEBIAN
cddb::file
CDDB::File(3pm) User Contributed Perl Documentation CDDB::File(3pm)
NAME
CDDB::File - Parse a CDDB/freedb data file
SYNOPSIS
my $disc = CDDB::File->new("rock/f4109511");
print $disc->id, $disc->all_ids;
print $disc->artist, $disc->title;
print $disc->year, $disc->genre, $disc->extd;
print $disc->length, $disc->track_count;
print $disc->revision, $disc->submitted_via, $disc->processed_by;
foreach my $track ($disc->tracks) {
print $track->number, $track->title, $track->artist;
print $track->length, $track->extd;
}
DESCRIPTION
This module provides an interface for extracting data from CDDB-format data files, as used by freedb.
It does not read data from your CD, or submit information to freedb.
METHODS
new
my $disc = CDDB::File->new("rock/f4109511");
This will create a new object representing the data in the file name specified.
id / all_ids
my $discid = $disc->id;
my @discid = $disc->all_ids;
Due to how freedb works, one CD may have several IDs associated with it. 'id' will return the first of these (not necessarily related to
the filename from which this was read), whilst 'all_ids' will return all of them.
title / artist
The title and artist of this CD. For eponymous CDs these will be identical, even if the data file leaves the artist field blank.
year
The (4-digit) year of release.
genre
The genre of this CD. This is the genre as stored in the data file itself, which is not related to the 11 main freedb genres.
extd
The "extended data" for the CD. This is used for storing miscellaneous information which has no better storage place, and can be of any
length.
length
The run time of the CD in seconds.
track_count
The number of tracks on the CD.
revision
Each time information regarding the CD is updated this revision number is incremented. This returns the revision number of this version.
processed_by / submitted_via
The software which submitted this information to freedb and which processed it at the other end.
tracks
foreach my $track ($disc->tracks) {
print $track->number, $track->title, $track->artist;
print $track->length, $track->extd;
}
Returns a list of Track objects, each of which knows its number (numering from 1), title, length (in seconds), offset, and may also have
extended track data.
Tracks may also contain an 'artist' field. If this is not set the artist method will return the artist of the CD.
SEE ALSO
http://www.freedb.org/
AUTHOR
Tony Bowden
BUGS and QUERIES
Please direct all correspondence regarding this module to:
bug-CDDB-File@rt.cpan.org
COPYRIGHT
Copyright (C) 2001-2005 Tony Bowden. All rights reserved.
This program is free software; you can redistribute it and/or modify it under
the terms of the GNU General Public License; either version 2 of the License,
or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE.
perl v5.10.1 2005-10-04 CDDB::File(3pm)