I would like some help please.
I am trying to separate a text string into several fields of data within a select statement.
The user has a template they enter into our CRM system, they will hopefully enter it correctly but there is potential they could include some errant text or put spaces in etc.
I want this to be intuitive not just substring in the hopes the user will follow the correct format.
I want to extract the numbers only from the following string:
Facility: 123209012345691001Customer Margin: 2.00New TFP Margin: 0.90Total Margin: 2.90Margin Term (mths): 12Effective Date: 09/10/2008
The result being 5 separate fields:
Thanks in advance