Extract from string 2

[gromboy]

Hi,
I have field called {RES6} which has a test name and value in it. the format of the field is CA125~56
The number is what I need extracting from the string...so basically the number after the "~". TheCA125~ is always constant
I'm not so hot on these sort of things...
Any help greatly appreciated
Steve

 

[IanWaterman]

This was answered in an earler post, see extracting data from a string.

split({StringField},"~")[2]

Ian

 

[bdreed35]

The only thing I would add to Ian's solution is a test to make sure that the "~" exists so you can avoid a potential error:

if instr({StringField},"~") > 0
then split({StringField},"~")[2]
else ""

~Brian

 

[gromboy]

thankyou both...
I will remember that
Steve

 

[IdoMillet]

Since you say that "The CA125~ is always constant", an alternative approach is

Right({StringField},Len({StringField}) - 6)

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[IdoMillet]

Sorry, instead of Len, use Length.

Right({StringField},Length({StringField}) - 6)

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[gromboy]

ok...
thankyou all for your help

 

[ginkoba]

Please help. new to the forum.

Here is what I am trying to accomplish. I am trying to extract just this part from the below listed data in a descriptive field "08_December". Just the number and the name of the month. Is there a formula or code that I can use to do this and then group by that formula?

"

http://mrbasrv.na.aarp.int:80/PatchManagement/PatchGroups/

 

[IdoMillet]

Pls start a new thread.

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[ginkoba]

Thanks, I did already