Findoneof function and wildcards

[#1]

Hi

I have a field which has a naming convention of Name - Year - Type

I want to just get the type from this so I use the expression:

=Right([FieldName],len([FieldName])-FindOneOf([FieldName], '-',2)-1)

The problem is I have found some names contain '-' which means it pulls part of the name as well.

How can I use the findoneof function with wilcards to find 'YYYY -'

Thanks in advance for your help.

Jon

[#2]

does Type contain '-' to?

[#3]

No.

[#4]

this expression should do what you want:

subfield(FieldName,'-',SubStringCount(FieldName,'-'))

[#5 · Accepted solution]

sory i mean :

subfield(FieldName,'-',SubStringCount(FieldName,'-')+1)

[#6]

Perfect! Thank you.