To find similar items in a column Post: 302797817

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk between items including items

OS=HP-UX ksh The following works, except I want to include the <start> and <end> in the output. awk -F '<start>' 'BEGIN{RS="<end>"; OFS="\n"; ORS=""} {print $2} somefile.log' The following work in bash but not in ksh sed -n '/^<start>/,/^<end>/{/LABEL$/!p}' somefile.log

2. Shell Programming and Scripting

Help with merge two file based on similar column content

Input file 1: A1BG A1BG A1BG A1CF A1CF BCAS BCAS A2LD1 A2M A2M HAT . . Input file 2: A1BG All A1CF TEMP

3. Shell Programming and Scripting

Merge two files with similar column entries

Hi , I have few files which contains user name and data transfer rate in MBs and this data is collected for year and for each month report is saved in 12 different files I have to merge all the files to prepare the final report Files are as below Similarly I have 10 more files ...

4. UNIX for Advanced & Expert Users

find/grep two items and display both

I have a file against which I can grep a string for. I can also check for that string count using wc -l (or grep -c). I need to display the results of both in one output i.e. 'line containing string' and 'count' - what would be the most efficient way of managing this? Thanks in advance.

5. UNIX for Dummies Questions & Answers

Find the average based on similar names in the first column

I have a table, say this: name1 num1 num2 num3 num4 name2 num5 num6 num7 num8 name3 num1 num3 num4 num9 name2 num8 num9 num1 num2 name2 num4 num5 num6 num4 name4 num4 num5 num7 num8 name5 num1 num3 num9 num7 name5 num6 num8 num3 num4 I want a code that will sort my data according...

6. Shell Programming and Scripting

Add all 4 column entries for similar column ids

Hi, I want to write a script which will add the entries in all columns for the same column id. I can do it in excel, but I need to do this for 384 columns which will come down to 96 (384/4). How can I do this iteratively A A A A B B B B C C C C 1 0 1 0 2 1 4 5 3 4 5 6 2 0 0 2 3 5 70 100 1...

7. Shell Programming and Scripting

Find odd numbered items from a csv

Hi, This question might seem bit confusing. Sorry for that. I have tried to express myself as clear as possible. I have a text file in following format: abc_456_def,abc_457_def,123_458_def,abc_3_459_def,zbc_123_456_def ybc_123_457_def,xbc_3_458def,ybc_124_457_def I want to check the...

8. Shell Programming and Scripting

Read a lis, find items in a file from the list, change each item

Hello, I have some tab delimited text data, file: final_temp1 aname val NAME;r'(1,) 3.28584 r'(2,)<tab> NAME;r'(3,) 6.13003 NAME;r'(4,) 4.18037 r'(5,)<tab> You can see that the data is incomplete in some cases. There is a trailing tab after the first column for each incomplete row. I...

LEARN ABOUT DEBIAN

letterize

LETTERIZE(1)							    Miscellanea 						      LETTERIZE(1)

NAME

       letterize_ - phone-number to letter-mnemonic generator

SYNOPSIS

       letterize nnnnnnn

DESCRIPTION

       This program tries to help you find a letter mnemonic matching a given phone number.

       It emits to standard output each possible pronounceable mnemonic, one per line, using the American standard mapping of dial letters to
       numbers (2 goes to ABC, 3 to DEF, 4 to GHI, 5 to JKL, 6 to MNO, 7 to PRS, 8 to TUV, 9 to XYZ).

       The program uses a table of pronounceable letter-triples derived from a dictionary scan. Each potential mnemonic must be such that all of
       its letter-triples are in the table to be emitted. About 30% of possible triples are considered pronounceable.

       A typical 7-digit phone number has 19,683 possible mnemonics, but this test usually cuts the list down to a few hundred or so, a reasonable
       number to eyeball-check. For some numbers, the list will, sadly, be empty.

       It's best to leave out punctuation such as dashes and parens.

BUGS

       The filtering method doesn't know what plausible medial triples are not reasonable at the beginnings and ends of words.

       I'm not sure what table position 0 (which is what 0 and 1 are mapped to) means. If you figure it out, you tell me. I really should have
       generated my own table, but that would have been more work than this seemed worth -- if your number contains either, you probably need to
       generate your mnemonic in disjoint pieces around the digits anyway.

AUTHOR

       Eric S. Raymond esr@snark.thyrsus.com. It's based on a table of plausible letter-triples that had no name attached to it. Surf to
       http://www.catb.org/~esr/ for updates and related resources.

letterize							    05/30/2012							      LETTERIZE(1)