Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Extract String

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Extract String
# 1  
Old 09-25-2006
Extract String
I wanted to extract -151557 and 6768743 from the below line. Don't know how can i do using regular expression.

These are mX and mY coordinates for a particular geographic location.
So any coordinate like number after string 'mX' will be mX
any coordinate like number after string 'mY' will be mY

which i want to extract




Code:
<div align="center"><center><table border="1" cellspacing="1" width="70%"><tr> <td width="50%" align="center" valign="middle"><strong>OS X</strong> </td> <td width="50%" align="center" valign="middle">443921 </td></tr><tr> <td width="50%" align="center" valign="middle"><strong>OS Y</strong> </td> <td width="50%" align="center" valign="middle">235124 </td></tr><tr> <td width="50%" align="center" valign="middle"><strong>Post Code</strong>
 </td> <td width="50%" align="center" valign="middle">OX15 4HE </td></tr><tr> <td width="50%" align="center" valign="middle"><strong>Lat</strong> (WGS84)  </td> <td width="50%" align="center" valign="middle">N52:00:46 ( 52.012814 ) </td></tr><tr> <td width="50%" align="center" valign="middle"><strong>Long</strong> (WGS84)  </td> <td width="50%" align="center" valign="middle">W1:21:41 ( -1.361467 ) </td></tr><tr> <td width="50%" align="center" valign="middle"><strong>LR</strong> </td>
 <td width="50%" align="center" valign="middle">SP439351 </td></tr><tr> <td width="50%" align="center" valign="middle"><strong>mX</strong> </td> <td width="50%" align="center" valign="middle">-151557</td></tr><tr> <td width="50%" align="center" valign="middle"><strong>mY</strong> </td> <td width="50%" align="center" valign="middle">6768743 </td></tr><tr> <td width="50%" align="center" valign="middle">
<strong>M</strong> </td> <td width="50%" align="center" valign="middle">Actual : FFFDAFFB_00674867<br>Street : FFFDB034_00674774<br>Road   : FFFDB610_00672640<br>Road64 : FFFE0C00_00668A00<br>Road128: FFFE0C00_00659000</td>
</tr><tr> <td width="100%" align="center" valign="middle" colspan="2" ><strong><a href="http://www.streetmap.co.uk/streetmap.dll?grid2map?X=443921&Y=235124&arrow=Y&adkey="~"">Click here to see location</a> </strong>



Any suggestion pls
Last edited by vino; 09-25-2006 at 12:17 PM.. Reason: Added code tags
# 2  
Old 09-25-2006
Try this:
Code:
$ sed 's/\<[^<]*\>//g;s/.*mX *\([-0-9]*\).*$/\1/' < string
-151557
$ sed 's/\<[^<]*\>//g;s/.*mY *\([-0-9]*\).*$/\1/' < string
6768743
$

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to extract every repeated string between two specific string?

Hello guys, I have problem with hpux shell script. I have one big text file that contains like SOH bla bla bla bla bla bla ETX SOH bla bla bla ETX SOH bla bla bla ETX What I need to do is save first SOH*BLA into file1.txt, save second SOH*BLA into file2.txt and so on.... (17 Replies)
Discussion started by: sembii
17 Replies

2. Shell Programming and Scripting

To Search for a string and to extract the string from the text

Hi Team I have an huge xml where i need to search for a ceratin numbers. For example 2014-05-06 15:15:41,498 INFO WebContainer : 10 CommonServicesLogs - CleansingTriggerService.invokeCleansingService Entered PUBSUB NOTIFY MESSAGE () - <?xml version="1.0" encoding="UTF-8"... (5 Replies)
Discussion started by: Kannannair
5 Replies

3. Shell Programming and Scripting

Search String and extract few lines under the searched string

Need Assistance in shell programming... I have a huge file which has multiple stations and i wanted to search particular station and extract few lines from it and the rest is not needed Bold letters are the stations . The whole file has multiple stations . Below example i wanted to search... (4 Replies)
Discussion started by: ajayram_arya
4 Replies

4. Shell Programming and Scripting

Extract a string from another string in UNIX

I have a string string="Please have a nice day and sleep well Replace_12123_31233_32134_12342 Good day" How do i replace "Replace_12123_31233_32134_1234" in the above string.?? Please help. Regards, Qwerty (3 Replies)
Discussion started by: qwertyu
3 Replies

5. Shell Programming and Scripting

Extract a string between 2 ref string from a file

Hi, May i ask if someone share some command for extracting a string between 2 ref string in a txt file My objective: i had a file with multiple lines and wants only to extract the string "watch?v=IbkAXOmEHpY" or "watch?v=<11 random character>", when i used "grep 'watch?=*' i got a results per... (4 Replies)
Discussion started by: jao_madn
4 Replies

6. Shell Programming and Scripting

to extract string from main string and string comparison

continuing from my previous post, whose link is given below as a reference https://www.unix.com/shell-programming-scripting/171076-shell-scripting.html#post302573569 consider there is create table commands in a file for eg: CREATE TABLE `Blahblahblah` ( `id` int(11) NOT NULL... (2 Replies)
Discussion started by: vivek d r
2 Replies

7. Shell Programming and Scripting

extract a string within a string using a pattern

hi all, i have a file name using the following pattern: PREFIX: AR SOURCE: LEGACY DATETIME: YYYYMMDD_HH24MISS SUFFIX: .txt sample filename: AR_LEGACY_20101104_105500.txt i want to extract the source which is LEGACY in this case. how do i do this using shell? thanks. (4 Replies)
Discussion started by: adshocker
4 Replies

8. Shell Programming and Scripting

Search for string in a file and extract another string to a variable

Hi, guys. I have one question: I need to search for a string in a file, and then extract another string from the file and assign it to a variable. For example: the contents of the file (group) is below: ... ftp:x:23: mail:x:34 ... testing:x:2001 sales:x:2002 development:x:2003 ...... (6 Replies)
Discussion started by: daikeyang
6 Replies

9. Shell Programming and Scripting

extract a sub string from a main string

i need a shell program to extract a substring from a main string.. for eg:- main string is madhu.. sub string is mad o/p:- be mad. try to solve this one (5 Replies)
Discussion started by: madhu.it
5 Replies

10. UNIX for Dummies Questions & Answers

How to extract a portion of a string from the whole string

How to extract a portion of a string from a full string using unix. For example: Say source string is = "req92374923.log" I want only the numeric portion of the string say "92374923" how to do that in Unix. (2 Replies)
Discussion started by: ds_sastry
2 Replies
Login or Register to Ask a Question