Removing letters after a certain character within a range of columns
Hi there,
I am trying to remove al letters after : character on specific columns from 10th column till 827. I used sed and cut to do so but I am sure there is better one liner someone can think of from unix community members.
Huge file but it has this structure (Total number of Columns = 827, rows = 605278)
Code:
#CHROM POS ID REF ALT QUAL FILTER INFO FORMAT Control1 Control2 Case1 Case2
chr1 65872 . T G 2480.51 . AC=65;AN=92;SF=0,1;VRT=1 GT:GQ:DP:AD:PL 1/1:3:243:176,66:27,3,0 0/1:21:148:135,13:21,0,21 0/1:9:250:201,49:9,0,115 .
chr1 65893 . G A 433.77 . AC=7;AN=10;SF=0,1;VRT=1 . . 0/1:173:144,29:198,0,91:91 0/1:143:100,43:180,0,233:99
I am trying to get this structure
Code:
#CHROM POS ID REF ALT QUAL FILTER INFO FORMAT Control1 Control2 Case1 Case2
chr1 65872 . T G 2480.51 . AC=65;AN=92;SF=0,1;VRT=1 GT:GQ:DP:AD:PL 1/1 0/1 0/1 .
chr1 65893 . G A 433.77 . AC=7;AN=10;SF=0,1;VRT=1 . . 0/1 0/1
Hi all,
I have a variable, on some machines it is '1024', which is fine, but on others it is '1024Mb' etc. I need this variable to simply be '1024', does anyone know how I could ensure this is always the case? Perhaps a command to remove any letters/characters that aren't integers if there is... (3 Replies)
I need help removing the last character of every line if it is a certain character. For example I need to get rid of a % character if it is in the last position.
Input:
aaa%
%bbb
ccc
d%dd%
Output should be:
aaa
%bbb
ccc
d%dd
I tried this but it gets rid of all of the % characters.... (5 Replies)
Hi all,
I am having a bit of a hard time using awk. I must do something wrong, but I don't know what... Any help would be greatly appreciated!
I read a file, as follows :...
ATOM 21 C THR A 4 23.721 -26.194 1.909 1.00 32.07 C
ATOM 22 O THR A 4 ... (2 Replies)
i have this problem:
i must hide a string with a character such as _ by command
WORD=string;
XXX=`echo $WORD | sed 's//_/g'
but after, users must send in input a character and i must to replace the _ with the input character or better i can do this
-$CHARS_INPUT
i have think to use command... (3 Replies)
I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns:
4 0.04972604 KLHL28
4 0.0497332 CSTB
4 0.04979822 AIF1
4 0.04983331 DECR2
4 0.04990344 KATNB1
4
4
4
4
How can I remove the trailing... (3 Replies)
hi, I have quite a bunch of files with annoyingly long filenames. I wanted to cut the range of characters from 9-18 and just retain the first 8 characters and the .extension. any suggestion how to do it. thanks much.
original filename: 20000105_20000105_20100503.nc.asc
output filename:... (4 Replies)
Hi,
I columns with both number and letters however i need the number 4 trimmed off the lines that have 3 numbers in them so it just because the 2 preceding numbers only
For example
V25QG2-K18QG-V25CG2
L26HG-L17HA-L26CG
I434QD1-L19HB2-I434CD1
I434QD1-A31QB-I434CD1 ... (7 Replies)
Hi all,
Disclosure: I am very new to Unix, but eager to learn..
I've been tasked with transferring logs to a remote server. After I've verified these logs have transferred correctly I have to remove the source files. The naming scheme is:
/directory/2012.05.01
/directory/2012.05.02
..and... (1 Reply)
Hi,
I want to remove trace files in a particular directory for a specific date range. Currently i can remove based on time (e.g find /path/*.trm -mtime +1000 -exec rm {} \;). But i want to remove .trm files within a date range. E.g to remove .trm files between jan 1 2002 to April 15 2005.
... (3 Replies)
In each line of file, I wish to check if word1 is a non-connected subset of any of the other words in the line. If yes, keep only the words that ward1 is a subset of. Else, remove the whole line.
Also, I want to remove the letters that word1 doesn't match with, except for "_+"
Example file:... (2 Replies)
Discussion started by: Viernes
2 Replies
LEARN ABOUT REDHAT
column
COLUMN(1) BSD General Commands Manual COLUMN(1)NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
Column exits 0 on success, >0 if an error occurred.
ENVIRONMENT
COLUMNS The environment variable COLUMNS is used to determine the size of the screen if no other information is available.
EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY HH:MM/YEAR NAME
"
; ls -l | sed 1d) | column -t
SEE ALSO colrm(1), ls(1), paste(1), sort(1)HISTORY
The column command appeared in 4.3BSD-Reno.
BSD June 6, 1993 BSD
01-03-2017
Removing letters after a certain character within a range of columns
