awk '$5 $6 ~ "^..$"' file
22 rs7291429 0 17294251 G T
22 rs2192431:17303596:T:G 0 17303596 G T
22 rs175140 0 17306104 G T
22 rs175147:17309362:G:T 0 17309362 G T
22 rs12628206:17316990:T:G 0 17316990 G T
22 rs7510758:17432482:T:G 0 17432482 G T
22 rs4819923:17433210:T:G 0 17433210 G T
---------- Post updated at 11:59 ---------- Previous update was at 11:57 ----------
This MAY fail if either field is empty and the other has two chars. Then, try
Hi,
Is there any way to merge two lines based on specific occurance of a character in a file.
I am having a flat file which contains multiple records.
Each row in the file should contain specified number of delimiter.
For a particular row , if the delimiter count is not matched with... (2 Replies)
All,
I can't seem to find exactly what I'm looking for, and haven't had any luck patching things together.
I need to look through a file, and if the record length is not 874, then add 'E' in position 778.
Your help is greatly appreciated. (4 Replies)
Hi,
I would like to know how can I select lines of one file based on a common ID column from another file (keeping the order of the second file).
Example of file1:
ID A B C D
1-30 1 2 3
5-60 4 5 6
1-20 7 8 9
Example of file2:
ID chr pos
1-20 1 20
1-30 1 30
5-60 5 60
Desired... (2 Replies)
Hello,
I use UBUNTU 12.04.
I want to write a short program using awk to select some lines in a file based on a second file.
My first file has this format with about 400,000 lines and 47 fields:
SNP1 1 12.1
SNP2 1 13.2
SNP3 1 45.2
SNP4 1 23.4
My second file has this format:
SNP2
SNP3... (1 Reply)
Hi
I need to select lines from a txt file, I have got a line starting with ZMIO:MSISDN= and after a few line I have another line starting with 'MOBILE STATION ISDN NUMBER' and another one starting with 'VLR-ADDRESS' I need to copy these three lines as three different columns in a separate... (3 Replies)
Hi,
I am in need of help for the two things which is to be done.
First, I have a file that has around four columns. The first column is filled with letter "A".
There are around 400 lines in the files as shown below.
A 1 5.2 3.2
A 2 0.2 4.5
A 1 2.2 2.2
A 5 2.1 ... (2 Replies)
Hi,
I have a pipe delimeted text file where lines have been split over 2 lines and I need to join them back together. For example the file I have is similar to the following:
aaa|bbb
|ccc
ddd|eee
fff|ggg
|hhh
I ideally need to have it looking like the following
aaa|bbb|ccc
ddd|eee... (5 Replies)
Hi,
I need help with one problem, I came across recently.
I have one input file which I need to delimit based on character length.
$ cat Input.txt
12345sda231453
asd760kjol62569
sdasw4g76gdf57
And, There is one comma separated file which mentions "start of the field" and "length... (6 Replies)
Good day, I am a newbie here and thanks for accepting me
I have a task to modify input data where my input data looks like
123|34567|CHINE
1|23|INDIA
34512|21|USA
104|901|INDIASee that my input has two columns with different character length but max length is 5 and minimum length is 0 which... (1 Reply)
Hello,
I want to get the maximum value of each record separated by empty line based on the 3rd column of each row within each record?
Input:
A1 chr5D 634 7 82 707
A2 chr5D 637 6 82 713
A3 chr5D 637 5 82 713
A4 chr5D 626 1 82 704... (4 Replies)
Discussion started by: yifangt
4 Replies
LEARN ABOUT LINUX
aha
aha(1) Ansi HTML Adapter aha(1)NAME
aha - Ansi HTML Adapter
SYNOPSIS
aha [options] [-f datei]
DESCRIPTION
aha takes SGR-colored Input and prints W3C conform HTML-Code.
aha reads the Input from a file or stdin and writes HTML-Code to stdout.
OPTIONS --help , -h , -?
A help like this
--black , -b
Black Background and white "standard color"
--pink , -p
Pink Background
--iso X , -i X
Uses ISO 8859-X instead of utf-8. X must be 1..16
--title X , -t X
Gives the html output the title
--line-fix , -l
Uses a fix for inputs using control sequences to change the cursor position like htop. It's a hot fix, it may not work with any pro-
gram like htop. (See EXAMPLE)
EXAMPLE
aha --help | aha --black --title "the awesome aha help"> aha-help.htm
Creates an HTML file with the help of aha with black background
colordiff oldfile.c newfile.c | aha > colordiff.htm
Creates an HTML file with a colorful diff-output of two files "oldfile.c" and "newfile.c" with white background
ls --color=always | aha --pink > ls.htm
Creates an HTML file with a colorful ls-output with pink background.
echo a | htop | aha --black --line-fix > htop.htm
Creates an HTML file with the output of htop. You have to use --line-fix due the other new-line-commands htop uses.
AUTHOR
Copyleft Alexander Matthes aka Ziz 2011
zizsdl@googlemail.com
SEE ALSO
http://ziz.delphigl.com/tool_aha.php
August 31, 2011 aha(1)