Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
500 names in one field
Sorry sir its not working
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)
];
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
How about:
TextBetween(YourField, 'RISK;', ';')
-Rob
Thank you very much Vamsee its working