Date:         Thu, 3 Feb 2011 16:31:15 -0500
Reply-To:     Ann Mackey <thearchies@LIVE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ann Mackey <thearchies@LIVE.COM>
Subject:      Re: Help with parsing a string
Comments: To: tobydunn@hotmail.com
In-Reply-To:  <BLU152-w46387E873293986A1A26F1DEE70@phx.gbl>
Content-Type: text/plain; charset="iso-8859-1"

Thanks for the fast response - 
 
I'm looking for separate variables out of the text string.  The .CN=, .OU= are consistent, and .CN= is always before .OU= - but the string may or may not contain them (and when it doesn't, there's no data for that field).
 
I'll work with your example and see what I get.  During my many attempts, I didn't use prxmatch, and definately my prxchange statement had some issues (but it was my first try with the PRX* functions.
 

 

> From: tobydunn@hotmail.com
> To: thearchies@live.com; sas-l@listserv.uga.edu
> Subject: RE: Help with parsing a string
> Date: Thu, 3 Feb 2011 21:11:42 +0000
> 
> 
> Ann,
> 
> I would need ot know a whole lote more about the text you are trying to parse such as are the ou- and o= characters consistent or do the characters vary?
> 
> Do you want the parts in multiple variables or just one?
> 
> Given Idon;t know these things this gets what you stated you wanted with the data you sent
> which may or may not be correct for all the possible cases you have in your data:
> 
> Data One ;
> Infile Cards Truncover ;
> Input Text $Char500. ;
> 
> If PrxMatch( '/(?=apple1)/io' , Text ) ;
> Text2 = PrxChange( 's/(.*)cn=(.*)\.ou=(.*)\.o=.*/$1 $2 $3/io' , 1 , Text ) ;
> Put Text2= ;
> 
> Cards ;
> 0001 apple1 00.25.Monkey@address.com.CN=I'll be a monkeys uncle.OU=Mocking Bird City.O=some other data.U=some other data . . .
> 0001 apple6 00679D46CKJL.CN=Help - I need someone.U=flower.O=some other data.U=some other data . . .
> ;
> Run ;
> 
> 
> 
> Toby Dunn
> 
> 
> "I'm a hell bent 100% Texan til I die"
> 
> 
> "Don't touch my Willie, I don't know you that well"
> 
> 
> 
> 
> 
> 
> ----------------------------------------
> > Date: Thu, 3 Feb 2011 15:31:01 -0500
> > From: thearchies@LIVE.COM
> > Subject: Help with parsing a string
> > To: SAS-L@LISTSERV.UGA.EDU
> >
> > I've and have tried many, MANY, things, but I'm just not getting it -
> > Neurons just aren't firing too bright today.
> >
> > Here's a sample of the data - all on one line, the third chunk is over 200
> > characters - notice the many types of delimiters, spaces, ., =, '.CN=',
> > etc., and every variable can be a different length:
> >
> > 1 6 13
> > 0001 apple1 00.25.Monkey@address.com.CN=I'll be a monkeys uncle.OU=Mocking
> > Bird City.O=some other data.U=some other data . . .
> > 0001 apple6 00679D46CKJL.CN=Help - I need someone.U=flower.O=some other
> > data.U=some other data . . .
> >
> > I want to get all 0001 records, keeping the type (apple1), and then parse
> > out the first three sections of the last looong variable length field, in
> > this case it would be:
> >
> > Record Type Serial CN OU
> > 0001 apple1 00.25.Monkey@address.com I'll be a monkeys uncle Mocking
> > Bird City
> > 0001 apple6 00679D46CKJL Help - I need someone flower
> >
> > I've attempted this with scan, prxparse, indexw substr, DLM=, etc.
> >
> > Any direction/help is greatly appreciated, and dare I say... eagerly
> > anticipated!!
> > Thanks,
> > Ann