split field 1

[hlmnsbuggy]

CR11, oracle

I have a field shown as below

Annual Premium = $1,093.00<BR>(Quote Number: QUHO328025)<BR>(Company: ABC company)

How can I split this field into just QUHO328022 only

Thanks

ANN

 

[IdoMillet]

Split(Split({annual_premium}, "<BR>")[2],": ")[2]

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Try this, if the value is always preceded by "Quote Number: " (with a space at the end):

extractstring({table.field},"Quote Number: ", ")")

-LB

 

[hlmnsbuggy]

Thanks for your help!!! Your guys are great!

Ann