parsing out data identifiers

[#1]

Hi, I have a field in one table structured like this (text is variable length-could be longer characters) :

123-text

2134-text

567-text

but I need the result to look like this:

TEXT_123

TEXT_2134

TEXT_567

So, the text is 1. capitalized, and that the 2. separator is an underscore and not a dash and also that the 3. text comes before the number portion. The identifier will always be a dash in the field that needs manipulation.

Thanks for your help,

M

[sunny_talwar]

May be try this

Upper(SubField(FieldName, '-', 2)) & '_' & SubField(FieldName, '-', 1) as FieldName

[sunny_talwar · Accepted solution]

Here is a sample script

Table:

LOAD Upper(SubField(FieldName, '-', 2)) & '_' & SubField(FieldName, '-', 1) as FieldName;

LOAD * Inline [

FieldName

123-text

2134-text

567-text

];