LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2006, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 3 Jul 2006 13:30:23 -0700
Reply-To:     Amir Behbehani <docwriter@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Amir Behbehani <docwriter@GMAIL.COM>
Subject:      Re: parse character field
Comments: To: toby dunn <>,
In-Reply-To:  <BAY101-F289AE88952D852B2550219DE700@phx.gbl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

> > Hi Toby,

Okay, I have the following code now to parse out the character field. It will parse the following strings very well:

Oracle BPEL Process Manager Win NT 4.0/2000 and Oracle Database Enterprise Edition Win NT 4.0/2000 and Oracle HTML DB 2.0 Java

but it won't parse these strings:

Oracle Database 10g Express Edition Win NT 4.0/2000 or Oracle JDeveloper (Studio) 10.1.3 Java or Struts (doc) Java

Please advise. Here is the code: ** *data* bam._parseme (drop=_: ) ;

set bam.parsed_new ;

retain _re ;

if _n_=*1* then do ;

_re=prxparse('/^([a-z ]+)\s+([\d\.]+)\s(.+)/i') ;

if missing(_re)=*1* then stop;


_match=prxmatch(_re, Description) ; * starting position of match ;

array part[*3*] $*30* Product Version Platform ;

if _match then do _i=*1* to *3* ;

* Extract the contents of each of the three buffers/backreferences ;

part[_i]=prxposn(_re, _i, Description) ;

end ; *

run* ;

Back to: Top of message | Previous page | Main SAS-L page