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

[NavinReddy]

500 names in one field

[NavinReddy]

Sorry sir its not working

[nsetty]

If you know (error) number is always in the same fixed number.

TextData:

Load

SubField(DataT, ';', 2) As NewData

    ,DataT;

Load * Inline

[

DataT

RISK;8259075;Foreclosure Sales Rescission (due to Chase error)

];

[vamsee · Accepted solution]

Can you provide a sample of 2 -3 lines of your field and output, as Rudolf's suggestion would work for the example provided.

NUM(IF( WildMatch( YourField, '*RISK*') , keepchar(YourField,'0123456789'), NULL())) as New_Field

[rwunderlich]

How about:

TextBetween(YourField, 'RISK;', ';')

-Rob

[NavinReddy]

Thank you very much Vamsee its working