How to get number from the text string

[NavinReddy]

Hi All,

Below text i want to get only " 8259075 "number. please help me

When combination of RISK i have to display number

A wrongful rescission could lead to greater customer expenses incurred and potentially disputes and litigation; all leading to potential regulatory breach and financial loss to the firm. [RISK;8259075;Foreclosure Sales Rescission

Thanks in Advance,

Niranjan

[Anonymous]

you want only numbers from text, e.g. 8259075?

then use keepchar(yourfield,'012345679')

[neelamsaroha157]

try - PurgeChar(YourFieldName, 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')

[NavinReddy]

When combination of RISK i have to disply number

[NavinReddy]

When combination of RISK i have to display number

[Anonymous]

maybe

if (match(yourfield,'RISK'),keepchar(yourfield,'012345679'))

[NavinReddy]

i got the blank data

[Anonymous]

sorry,

this is correct; needed wildmatch and wildcards

=if (wildmatch('RISK;8259075;Foreclosure Sales Rescission (due to Chase error)','*RISK*')>0, keepchar('[RISK;8259075;Foreclosure Sales Rescission (due to Chase error)]','0123456789'),-1)

instead the string use Name of your field

[NavinReddy]

Sorry,

its actually dynamic data, in the same list i have more than 500 name with same format with different names

[Anonymous]

500 names in one string? then you should think about dividing These huge number of fata in a string

or 500 names in a field?

if in a field use this in a script:

=if (wildmatch(yourfiled'*RISK*')>0, keepchar(yourfiled,'0123456789'),-1)  as yournewfieldnumber