Remove characters before a special character

[#1]

Hi,

So I have a field which has a '-' at different places within the field. In all cases I want to only show the characters that appear after the -.

For example:-

stu-art   should be    art

s-tuart   should be    tuart

What type of expression can I use to get around this?

Thanks

Stuart

[MK_QSL · Accepted solution]

Subfield(YourFieldName,'-',2) as YourFieldName

or

Subfield(YourFieldName,'-',-1) as YourFieldName

[ashfaq_haseeb]

Hi

try below

subfiled(field,'-',2)

Regards

ASHFAQ

[#4]

Hi,

Sorry i should have said that the field could be any lenght.

For example we could have

ffffffffffffffffffffffffff-f

or

ggggggggggggggggggggggggggggggggggggggggg-aa

[ashfaq_haseeb]

That should work.

Regards

ASHFAQ

[ecolomer]

Use SubField:

Subfield(FieldName,'-',2) as NewFieldName