String Between Characters

[Laurelin]

I have a string of data such as: DOCUMENT 3212 (9)

All I want to pull out of the string is the 9. The number will always be surrounded by ( )

There used to be a function called StringBetweenCharacters2 in order to do this. How I would I go about pulling the data out of a string such as this in Crystal 11?

 

[Turkbear]

Hi,
Try a combinatioon of InStr and MID functions:

MyStr = Mid({Table.Field},Instr("(")+1,1)



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[swiss2007]

Try
extractstring({your field},"","(")+ "( )

 

[lbass]

extractstring({your field},"(",")")

-LB