12-07-2019
Your input file is not too consistent in its usage of spaces as field separators. It has one or two between fields, one up to six from BOL to $2 if $1 is missing, and zero or one at EOL. That's what " +" is for: it stands for "one or many" spaces. c.f. man regex for further reference.
This User Gave Thanks to RudiC For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
$ cat log.txt
Name Age Sex Lcation nfld alias xsd
CC 25 M XYZ asx KK Y
BB 21 F XAS awe SS N
SD 21 M AQW rty SD A
How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column?
so that the final output will become:
Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies
2. Shell Programming and Scripting
FILE A:
9780743551526,(Abridged)
9780743551779,(Unabridged)
9780743582469,(Abridged)
9780743582483,(Unabridged)
9780743563468,(Abridged)
9780743563475,(Unabridged)
FILE B:
c3saCandyland 9780743518321 "CANDYLAND" "MCBAIN, ED" 2001
c3sbCandyland 9780743518321 ... (7 Replies)
Discussion started by: glev2005
7 Replies
3. Shell Programming and Scripting
Hello,
I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2
SDF4 -0.211654
SDF4 0.978068
... (1 Reply)
Discussion started by: Diya123
1 Replies
4. Shell Programming and Scripting
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies
5. Shell Programming and Scripting
Hey folks. I wrote a little awk script that summarizes /proc/net/dev info and then pipes it to the nix column command to set up column spacing appropriately.
Here's some example output:
Iface RxMBytes RxPackets RxErrs RxDrop TxMBytes TxPackets TxErrs TxDrop
bond0 9 83830... (3 Replies)
Discussion started by: ryran
3 Replies
6. Shell Programming and Scripting
My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated.
Please someone help me to resolve this issue.
Source
column1 column2 column3 column4... (2 Replies)
Discussion started by: Ganesh L
2 Replies
7. Shell Programming and Scripting
Hi,
I have a similar input format-
A_1 2
B_0 4
A_1 1
B_2 5
A_4 1
and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks!
letter number_of_letters... (5 Replies)
Discussion started by: prashob123
5 Replies
8. Shell Programming and Scripting
Hi
I have a text file (Input.txt) with two column entries separated by tab as given below:
aaa str1
bbb str2
cccccc str3
dddd str4
eee str3
ssss str2
sdf str3
hhh str1
fff str2
ccc str3
.....
.....
..... (1 Reply)
Discussion started by: my_Perl
1 Replies
9. Shell Programming and Scripting
input
"A","B","C,D","E","F"
"S","T","U,V","W","X"
"AA","BB","CC,DD","EEEE","FFF"
required output:
"A","B","C,D","C,D","F"
"S", T","U,V","U,V","X"
"AA","BB","CC,DD","CC,DD","FFF"
tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Discussion started by: khblts
5 Replies
10. Shell Programming and Scripting
My input file looks like this
12 3 5.122.281.413 172.31.15.220 3421 4133 2 2 1454 3421 4133 2 2 0
12 44036 214.215.52.146 90.123.245.211 2312 3911 4 4 521 2312 3911 4 4 1
14 504 6.254.324.219 192.61.27.120 4444 5611 7 5 1415 4444 5611 7 5 1 ... (2 Replies)
Discussion started by: sampitosh
2 Replies
LEARN ABOUT DEBIAN
lltag_formats
lltag_formats(5) File Formats Manual lltag_formats(5)
NAME
formats - Internal formats database file for lltag
DESCRIPTION
The internal format database is usually stored in /etc/lltag/formats. The user may override this file by defining a $HOME/.lltag/formats.
If this file exists, the system-wide one is ignored.
These files contain entries starting with a line such as:
[%n - %a - %t]
A title between bracket that will be displayed at runtime.
Then, the following 3 lines must be given to explain how the format is actually used to parse filenames:
type = basename
The type is either basename (to parse the last part of the path to a file) or path (to parse the directory part of the path to a
file). When actually parsing the path to target files, basename and path parsers will be assembled. All possible combination will
be tried.
regexp = %L%N%S-%S%A%S-%S%A%L
A string composed of any characters, with the following special fields:
%L for delimiter (empty by default, multiple spaces if --spaces was given)
%S for a space (or multiple spaces if --spaces was given)
%N for numbers
%A for an alphanumeric string without /
%P for any path (alphanumeric string with /)
%% for %
indices = NUMBER,ARTIST,TITLE
A list of fields to match (either given by their full name or associated letter) corresponding to each %N or %A field in the previ-
ous format. It may be AUTHOR (or a), ALBUM (A), GENRE (g), NUMBER (n), TITLE (t), DATE (d), COMMENT (c) or IGNORE (i). See also
FORMAT in the manpage of lltag for details about these fields.
SEE ALSO
lltag(1)
AUTHOR
Brice Goglin
NOVEMBER 2006 lltag_formats(5)