Korn Shell for pattern matching and extracting


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Korn Shell for pattern matching and extracting
# 1  
Old 01-11-2011
Korn Shell for pattern matching and extracting

Guys, i'm new to shell scripting. Here's what i need.
I need a shell script which would read a file containing only 1 line which never changes.
File containts -
SQL_Mgd_Svc_ELONMCL54496 |EMEA\brookkev, EMEA\fieldgra, EMEA\tidmamar, EMEA\attfiste, EMEA\baldogar, EMEA\clarkia2, EMEA\conwasha, EMEA\ferguste, EMEA\ja&

Now, i need the script to print the words between EMEA\ and , (comma)
e.g. o/p should be as below -

brookkev
fieldgra
tidmamar
attfiste
:
:
ja&
# 2  
Old 01-11-2011
Code:
sed 's/[^EMEA\\]*EMEA\\\([^,]*\)[,]*/\1\
/g' inputFile

# 3  
Old 01-11-2011
Hi Anurag,
thnx for ur prompt response...meanwhile i found one more sed command as below -
cat testFile|cut -d'\' -f2- | sed 's/EMEA//g;s/\\//g;s/,//g'

which works fine too but trouble is i dont knw how to add this sed command in a shell script?

Below is my shell script

#!/usr/bin/ksh
FILE="$1";
`cat $FILE| cut -d'\' -f2- | sed 's/EMEA//g;s/\\//g;s/,//g'`

The o/p error i get is -
sed: -e expression #1, char 37: unterminated `s' command
# 4  
Old 01-11-2011
Code:
#!/usr/bin/ksh
FILE="$1"
cat $FILE| cut -d'\' -f2- | sed 's/EMEA//g;s/\\//g;s/,//g'

This User Gave Thanks to anurag.singh For This Post:
# 5  
Old 01-11-2011
Are you putting this into a variable? like:

Code:
a=`cat $1 |cut -d'\' -f2- | sed 's/EMEA//g;s/\\//g;s/,//g'`


If so, try this:

Code:
cat $1|cut -d'\' -f2- | sed 's/EMEA//g;s/\\//g;s/,//g' | read a


Quote:
> echo $a
brookkev fieldgra tidmamar attfiste baldogar clarkia2 conwasha ferguste ja&
# 6  
Old 01-11-2011
Quote:
Originally Posted by freakygs
Are you putting this into a variable? like:

Code:
a=`cat $1 |cut -d'\' -f2- | sed 's/EMEA//g;s/\\//g;s/,//g'`


If so, try this:

Code:
cat $1|cut -d'\' -f2- | sed 's/EMEA//g;s/\\//g;s/,//g' | read a


Thanks freakygs Smilie
I got it...much appreciated. Smilie

---------- Post updated at 06:23 AM ---------- Previous update was at 06:22 AM ----------

Quote:
Originally Posted by anurag.singh
Code:
#!/usr/bin/ksh
FILE="$1"
cat $FILE| cut -d'\' -f2- | sed 's/EMEA//g;s/\\//g;s/,//g'




Thanks Anurag....it worked Smilie
Plz suggest me good awk, sed, ksh scripting tutorials..it would help me learning these things. thanks again.
# 7  
Old 01-11-2011
Code:
sed 's/[^|]*|//;s/EMEA\\\([^,]*\)[, ]*/\1\n/g' infile

Code:
awk -F',* *EMEA\\\\' '{sub(/^[^|]+\|/,x);$1=$1}1' OFS="\n" infile


Last edited by Scrutinizer; 01-11-2011 at 11:17 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Extracting sub-string matching the pattern.

Hi, I have a string looks like the following: USERS 32767.9844 UNDOTBS1 32767.9844 SYSAUX 32767.9844 SYSTEM 32767.9844 EMS 8192 EMS 8192 EMS_INDEXES 4096 EMS_INDEXES 4096 8 rows selected. How do I extract a sub-string to get the expected output as following: EMS 8192 EMS_INDEXES 4096 ... (3 Replies)
Discussion started by: NetBear
3 Replies

