How do I extract portions from a string in Crystal Reports 8? 1

[tsamara]

I need to extract all alpha characters from a string that would look like this:
*MLI**NEF*,*MLR*,*MET*
End result should be: MLINEFMLRMET
Can someone please help me?
Thanks

 

[goodprg]

you would have to create two formula's to achieve this -

formula A - Replace ('*MLI**NEF*,*MLR*,*MET*','*','')
the result would be MLINEF,MLR,MET

formula B - Replace ({@formula A},',',''
the result will give you MLINEFMLRMET

Hope this helps

 

[synapsevampire]

Or in one formula:

Replace(Replace ('*MLI**NEF*,*MLR*,*MET*','*',''),',','')

-k