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 -.
stu-art should be art
s-tuart should be tuart
What type of expression can I use to get around this?
Subfield(YourFieldName,'-',2) as YourFieldName
Subfield(YourFieldName,'-',-1) as YourFieldName
Sorry i should have said that the field could be any lenght.
For example we could have
That should work.
Subfield(FieldName,'-',2) as NewFieldName
Retrieving data ...