It "seems" but it doesn't.
In order to work, the array n would have to contain each possible line you want to keep. In fact, for the example provided, it would have to be @n = (5, 6, 7, 10).
If each of your files "*.txt" has the same configuration, it might work as:
Code:
perl -ne 'BEGIN{@n=(5,6,7,10)} $p ne $ARGV and $.=1; s/^#//; print if $. ~~ @n; $p=$ARGV' *.txt > output.txt
This might be better:
Code:
perl -ne 's/^#(Display|identifier|Gender|Quality)/$1/ and print' *.txt > out.txt
Your comment in within parenthesis is a bit ambiguous:
Quote:
#Quality = X.XXXXXX (keep this field without the # and X.XXX)
You show the desired output as:
Quote:
Quality = X.XXXXXX (keep this field without the # and X.XXX)
If what you mean is:
Quote:
Quality = X.XXX (keep this field without the # and X.XXX)
... and the X.XXXXXX represents a floating point, then:
Code:
perl -ne '(s/^#(Display|identifier|Gender)/$1/ or s/^#(Quality = \d\.\d{3})\d+/$1/) and print' *.txt > output.txt
Last edited by Aia; 03-25-2016 at 10:38 PM..
Reason: Addressing the ambiguous part
Hi,
I am looking for a method to get column13 to column 50 data from the 1st line of a multiline reord. The records are stored in a large file and are separated by newline. sample format is
(data in red is to be extracted)
<header>
A001dfhskhfkdsh hajfhksdhfjh... (3 Replies)
Hi,
I am writing a code where the file is a pipe delimited and I would need to extract the 2nd part of field2 if it is "ATTN", "C/O" or "%" and check to see if field9 is populated or not. If field9 is already populated then leave it as is but if field9 is not populated then take the 2nd part of... (3 Replies)
Hi,
I have a file with following lines:
chr1 10 AC=2;AF=1.00;AN=2;DP=2;Dels=0.00;HRun=0;HaplotypeScore=0.00;MQ=23.00;MQ0=0;QD=14.33;SB=-10.01
chrX 18 AB=0.52;AC=1;AF=0.50;AN=2;DP=203;DS;Dels=0.00;HRun=0;HaplotypeScore=20.01;MQ=15.63;MQ0=85;QD=12.80;SB=-1289.58
I need to extract 4... (2 Replies)
Hi,
I want to split/parse certain bits of the hex data into another field.
Example:
Input data is
Word1: 4f72abfd
Output:
Parse bits (5 to 0) into field word1data1=0x00cd=205 decimal
Parse bits (7 to 6) into field word1data2=0x000c=12 decimal
etc.
Word2: efff3d02
Parse bits (13 to... (1 Reply)
Hello,
:wall:
I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books.
I know this does not work
/^*,*,*,*,*,*,"hello",*,*,*,*,"goodbye"/d
Any ideas?
Thanks
Please... (2 Replies)
Dear Friends,
I have a file
a.txt
1|3478.12|487|4578.04|4505.5478|rhfj|rehtire|rhj
I want to get the field numbers which have decimal values
output:
Fields: 2,4,5
Plz help (6 Replies)
Hi
I need to generate these output file from the below input file.
Output :
customer_id as customer,
zip as zip_cd,
catg_cd as catg,
Input:
out.customer::in.customer_id;
out.zip_cd::in.zip;
out.catg::in.catg_cd;
Could you please help me on this.
Please use code tags next... (1 Reply)
In the below awk I am trying output to one file those lines that match between $2,$3,$4 of file1 and file2 with the count in (). I am also trying to output those lines that are missing between $2,$3,$4 of file1 and file2 with the count of in () each. Both input files are tab-delimited, but the... (7 Replies)
Hello All,
I have a requirement to split the input.xml file different files and i have tried using earlier examples(where i have posted in the forum), but still no luck
Here is my input.xml
<jms-system-resource>
<name>UMSJMSSystemResource</name>
... (4 Replies)