04-24-2009
awk remove column with conditions?
The output should be: I am newbie so I need the awk script which will give me this output so that I can automate the process.
Col1|Col2|Col3|Col4
3 | 4 | B | 6
5 | 6 | B | 8
Last edited by pr2003; 04-24-2009 at 02:36 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a text file
Nov 1 LOG_10_000000343.gzip_COMPLETE 2910 server.log.3
Nov 4 LOG_10_000000343.gzip_COMPLETE 2910 server.log.4
Dec 5 LOG_10_000000343.gzip_blah 2910 server.log.5
Jul 6 LOG_10_000000343.gzip_ERROR 2910 server.log.1
I need to convert this to
Nov 1 LOG_10_000000343.gzip... (3 Replies)
Discussion started by: gubbu
3 Replies
2. UNIX for Dummies Questions & Answers
Hii Friends.. I have a huge set of data stored in a file.Which is as shown below
a.dat:
RAO 1869 12 19 0 0 0.00 17.9000 82.3000 10.0 0 0.00 0 3.70 0.00 0.00 0 0.00 3.70 4 NULL
LEE 1870 4 11 1 0 0.00 30.0000 99.0000 0.0 0 0.00 0 0.00 0.00 0.00 0 ... (3 Replies)
Discussion started by: reva
3 Replies
3. Shell Programming and Scripting
Hi All,
How to remove col1 and last column in a line. Please suggest some awk stuffs.
Input
col1 col2 col3 col4
col1 col2 col3 col4 col5
col1 col2 col3 col4
col1 col2 col3
Output
Processing col2 col3 ...
Processing col2 col3 col4 ...
Processing col2 col3 ...
Processing... (5 Replies)
Discussion started by: k_manimuthu
5 Replies
4. Shell Programming and Scripting
Hi I have a difficulty in writing shell script for performing the tasks.
A B C D
12 230 16 259
18 260 23 283
21 291 36 298
41 309 49 420
52 425 57 450
61 456 70 473
72 475 79 486
If the A(row no.2) < C(row no.1) then delete value A(row no.1) and so on...
For... (8 Replies)
Discussion started by: Sarwagya Jha
8 Replies
5. UNIX for Dummies Questions & Answers
Hi Everyone,
I've been using awk '!x++' to get rid of redundancy in a file, but it's getting rid of some extra lines I need (like the plus signs in the example below).
So how would I go from this:
@XYZ
ABCD
345345
+
@MNO
EFGH
789789
+
@XYZ
ABCD
345345
+
to: (2 Replies)
Discussion started by: sp24
2 Replies
6. Shell Programming and Scripting
Hi,
I would like to ask your expertise to remove specific column no. 8 in the below file using but I don't have an idea on how to simply do this using awk command. Appreciate your help in advance.
Input f:
ABC 1 1XC
CDA 1 2YC
CCC 1 3XC
AVD 1 3XA
Expected output file:
ABC 1 1C
CDA... (9 Replies)
Discussion started by: zzavilz
9 Replies
7. Shell Programming and Scripting
hi all,
how can i use grep or awk to clean the following input data:
n<>the<>96427210 861521305 123257583
n<>obj<>79634223 861521305 79634223
n<>nmod<>68404733 861521305 68422718
where the desired results is to remove all non-numeric characters?:
96427210 861521305 123257583 ... (5 Replies)
Discussion started by: owwow14
5 Replies
8. Shell Programming and Scripting
Hello,
Using bash script, i need to process the following file:
887,86,,2013-11-06,1,10030,5,2,0,200,,
887,86,,2013-11-05,1,10030,5,2,0,199,,
887,138,,2013-11-06,1,10031,6,2,0,1610612736,,
887,164,,2013-11-06,1,10000,0,2,0,36000,,
and to create a new file such as the below
... (2 Replies)
Discussion started by: JonhyDeep
2 Replies
9. Shell Programming and Scripting
cat input.txt
a x
b y
c z
Expected output
x
y
z (11 Replies)
Discussion started by: cola
11 Replies
10. Shell Programming and Scripting
I need to remove specific column to one range
source file
3 1 000123456
2 2 000123569
3 3 000123564
12 000123156
15 000125648
128 000125648
Output required
3 000123456
2 000123569
3 000123564
12 000123156
15 000125648
128 000125648 (6 Replies)
Discussion started by: ranjancom2000
6 Replies
trbdf(1) User Manuals trbdf(1)
NAME
trbdf - convert BDF-font from one encoding to other
SYNOPSIS
trbdf -C | -l | -h
trbdf [-s] [-f input-codeset ] [-t output-codeset ] [--foundry[=] new-foundry ] BDF-font
DESCRIPTION
trbdf is a program for translation of BDF fonts from one encoding to other. One exciting feature of trbdf is that it tries to approximate
the symbols that miss from the font or from the encoding of the font with existing symbols when possible.
If the option -s or --gen-script is given trbdf will generate an awk(1) script for translation of BDF-fonts for fixed combination of input-
codeset and output-codeset This is useful for faster convertion of many files. This script is used as filter.
If none of -C, -s, -l, -h and their equivalents is given the BDF-font will be read assuming it is coded with codeset input-codeset On stan-
dard output it will be recoded so to use codeset output-codeset Both input-codeset and output-codeset are case insensitive and default to
`cp1251'.
OPTIONS
-C, --copyright
Display copying conditions and warranty information.
-s, --gen-script
Generates conversion script for given input and output encodings instead to convert BDF-font. This option is usefull if you have to
convert many fonts. The generated script expects the input font from its standard input and outputs the converted font.
-l, --list
List all known codesets.
-h, --help
Display this help and exit.
-f input-codeset, --from[=]input-codeset
Codeset of the source font.
-f output-codeset, --to[=]output-codeset
Codeset of the generated font.
--foundry[=]new-foundry
Use this option if you want to change the foundry of the generated fonts.
AUTHOR
Anton Zinoviev <anton@lml.bas.bg>, <zinoviev@fmi.uni-sofia.bg>
SEE ALSO
bdftopcf(1x)
trscripts NOV 2002 trbdf(1)