Sponsored Content
Top Forums Shell Programming and Scripting Need help please with Grep/Sed command to extract text and numbers from a file Post 302510105 by yinyuemi on Friday 1st of April 2011 02:19:16 PM
Old 04-01-2011
Code:
 echo "DSPLY_NAME "DISPLAY NAME" 3 NULL ALPHANUMERIC 16 RMTES_STRING 16
YTM_HIFLAG "YTM HIGH FLAG" 160 NULL ALPHANUMERIC 1 RMTES_STRING 1
YTM_LOFLAG "YTM LOW FLAG" 161 NULL ALPHANUMERIC 1 RMTES_STRING 1
BUYER_ID "BUYER ID" 162 NULL ALPHANUMERIC 4 RMTES_STRING 4
SELLER_ID "SELLER ID" 163 NULL ALPHANUMERIC 4 RMTES_STRING 4
MKT_MKR_NM "MRKT MAKER NAME" 214 NULL ALPHANUMERIC 16 RMTES_STRING 16
ROW64_2 "MONROW 2" 216 NULL ALPHANUMERIC 64 RMTES_STRING 64
ROW80_2 "IRGROW 2" 316 NULL ALPHANUMERIC 80 RMTES_STRING 80" |grep -Po 'ALPHANUMERIC [0-9]+'
ALPHANUMERIC 16
ALPHANUMERIC 1
ALPHANUMERIC 1
ALPHANUMERIC 4
ALPHANUMERIC 4
ALPHANUMERIC 16
ALPHANUMERIC 64
ALPHANUMERIC 80

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

grep or awk problem, unable to extract numbers

Hi, I've trouble getting some numbers from a html-file. The thing is that I have several html-logs that contains lines like this: nerdnerd, how_old_r_u:45782<br>APPLY: <hour_second> Verification succeded This is some of what I've extracted from a html file but all I really want is the number... (7 Replies)
Discussion started by: baghera
7 Replies

2. Shell Programming and Scripting

Sed to grep only numbers in string

Hi, I would like to get only number in the following strings. var1="Type20" var2="type 3" var3="value 2" var4="Type 1 Datacenter Hall 2" I would like to extract output as 20 from var1 and 3 from var2,2 from var3 and 1 from var4. Appreciate any one help asap.. Regards, Aji (5 Replies)
Discussion started by: ajilesh
5 Replies

3. Shell Programming and Scripting

sed to extract only floating point numbers from HTML

Hi All, I'm trying to extract some floating point numbers from within some HTML code like this: <TR><TD class='awrc'>Parse CPU to Parse Elapsd %:</TD><TD ALIGN='right' class='awrc'> 64.50</TD><TD class='awrc'>% Non-Parse CPU:</TD><TD ALIGN='right' class='awrc'> ... (2 Replies)
Discussion started by: pondlife
2 Replies

4. UNIX for Advanced & Expert Users

bash/grep/awk/sed: How to extract every appearance of text between two specific strings

I have a text wich looks like this: clid=2 cid=6 client_database_id=35 client_nickname=Peter client_type=0|clid=3 cid=22 client_database_id=57 client_nickname=Paul client_type=0|clid=5 cid=22 client_database_id=7 client_nickname=Mary client_type=0|clid=6 cid=22 client_database_id=6... (3 Replies)
Discussion started by: Pioneer1976
3 Replies

5. Shell Programming and Scripting

Extract numbers from text file work out average

Just wondering if someone could assist me with shell script I'm trying to write. I need to read the final column of a text file (shown below) and workout what the average number is. The text file will have a variable number of lines, I just want the script to pull out the values in the final field... (14 Replies)
Discussion started by: rich@ardz
14 Replies

6. Shell Programming and Scripting

Use grep sed or awk to extract string from log file and put into CSV

I'd like to copy strings from a log file and put them into a CSV. The strings could be on different line numbers, depending on size of log. Example Log File: File = foo.bat Date = 11/11/11 User = Foo Bar Size = 1024 ... CSV should look like: "foo.bat","11/11/11","Foo Bar","1024" (7 Replies)
Discussion started by: chipperuga
7 Replies

7. Shell Programming and Scripting

sed - extract text from xml file

hi, please help, i have an xml file, e.g: ... <tag> test text asdas="${abc}" xvxvbs:asdas${222}sdad asasa="${aa_bb_22}" </tag> ... i want to extract all "${...}", e.g: ${abc} ${222} ${aa_bb_22} thank you. (2 Replies)
Discussion started by: gioni
2 Replies

8. Shell Programming and Scripting

Need to extract only decimal numbers for a glob of text

If you have a look at this thread, you'll see that users have been posting the output a script which are numbers that range from 2 to 5 decimal places. If I dump this entire thread to txt file, how can I: 1) Delete everything except for numbers of the following formats (where 'x' is a digit and... (5 Replies)
Discussion started by: graysky
5 Replies

9. UNIX for Dummies Questions & Answers

sed - extract a group of Letters/numbers

I have a file with hundreds of lines in it. I wanted to extract anything that matches the following: KR followed by 4 digits: example KR1201 cat list | sed "s///g" Is the closest I've come, and obviously it is not what I want. This would remove all of the items that I want and leave me... (2 Replies)
Discussion started by: newbie2010
2 Replies

10. Shell Programming and Scripting

Script extract text from txt file with grep

