I have a comma delimited file as per the one below and I am currently extracting the values in 2 columns (COL1 & COL6) to produce a smaller trimmed down version of the file which only contains the columns we need;
I now have an additional requirement to only extract the values of COL1 & COL6 when COL9 has value present(could be anything) i.e. lines 1,3,4
The output produced would therefore look something like;
I have the below code which extracts only COL1 & COL2, but need to additional functionality
Hi,
In ksh, I have a file with similar rows as follows:
Department = 1234 G/L Asset Acct No = 12.0000. 2/29/2008
Department = 1234 G/L Asset Acct No = 13.0000. 3/29/2008.
I want to create a new text file that contains only the numbers and date:
1234 12.0000. 2/29/2008
1234 13.0000. ... (16 Replies)
I have huge fixed width, text file in unix box and I need to extract columns found between the width 105 and 200 and output it to a new file.
Can anyone tell me how to extract it?
Thanks for your help. (1 Reply)
It may sounds too easy but appreciate any help on this..
i have a file with the below details:
******************************************
Please find the locked pernr details for the Time evaluation
Personnel number could not be locked
Person rejected: 04552737
Personnel number could not... (4 Replies)
Hi All,
I have 2 issues while working with file.
1. I have 2 delimited(~) files. I want to extract column numbner 3 from file1 and column number 8 from file2 and paste it into file3. I have tried using cut, but not able to get answer.
2. i have 2 filxed-width file. I wanted to do same... (1 Reply)
Hi All,
Could you please help me with following:
I have to parse a .csv file.
For example: If the csv file contains 3 columns, then i have to print the column names. The field separator is (comma).
example.csv (contains 2 lines as follows)
This is,a test file, for validation... (2 Replies)
Hi experts,Please help me for the below requirement.i have a source file.(lets say contains 50 columns). I am extarcting five columns from the source file by using pattern file.for exampleinput file:--------a,b,c,d,"a,g","v b",s,koutputfile=======a,"a,g","v b",s,kThanks in advancesubhendu (1 Reply)
Hi
I have a file of the form
name1,lastname1,email1@gmail.com,9.08243E+12,team1,role1,username1,password1
name2,lastname2,email2@gmail.com,9.08243E+11,team2,role2,username2,password2
I need to extract the email (column 3) and send a mail to each person, with their details ( specifically... (3 Replies)
Hi all
I need your help to separate colomns based on "-" delimiter for a very big file 30 millions rows
I have a colmun looking like this :
clomun 1
1-100000989-A_ATC
1-10000179-AAAAA
1-100002154-TGTTA
1-100002155-GTTAG
1-100002443
1-100002490
1-100002619
I need to separte in three... (5 Replies)
hello,
i have publicly available txt file with little less than 300000 rows. i want to extract from column 1 to column 218 and save it in another text file. i use the cut command but the file is saved with multiple rows from the source file onto a single row in the destination. basically it is... (6 Replies)
Kindly help merging information from two files with the following data structure.
I want to match for the CHR-SNP in Foo and get the columns that match from CHROM-rsID
Fields 1 & 2 of foo may have duplicates, however, a joint key of Fields $1$2$3$4 is unique.
Also would be helpful to clean up... (4 Replies)
Discussion started by: genehunter
4 Replies
LEARN ABOUT DEBIAN
dane
DANE(1) Internet / DNS DANE(1)NAME
dane - Generate TLSA/HASTLS DNS records by scanning SSL/TLS sites
SYNTAX
dane [-v] [-q] [-h] [-v] [--draft|--rfc] [--sha256] [--sha512] [--full] [--insecure] [--pubkey] [--txt] [--eecert] [--cacert] [-4] [-6]
[--axfr] [-n <nameserver>] host1 [host2 ...]] [@nameserver]]
DESCRIPTION
dane generates TLSA/HASTLS records based on the IETF DANE working group proposal. These are currently in draft, so private RRTYPE
assignments are used. Records are generated by connecting to the website using SSL and grabbing its (EE) certificate. If the nameserver of
the domain allows zone tranfers (AXFR), an entire domain can be processed for all its A/AAAA records.
OPTIONS -n / --nameserver <hostname1>
Use specified nameserver for AXFR query
-q / --quiet
Supress all warnings - useful when scanning lots of host where some do not run SSL
--axfr
Use AXFR. Implies -n nameserver (or @nameserver). Hosts are treated as zones to AXFR.
--tlsa
Output TLSA record from SSL server scan results (default)
--eecert
Output TLSA record format EE certificates (type 1) (default)
--pubkey
Output TLSA record for just the public key (type unassined) (not implemented yet)
--txt
Output Kaminsky style TXT record for (not implemented yet)
--cacert
Output TLSA record for the entire CA chain and EE-cert (not yet implemented)
--sha256
Output TLSA record reference type 1 (SHA256) records (default)
--sha512
Output TLSA record reference type 2 (SHA512) records
--full
Output TLSA record reference type 0 (full cert) records
--draft
Output Unknown Resource Record format with private RRTYPE assignment. This is used while the standard is still in draft form, and for
when your nameserver does not (yet) support the new RRTYPE names. This option is the default (if --rfc is not specified) as long as
dane is has not be released as RFC.
--rfc
Specify records using the RRTYPE's TLSA (and HASTLA)
--insecure
Continue scanning even if the A/AAAA records could not be validated using DNSSEC
-4
Only use ipv4 networking - do not attempt to connect to AAAA SSL sites
-6
Only use ipv6 networking - do not attempt to connect to A SSL sites
-h / --help
Output help information and exit.
-v / --version
Output version information and exit.
FILES
~/.ssh/known_hosts
REQUIREMENTS
dane requires python-dns and python-argparse(http://www.pythondns.org)
Fedora: yum install python-dns python-argparse
Debian: apt-get install python-dnspython python-argparse
BUGS
I'm sure there are
EXAMPLES
typical usage:
dane www.xelerance.com
dane --rfc --sha512 www.xelerance.com
dane --insecure --draft xelerance.com @ns0.xelerance.net
SEE ALSO sshfp(1)ssh(1) and RFC-XXXX
http://www.xelerance.com/software/sshfp/
http://lists.xelerance.com/mailman/listinfo/sshfp/
AUTHORS
Paul Wouters <paul@xelerance.com>
COPYRIGHT
Copyright 2011 Xelerance Corporation
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version. See
<http://www.fsf.org/copyleft/gpl.txt>.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License (file COPYING in the distribution) for more
details.
Paul Wouters April 12, 2011 DANE(1)