2. Shell Programming and Scripting

Pattern Matching and extracting the required fields in Perl

Hi All, I am writing the following Perl Scrip and need your help in Pattern matching : I have the following Shell Script that would read line by line from the file (file_svn) and would inturn calls the Perl Script: #!/bin/bash perl_path="/home/dev/filter"... (2 Replies)
Discussion started by: filter
2 Replies

3. Shell Programming and Scripting

Korn Shell regular pattern

Hello, I can't seem to understand korn shell regular expression. I am trying to extract the tagfrom its own filename string. var="LNX_1.2.0.0.af329a3da.tar" whereby af329a3da is the tagI am trying to extract out from. I am trying to avoid using IFS because future modifications... (5 Replies)
Discussion started by: howhan
5 Replies

4. Shell Programming and Scripting

Extracting a string matching a pattern from a line

Hi All, I am pretty new to pattern matching and extraction using shell scripting. Could anyone please help me in extracting the word matching a pattern from a line in bash. Input Sample (can vary between any of the 3 samples below): 1) Adaptec SCSI RAID 5445 2) Adaptec SCSI 5445S RAID 3)... (8 Replies)
Discussion started by: jharish
8 Replies

5. Shell Programming and Scripting

Extracting the strings matching a pattern from a word

Hi All , I need to extract the strings that are matching with the pattern : CUST.<AnyStringOfAnyLength>.<AnyStringOfAnyLength> from a file and then write all these string into another file. e.g. If a file SOURCE contains following lines : IF(CUST.ABCD.EFGH==1) THEN CUST.ABCD.EFGH =... (7 Replies)
Discussion started by: swapnil.nawale
7 Replies

6. Shell Programming and Scripting

help extracting a matching pattern and next lines of match

Hi there, i'm having some problems just making an awk script (i've tried this way, but other way can be posible for sure), for the next file file.txt <register> <createProfile> <result>0</result> <description><!]></description> <msisdn>34661461174</msisdn> <inputOmvID>1</inputOmvID>... (6 Replies)
Discussion started by: vicious
6 Replies

7. Shell Programming and Scripting

Problem extracting just a part of a matching pattern

Hello everyone, this is my first post so please give me a hand. I apologize for my English, I'll try to be clear with my request. I need to write a script (Bash) which finds all the variables defined in the file .h of the folder and then writes the name of the files .c where these variables are... (1 Reply)
Discussion started by: paxilpaz
1 Replies

8. Shell Programming and Scripting

Pattern matching extracting urls from rss, shell scripts

Hi all, how could i do ? I have a Rss file, i want to extract only the Urls (many) matching http://www.xxx.com/trailers/ from that file and copy into another file. like " <pubDate>Wed, 29 Apr 2009 00:00:00 PST</pubDate> <content:encoded><!Apple - Movie Trailers - The Hangover"><img... (3 Replies)
Discussion started by: BremboloIV
3 Replies

9. Shell Programming and Scripting

Pattern manipulation in korn shell script using sed.

Hi, Could any one let me know, how can I cut the last field in below mentioned line. net,-hopcount,0,-netmask,255.255.255.0,,,,,192.168.37.0,10.253.0.1 net,-hopcount,0,-netmask,255.255.255.0,,,,,192.168.1.0,10.253.0.1 net,-hopcount,0,-netmask,255.255.255.0,,,,,192.168.38.0,10.253.0.1... (3 Replies)
Discussion started by: ajilesh
3 Replies

10. UNIX for Dummies Questions & Answers

problem extracting substring in korn shell

hi all, I have read similiar topics in this board, but i didn' t find the posting which is the same with the problem i face.. I try to extract string from the end. i try to do this: num=abcdefghij num2=${num:-5} echo $num2 #this should print the last 5 characters (fghij) but it doesn;t... (3 Replies)
Discussion started by: nashrul
3 Replies
Login or Register to Ask a Question