Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello -
I have a field called [Act Name} which appears as Home Team VS. Other Team
I want to only show VS. Other Team. Home Team is always the same number of characters, what is the best way to do this?
Thank you.
May be this:
'VS. ' & SubField([Act Name], 'VS.', 2) as FieldName
Mid([Act Name],11) as [Act Name]
regards
Marco