Help with a string fields

[skreczko]

Hello Crystal Report Gods,

I just need to get the member number separated from this string. Does anyone know how to get the 3’s from this sample data. Also, I need to convert it to a number format.

thanks

MEMBER_NBR=3333333|LOAN_NBR=168
MEMBER_NBR=33333|LOAN_NBR=169
MEMBER_NBR=3333|LOAN_NBR=169
MEMBER_NBR=333|LOAN_NBR=169
MEMBER_NBR=33|LOAN_NBR=169
MEMBER_NBR=3|LOAN_NBR=169

 

[fisheromacse]

i think this will do what you ask:

//{@extract}
extractstring({YourTable.YourField},"=","|")




+100 stars to lbass for all she give to this community!
(including this formula)

 

[skreczko]

It worked thanks