Hello all
siteexplorer.search.yahoo.com can output results in tsv format, when opened in excel I get 4 columns.
I would like to wget that file, which I can do. I would then like to pull the 2nd column and output it only.
I've searched around and found a few bits and pieces but nothing I've... (6 Replies)
Hi Guys,
I have to write a script to compare the tsv files headers with the values stored in the variable in bash.
I have declared variables as
HEADER_VERSION="All Versions\tVersion Type\tVersion\tLevel"
now file contains data as follows:
All Versions Version Type Version Level... (0 Replies)
Hi All
I have one query,say i have a requirement like the below code should be
move to diffent files whose maximum lines can be of 10 lines.Say in the below example,it consist of 14 lines.
This should be moved logically using the data in the fisrt coloumn to file1 and file 2.The data of first... (2 Replies)
Please help me figure out whats wrong with my code,
I have to split a file according to values in 3rd thru 6th column,
If the 3rd or 4th col values are >0, row goes to 1 file, if 3rd and 5th are >0,row goes to another file...and so on...
What is wrong with my code? It doesn't seem to work.... (2 Replies)
i have file1.txt
asdas|csada|130310|0423|A1|canberra
sdasd|sfdsf|130426|2328|A1|sydney
Expected output : on eaceh third and fourth colum, split into each two characters
asdas|csada|13|03|10|04|23|A1|canberra
sdasd|sfdsf|13|04|26|23|28|A1|sydney (10 Replies)
Hi all,
I am trying to split a file by the values of the FIRST column.
The following awk works to split the file by the value of the LAST column -- How can I alter this to divide the column by the FIRST column??
awk -F"\t" '{ print > $NF ; close($NF)}' filename1Thanks! (5 Replies)
Hi,
i need help to extract certain strings/words from lines with different length. I have 3 columns separated by tab delimiter. like below
Probable arabinan endo-1,5-alpha-L-arabinosidase A (EC 3.2.1.99) (Endo-1,5-alpha-L-arabinanase A) (ABN A) abnA Ady3G14620
Probable arabinan... (5 Replies)
Hello all,
I have a csv with with different testcase values in column 5.
year,min,max,Instrument,Testcase
2016,201,1003,GEOTROPH-02116,TATA7980
2016,53,1011,GEOTROPH-01963,TATA7980
2016,3,1024,GEOTROPH-02067,TATA7980
2016,203,1027,GEOTROPH-02011,TATA7980... (16 Replies)
The following is my code
nawk -F',' '
BEGIN { printf "MSISDN,IMSI,NAM,TS11,TS21,TS22,OBO,OBI,BAIC,BAOC,BOIC,BOIEXH,APNID0,APNID1,APNID2,APNID3,APNID0,CSP,RSA\n" }
{
for(i=1; i<=NF; i++)
{
split($i,a,":")
gsub(" ","", a)
printf "%s;",a
}
printf "\n"
}'HLR_DUMP_BZV >> HLR_full
This is... (1 Reply)
Discussion started by: gillesi
1 Replies
LEARN ABOUT DEBIAN
cbcodec
CBCODEC(1) Quick Database Manager CBCODEC(1)NAME
cbcodec - popular encoders and decoders
SYNOPSIS
cbcodec url [-d] [-br] [-rs base target] [-l] [-e expr] [file]
cbcodec base [-d] [-l] [-c num] [-e expr] [file]
cbcodec quote [-d] [-l] [-c num] [-e expr] [file]
cbcodec mime [-d] [-hd] [-bd] [-part num] [-l] [-ec code] [-qp] [-dc] [-e expr] [file]
cbcodec csv [-d] [-t] [-l] [-e expr] [-html] [file]
cbcodec xml [-d] [-p] [-l] [-e expr] [-tsv] [file]
cbcodec zlib [-d] [-gz] [-crc] [file]
cbcodec lzo [-d] [file]
cbcodec bzip [-d] [file]
cbcodec iconv [-ic code] [-oc code] [-ol ltype] [-cn] [-wc] [-um] [file]
cbcodec date [-wf] [-rf] [-utc] [str]
DESCRIPTION
This manual page documents briefly the cbcodec commands.
cbcodec is a tool to use encoding and decoding features provided by Cabin. This command is used in the above format. file specifies a
input file. If it is omitted, the standard input is read.
OPTIONS
A summary of options is included below. For a complete description, see the file:///usr/share/doc/qdbm-doc/spex.html#cabincli.
-d perform decoding (unescaping), not encoding (escaping).
-br break up URL into elements.
-rs resolve relative URL.
-l output the tailing newline.
-e expr
specify input data directly.
-c num limit the number of columns of the encoded data.
-hd parse MIME and extract headers in TSV format.
-bd parse MIME and extract the body.
-part num
parse MIME and extract a part.
-ec code
specify the input encoding, which is UTF-8 by default.
-qp use quoted-printable encoding, which is Base64 by default.
-dc output the encoding name instead of the result string when decoding.
-t parse CSV. Convert the data into TSV. Tab and new-line in a cell are deleted.
-html parse CSV. Convert the data into HTML.
-p parse XML. Show tags and text sections with dividing headers.
-tsv parse XML. Show the result in TSV format. Characters of tabs and new-lines are URL-encoded.
-gz use GZIP format.
-crc output the CRC32 checksum as hexadecimal and big endian.
-ic code
specify the input encoding, which is detected automatically by default.
-oc code
specify the output encoding, which is UTF-8 by default.
-ol ltype
convert line feed characters, with `unix'(LF), `dos'(CRLF), and `mac'(CR).
-cn detect the input encoding and show its name.
-wc count the number of characters of the input string of UTF-8.
-um output mappings of UCS-2 characters and C strings of UTF-16BE and UTF-8.
-wf output in W3CDTF format.
-rf output in RFC 1123 format.
-utc output the coordinate universal time.
SEE ALSO qdbm(3), cabin(3).
AUTHOR
QDBM was written by Mikio Hirabayashi <mikio@fallabs.com>.
This manual page was written by Fumitoshi UKAI <ukai@debian.or.jp>, for the Debian project (but may be used by others).
Man Page 2005-05-23 CBCODEC(1)