Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
May be try this
Upper(SubField(FieldName, '-', 2)) & '_' & SubField(FieldName, '-', 1) as FieldName
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
];