12-22-2009
Have you searched this forum for "matching columns"? There are many threads dealing with just this type of problem. My personal suggestion would be to use a database, since it will give you fault tolerant processing and you have an additional reason to use a database, which is the large number of files. Hope this helps.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I have the following data in FILE1.CSV:
code: Amount1: Amount2:
xxxxx ,, 200 ,,400
yyxxa ,,200
bbcgu ,,2500 ,,300
i want to be able to produce the following FILE2.CSV:
code: Amount
xxxxx ,, 600... (7 Replies)
Discussion started by: chachabronson
7 Replies
2. UNIX for Dummies Questions & Answers
I want to select the first column from a daily file called foo.csv. The result is written to file foo.txt. Currently the following script is used for that:
cut -d, -f 1 foo.csv > foo.txt
A typical result would yield :
A12
A45
B11
B67
What needs to happen in addition is that two columns... (5 Replies)
Discussion started by: figaro
5 Replies
3. Shell Programming and Scripting
Hey everyone!
I have a need to add 2 files together as columns.
For instance, I have one file that has several rows of data and I want to take data from another file and add Line 1 to the end of Line1 in the first file
file1 line1.........file2 line1
file1 line2.........file2 line2... (12 Replies)
Discussion started by: Kelam_Magnus
12 Replies
4. Shell Programming and Scripting
Hello everyone,
I have two files containing 6 columns and thousands of rows. I want to add them (i.e. first column of first file + first column of second file and so on) and print the output in a third file. Can you please help me.
Thanks a lot (7 Replies)
Discussion started by: chandra321
7 Replies
5. Shell Programming and Scripting
i have a file with two columns, and i want to uniquely sort the values in fist column and add the corresponding values in the second columns
eg
file a contents
tom 200
john 300
sow 500
tom 800
james 50
sow 300
output shpould be in file b as
tom 1000
john 300
sow 800
james 50 (0 Replies)
Discussion started by: dealerso
0 Replies
6. UNIX for Dummies Questions & Answers
I have a file in which I need to add more columns to based on a key in the first file:
File1
key1,abc,123,
key2,def,456,
key3,ghi,789,
File2
key2,zyx,111,qqq,
key3,yuu,222,www,
key1,pui,333,eee,
key4,xxx,999,rrr,
I would like to create the following output:
Output (1 Reply)
Discussion started by: WongSifu
1 Replies
7. Shell Programming and Scripting
Hello all,
I'm in the process of writing a script, and I need to be able to add columns of time in the following format (time elapsed Net Backup logs):
000:01:03
000:00:58
000:00:49
Does anyone have a way of converting and/or adding timestamps such as these accurately?
Thanks in... (9 Replies)
Discussion started by: LinuxRacr
9 Replies
8. Shell Programming and Scripting
Hello,
I am using AWK in UBUNTU 12.04.
I have a dataset as follows:
1 2 12 1 4 1 4 1 7 9 4 6
1 2 4 5 7 8 45 7 4 5 7 5
What I want to do is to add the values of some columns to each other and print it in the same file as the new column while omitting the previous two columns to have... (3 Replies)
Discussion started by: Homa
3 Replies
9. Shell Programming and Scripting
Hello
I have a file as below
chr1 start ref alt code1 code2
chr1 18884 C CAAAA 2 0
chr1 135419 TATACA T 2 0
chr1 332045 T TTG 0 2
chr1 453838 T TAC 2 0
chr1 567652 T TG 1 0
chr1 602541 ... (2 Replies)
Discussion started by: plumb_r
2 Replies
10. Shell Programming and Scripting
I have two files, file1 and file2 who have identical number of rows and columns. However, the script is supposed to be used for for different files and I cannot know the format in advance. Also, the number of columns changes within the file, some rows have more and some less columns (they are... (13 Replies)
Discussion started by: maya3
13 Replies
LEARN ABOUT DEBIAN
ftwhich
FTWHICH(1) General Commands Manual FTWHICH(1)
NAME
ftwhich - fault tolerant search for a command name
SYNOPSIS
ftwhich [-#hIp][-t#] program_name
DESCRIPTION
ftwhich is a fault tolerant version of the which(1) command. ftwhich searches for a given program in all directories included in your PATH
environment variable and reports all files with a name that approximately matches the given program_name.
ftwhich achieves fault tolerance by calculating the so called Weighted Levenshtein Distance. The Levenshtein Distance is defined as the
minimum number of character insertions, deletions and replacements that transform a string A into a string B.
ftwhich is similar to the which command with the following differences:
- ftwhich is by default NOT case sensitive
- ftwhich is fault tolerant
- Some shells have a build in which command that will also search aliases. ftwhich can naturally not search for aliases as it does
not know about alias definitions.
- ftwhich lists all files that approximately match. The files first shown take preference over files of the same name printed later as
they are from directories listed earlier in the PATH.
- The level of fault tolerance can be adjusted by specifying the optional parameter tolerance. A tolerance of 0 specifies exact
match.
OPTIONS
-h Prints help/usage information.
-I Do case sensitive search (default is case in-sensitive)
-p print the actual distance value in front of the found filename. This value is equal to the number of insertions, deletions and
replacements necessary to transform the name of the found program into the search key.
-# or -t#
Set the fault tolerance level to #. The fault tolerance level is an integer in the range 0-255. It specifies the maximum number of
errors permitted in finding the approximate match. The default tolerance is (strlen(searchpattern) - number of wildcards)/6 + 1
program_name
The program file to search for. '*' and '?' can be used as wildcards.
'?' denotes one single character.
'*' denotes an arbitrary number of characters.
The last argument to ftwhich is not parsed for options as the program needs at least one program_name argument. This means that ftwhich -x
will not complain about a wrong option but search for the program named -x.
EXAMPLE
Search for all programs like gcc in your PATH:
ftwhich gcc
This will e.g. find gcc or cc or CC ...
To find all files that start with any prefix and end in config and differ in 2 letters from the word config:
ftwhich -2 '*config'
To find all files that exactly start with the prefix if:
ftwhich -0 'if*'
To find all clock programs:
ftwhich -0 '*clock*'
BUGS
The wildcards '?' and '*' can not be escaped. These characters function always as wildcards. This is however not a big problem since there
is normally hardly any command that has these characters in its name.
AUTHOR
Guido Socher (guido@linuxfocus.org)
SEE ALSO
whichman(1), ftff(1)
Search utilities January 1999 FTWHICH(1)