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
vltsv
VLTSV(1) Quick Database Manager VLTSV(1)NAME
vltsv - mutual converter between TSV and Villa database
SYNOPSIS
vltsv import [-bin] name
vltsv export [-bin] name
DESCRIPTION
This manual page documents briefly the vltsv commands.
The command vltsv features mutual conversion between a database of Villa and a TSV text. This command is useful when data exchange with
another version of QDBM or another DBM, or when data exchange between systems which have different byte orders. This command is used in the
above format. name specifies a database name.
The subcommand export reads TSV data from the standard input. The subcommand import writes TSV data to the standard output.
OPTIONS
A summary of options is included below. For a complete description, see the file:///usr/share/doc/qdbm-doc/spex.html#villacli.
-bin treat records as Base64 format.
EXAMPLES
For example, to make a database to search `/etc/password' by a user name, perform the following command.
cat /etc/passwd | tr ':' '' | vltsv import casket
Thus, to retrieve the information of a user `mikio', perform the following command.
vlmgr get casket mikio
SEE ALSO qdbm(3), vlmgr(1), villa(3), vlopen(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 VLTSV(1)