SQL String question

Last Post 09 Oct 2008 05:15 PM by gidsy. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
gidsy
New Member
New Member

--
09 Oct 2008 05:15 PM
Hi,

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:

123209012345691001
2.00
0.90
2.90
12
09/10/2008

Thanks in advance
You are not authorized to post a reply.

Acceptable Use Policy