Creating a New Field From Specific Data in another Field

[#1]

I need to create a new field in my model based on specific data from an existing field, is that possible?

Here is an example below.

I have a field in one of my tables that shows the following detail:

I need to create a new field with the data after the "IV#" so the new field would only have 'CRG1500100' .

Thank you,

Nick

[b_garside]

Try using the SubField() function. the delimiter will determine how it parses the values within

[petter · Accepted solution]

In your load script you could have this:

LOAD

     ....

     ....

     Trim( TextBetween( gltdes , 'IV#' , 'R:') )  AS [IV#],

     .....

     .....

FROM ...... ;

[#4]

Thank you Petter!  That worked!