All, I require a script that grabs some text from the gitHub API and will grep (or other function) for a string a characters that starts with (") quotes followed by two letters, may contain a pipe |, and ending with ) . What i have so far is below but it's not returning anything. ... (4 Replies)
Discussion started by: ChocoTaco
4 Replies
Config::Record(3pm)					User Contributed Perl Documentation				       Config::Record(3pm)

NAME
Config::Record - Configuration file access SYNOPSIS
use Config::Record; # Create an empty record & then load from file my $config = Config::Record->new(); $config->load("/etc/myapp.cfg"); # Create & load, then save to filename my $config = Config::Record->new(file => "/etc/myapp.cfg"); $config->save("/etc/myapp.cfg"); # Load / save from filehandle my $fh = IO::File->new("/etc/myapp.cfg"); my $config = Config::Record->new(file => $fh); $config->save($fh); # Get a config value, throw error if not found my $value = $config->get("foo"); # Get a config value, return 'eek' if not found my $value = $config->get("foo", "eek"); # Set a value $config->set("foobar", "wizz"); # Get a deep config value (ie nested hash) my $value = $config->get("foo/bar", "eek"); # Get first element of an array param my $value = $config->get("people/[0]/forename"); # Get the raw hash reference forming the record my $record = $config->record(); # Get a new config object rooted at a sub-hash my $config = $config->view("foo"); DESCRIPTION
This module provides an API for loading and saving of simple configuration file records. Entries in the configuration file are essentially key,value pairs, with the key and values separated by a single equals symbol. The "key" consists only of alphanumeric characters. There are three types of values, scalar values can contain anything except newlines. Trailing whitespace will be trimmed unless the value is surrounded in double quotes. eg foo = Wizz foo = "Wizz.... " Long lines can be split with a backslash character, without introducing newlines. Without double quotes, whitespace at beginning and end of lines will be trimmed eg foo = This is a long line of text foo = "This is a long " "line of text" Multi-line strings can be provided as 'HERE' documents, eg foo = <<EOF This is a multiple paragraph block of text with newlines preserved EOF Array values consist of a single right round bracket, following by one "value" per line, terminated by a single left round bracket. eg foo = ( Wizz "Wizz... " ) Hash values consist of a single right curly bracket, followed by one key,value pair per line, terminated by a single left curly bracket. eg foo = { one = Wizz two = "Wizz.... " } Arrays and hashes can be nested to arbitrary depth. EXAMPLE
name = Foo title = "Wizz bang wallop" eek = ( OOhh Aahhh Wizz ) people = ( { forename = John surnamne = Doe } { forename = Some surname = One } ) wizz = { foo = "Elk" ooh = "fds" } EXTRA PARSER FEATURES
The syntax described thus far is classed as the base feature set. By passing the "features" parameter when creating an instance of the "Config::Record" class, it is possible to turn on certain extra features QUOTED NON-ALPHANUMERIC KEYS The keys for configuration parameters are normally restricted to only contain the characters 'a-Z', '0-9', '_', '-' and '.'. Sometimes it is desirable to allow arbitrary characters for keys. If this capability is required then the "quotedkeys" parameter can be set. EXAMPLE name = Foo title = "Wizz bang wallop" " some parameter " = ( foo bar } "an embeded " quote" = bar "an embeded \ backslash" = wizz EXTERNAL INCLUDE FILES With large configuration files it can be desirable to split them into a number of smaller files. If this capability is required, then the "includes" feature can be requested. Each included file must follow the syntax rules already described. EXAMPLE In the main file name = Foo title = "Wizz bang wallop" foo = @include(somefile.cfg) And in somefile.cfg firstname = Joe lastname = Blogs Is equivalent to name = Foo title = "Wizz bang wallop" foo = { firstname = Joe lastname = Blogs } METHODS
my $config = Config::Record->new([file => $file], [features => \%features]); Creates a new config object, loading parameters from the file specified by the "file" parameter. The "file" parameter can either be a string representing a fully qualified filename, or a IO::Handle object. If the "file" parameter is a string, this filename will be saved and future calls to "load" or "save" are permitted to omit the filename. If the "file" parameter is not supplied then an empty configuration record is created. The "features" parameter allows extra parser features to be enabled. The two valid keys for the associated hash as "includes" and "quotedkeys" as described earlier in this document. $config->load([$file]); Loads and parses a configuration record. The "file" parameter can either be a string representing a fully qualified filename, or an IO::Handle object. The $file parameter may be omitted, if a filename was specified in the constructor, or in previous calls to "load" or "save". Prior to loading the record, the current contents of this configuration are cleared. $config->save([$file]); Saves the configuration record to a file. The "file" parameter can either be a string representing a fully qualified filename, or an IO::Handle object opened for writing. The $file parameter may be omitted, if a filename was specified in the constructor, or in previous calls to "load" or "save". my $value = $config->get($key[, $default]); Gets the value of a configuration parameter corresponding to the name "key". If there is no value in the record, then the optional "default" is returned. $config->set($key, $value); Sets the value of a configuration parameter corresponding to the name "key". $config->view($key) Return a new Config::Record object, rooted at the specified key. If the key doesn't resolve to a hash reference an error will be raised. my $record = $config->record(); Retrieves a hash reference for the entire configuration record. Currently this is the actual internal storage record, so changes will modify the configuration. In the next release this will be changed to be a deep clone of the internal storage record. BUGS
Config::Record has the following limitations o If you load and then save a configuration file all comments are removed & whitespace normalized. o Ordering of elements in hash ref are not preserved across load and save sequence These limitations may be fixed in a future release if there is demand from users... AUTHORS
Daniel Berrange <dan@berrange.com> COPYRIGHT
Copyright (C) 2000-2007 Daniel P. Berrange <dan@berrange.com> SEE ALSO
perl(1) perl v5.12.4 2011-10-12 Config::Record(3pm)
All times are GMT -4. The time now is 03:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy