Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I'm struggling finding the right combo of functions to get this right.
I want to trim my object Id field below to only present the actual object Id, so I wish to trim away the string "Document\".
The problem is this field contains a combination of "Document\[Object Id]" and just clean object Ids.
Does anyone have a suggestion on how to do this?
Thank you, worked like a charm, also great explanation!
/M
Good Morning,
If i well understood your problem you probably need to
Right([Object Id],len([Object Id])-9)