Grabbing strings with awk Post: 302751659

Sponsored Content

Top Forums Shell Programming and Scripting Grabbing strings with awk Post 302751659 by Error404 on Friday 4th of January 2013 09:29:32 AM

01-04-2013

Registered User

Grabbing strings with awk

Hello everyone,
I am doing some sort of analysis for some data about organic solvents, and I have a problem with writing a command to do this:

Here's a sample of my file:

Code:

 
1     ethanol
2     methanol
3     methanol/ethanol
4     ethanol/methanol
5     ethanol/DMF
6     ethyl ether/methanol
7     ethanol methanol
8     methanol ethanol
9     ethanol-Methanol
10   methanol-Ethanol
11   methanol-DMF
12   ethyl ether/Methanol
13   DMF
14   chloroform

This is a tab separated file, I am trying to generate a new file that contains combinations of ethanol and anything else using "awk".
also, I am trying to generate another file that contains exactly the other way around, everything but ethanol.

Please note that the word "Methanol" contains "ethanol" inside it as a string.
Also, the separation is not regular, sometimes a slash and sometimes a space.
Do you know what command i should use to get over this problem?

I am currently using this command :

Code:

 
awk 'BEGIN{IGNORECASE=1} $2 ~ /ethanol/' filepath

but this is giving me methanol as well. I am looking for combinations containing ethanol in one file, and everything else in another file.

Cheers,

Error404

View Public Profile for Error404

Find all posts by Error404

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

using AWK how to extract text between two same strings

I have a file like: myfile.txt it is easy to learn awk and begin awk scripting and awk has got many features awk is a powerful text processing tool Now i want to get the text between first awk and immediate awk not the third awk . How to get it ? its urgent pls help me and file is unevenly...

2. Shell Programming and Scripting

awk and NMEA strings

Hi all: I have a file with NMEA sentences of the type: $GPVTG,012.0,T,,M,00.0,N,,K*7D $GPRMC,180541,A,3631.874,N,00617.423,W,00.0,004.0,210608,,*36 $SDDBT,,f,,M,,F*28 $GPGLL,3631.874,N,00617.423,W,180542,A*3B $GPVTG,009.0,T,,M,00.0,N,,K*77 $GPVTG,019.0,T,,M,00.0,N,,K*76...

3. Shell Programming and Scripting

awk script for replacing 2 strings

Hi I have written a script for automating a program. There is a string in 2 lines that needs altering from input. The 2 lines are: prepare_flexreceptor4.py -r rec_rigid.pdbqt -s TYR119_TRP312 -x rec_flex.pdbqt and prepare_flexdocking4.py -l ind.pdbqt -r rec_flex.pdbqt -s TYR119_TRP312...

4. Shell Programming and Scripting

awk to get text between 2 strings

Hi, I am trying different scenarios now, 1 of those is getting the text between the following 2 strings. Type of msg: -in_full >date >alr text >ID_on_exit AWXX-Ready to commit (98) msg type: (10) I need to get all the occurrences having the same start line and end line....

5. Shell Programming and Scripting

awk Splitting strings

Hi All, There is a file with a data. If the line is longer than 'n', we splitting the line on the parts and print them. Each of the parts is less than or equal 'n'. For example: n = 2; "ABCDEFGHIJK" -> length 11 Results: "AB" "CD" EF" GH" "IJ" "K" Code, but there are some errors....

6. Shell Programming and Scripting

Get data from file using awk within strings.

i am having the text data file as below. Processing 1 a 111111 b c d e f Processing 2 a b 222222 c erorr d e f Processing 3 a b 3333

7. Shell Programming and Scripting

Using awk to replace strings

Hi.. I have a file that has the following content : abc 213 24 213 pqr 456#34 678 xyz 213 45%213 i need to write an awk script that will replace the second 213 in all the lines, if it is present. The IFS can not be specified and can be random. The number of lines in the file and the...

8. UNIX for Beginners Questions & Answers

Use strings from nth field from one file to match strings in entire line in another file, awk

I cannot seem to get what should be a simple awk one-liner to work correctly and cannot figure out why. I would like to use patterns from a specific field in one file as regex to search for matching strings in the entire line ($0) of another file. I would like to output the lines of File2 which...

9. Shell Programming and Scripting

awk to get multiple strings in one variable

I am processing a file using awk to get few input variables which I'll use later in my script. I am learning to script using awk so please advise in any mistakes I made in my code. File sample is as follows # cat junk1.jnk Folder1 : test_file (File) ...

10. UNIX for Beginners Questions & Answers

(g)awk: Matching strings from one file in another file between two strings

Hello all, I can get close to what I am looking for but cannot seem to hit it exactly and was wondering if I could get your help. I have the following sample from textfile with many thousands of lines: File 1 PS001,001 HLK PS002,004 L<G PS004,002 XNN PS004,006 BVX PS004,006 ZBX=...

LEARN ABOUT DEBIAN

merge_fonts

merge_fonts(3alleg4)						  Allegro manual					      merge_fonts(3alleg4)

NAME

       merge_fonts - Merges two fonts into one font. Allegro game programming library.

SYNOPSIS

       #include <allegro.h>

       FONT *merge_fonts(FONT *f1, FONT *f2)

DESCRIPTION

       This function merges the character ranges from two fonts and returns a new font containing all characters in the old fonts. In general, you
       cannot merge fonts of different types (eg, TrueType fonts and bitmapped fonts), but as a special case, this function can  promote  a  mono-
       chrome bitmapped font to a color font and merge those. Example:

	  FONT *myfont;
	  FONT *myfancy_font;
	  FONT *lower_range;
	  FONT *upper_range;
	  FONT *capitals;
	  FONT *combined_font;
	  FONT *tempfont;
	  ...
	  /* Create a font that contains the capitals from  */
	  /* the fancy font but other characters from myfont */
	  lower_range = extract_font_range(myfont, -1, 'A'-1);
	  upper_range = extract_font_range(myfont, 'Z'+1, -1);
	  capitals = extract_font_range(myfancy_font, 'A', 'Z');

	  tempfont = merge_fonts(lower_range, capitals);
	  combined_font = merge_fonts(tempfont, upper_range);

	  /* Clean up temporary fonts */
	  destroy_font(lower_range);
	  destroy_font(upper_range);
	  destroy_font(capitals);
	  destroy_font(tempfont);

RETURN VALUE

       Returns a pointer to the new font or NULL on error. Remember that you are responsible for destroying the font when you are finished with it
       to avoid memory leaks.

SEE ALSO

       extract_font_range(3alleg4), is_trans_font(3alleg4), is_color_font(3alleg4), is_mono_font(3alleg4), exfont(3alleg4)

Allegro 							   version 4.4.2					      merge_fonts(3alleg4)