COMPARING COLUMNS IN A TEXT FILE Post: 302502686

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with comparing columns from a csv file

Hi there, I have an csv file. I want to compare the 16th and 18th columns. They contain alpha numeric characters. Some are same and some are different. We have to pick the ones which are different. But with certain rules. 16th col. 18th col. ---------- ...

2. Shell Programming and Scripting

Comparing Columns and printing the difference from a particular file

Gurus, I have one file which is having multiple columns and also this file is not always contain the exact columns; sometimes it contains 5 columns or 12 columns. Now, I need to find the difference from that particular file. Here is the sample file: param1 | 10 | 20 | 30 | param2 | 10 |...

3. UNIX for Dummies Questions & Answers

How to convert text to columns in tab delimited text file

Hello Gurus, I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem? The input file example, ...

4. UNIX for Dummies Questions & Answers

Comparing the 2nd column in two different files and printing corresponding 9th columns in new file

Dear Gurus, I am very new to UNIX. I appreciate your help to manage my files. I have 16 files with equal number of columns in it. Each file has 9 columns separated by space. I need to compare the values in the second column of first file and obtain the corresponding value in the 9th column...

5. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns: 4 0.04972604 KLHL28 4 0.0497332 CSTB 4 0.04979822 AIF1 4 0.04983331 DECR2 4 0.04990344 KATNB1 4 4 4 4 How can I remove the trailing...

6. Shell Programming and Scripting

Comparing columns in a file

I have two files. One a small one and another one is big. The smaller one look like this: Filename: 1.tmp 3453 0 326543 1 2321 0 3212 1 The big file looks like this: Filename 1.res 0.3232 2321 9.2922 123 0.983 3212 8.373 326543 0.9 3453 1.098 3432 I want to extract those lines...

7. Shell Programming and Scripting

Comparing Columns and writing a new file

I have a table with one column File1.txt 1 2 3 4 5 6 7 8 9 10 Another table with two columns; This has got a subset of entries from File 1 but not unique because they have differing values in col 2. File2.txt 1 a 2 d 2 f 6 r 6 e

8. Shell Programming and Scripting

Comparing Select Columns from two CSV files in UNIX and create a third file based on comparision

Hi , I want to compare first 3 columns of File A and File B and create a new file File C which will have all rows from File B and will include rows that are present in File A and not in File B based on First 3 column comparison. Thanks in advance for your help. File A A,B,C,45,46...

9. Shell Programming and Scripting

How to concatenate 2-columns by 2 -columns for a text file?

Hello, I want to concatenate 2-columns by 2-columns separated by colon. How can I do so? For example, I have a text file containing 6 columns separated by tab. I want to concatenate column 1 and 2; column 3 and 4; column 5 and 6, respectively, and put a colon in between. input file: 1 0 0 1...

10. Shell Programming and Scripting

Comparing columns in 2 text files

Hi i have 2 files file1.txt XX,ZZ,XC,EE,RR,BB XC,CF,FG,RG,GH,GH File2.txt DF,GH,MH,FR,FG,GH,NOTOK XX,ZZ,XC,EE,RR,BB,OK result XX,ZZ,XC,EE,RR,BB OK look for column1 , XX and if it matches in File2.txt , retrieve the 7 th field from File2 and print in 3 rd file , ...

LEARN ABOUT DEBIAN

update-desktop-database

UPDATE-DESKTOP-DATABASE(1)				      General Commands Manual					UPDATE-DESKTOP-DATABASE(1)

NAME

       update-desktop-database - Build cache database of MIME types handled by desktop files

SYNOPSIS

       update-desktop-database [-q|--quiet] [-v|--verbose] [DIRECTORY...]

DESCRIPTION

       The update-desktop-database program is a tool to build a cache database of the MIME types handled by desktop files.

       The  cache database contains the list of MIME types that can be handled by desktop files, as well as, for each MIME type, a list of desktop
       files that can handle this MIME type. This cache database ease the work of applications that need to find an application that  can  open  a
       document  of  a specific MIME type: those applications will not have to parse all the desktop files existing on the system, and can instead
       parse this cache database.

       If no DIRECTORY is specified as argument, the desktop files that will be processed are the ones installed in $XDG_DATA_DIRS/applications.

       If both the --quiet and --verbose options are used, then --verbose will be ignored.

OPTIONS

       The following options are supported:

       -q, --quiet
	      Do not display any information about processing and updating progress.

       -v, --verbose
	      Display more information about processing and updating progress.

NOTES

       If an invalid MIME type is met, it will be ignored and the creation of the cache database will continue.

       The format of the cache database is a simple desktop entry format, with a MIME Cache group, containing one key per MIME type. The key  name
       is the MIME type, and the key value is the list of desktop file that can handle this MIME type.

       The  order  of the desktop files found for a MIME type is not significant.  Therefore, an external mechanism must be used to determine what
       is the preferred desktop file for a MIME type.

EXAMPLE

       Here is a simple example of a cache database:

	       [MIME Cache]
	       application/x-shellscript=gedit.desktop;
	       text/plain=gedit.desktop;gvim.desktop;
	       video/webm=totem.desktop;

       This cache database is created with three desktop files, each containing a MimeType key:

	       gedit.desktop: MimeType=text/plain;application/x-shellscript;
	       gvim.desktop: MimeType=text/plain;
	       totem.desktop: MimeType=video/webm;

FILES

       $XDG_DATA_DIRS/applications/mimeinfo.cache

	      This file is the cache database created by update-desktop-database.

BUGS

       If you find bugs in the update-desktop-database program, please report these on https://bugs.freedesktop.org.

								  FREEDESKTOP.ORG					UPDATE-DESKTOP-DATABASE(1)