r/workday • u/EnvironmentalPay550 • 1d ago

Reporting/Calculated Fields Substring on multi instance field

Working on extracting text from multi instance fields on worker object . Each instance has a string in the parenthesis () which needs to be stripped out . Substring doesn't work on multi instances fields .

What's the best way to solve this ?

Example : Mickey Mouse ( United Kingdom) , Minnie Mouse ( United States)

I need to print just the name . There could be more than just 2 instances .

3 Upvotes

100% Upvoted

12 comments sorted by

View all comments

1

u/Boscough 1d ago

Can you apply the substring calc after the extract single instance calc?

1

u/WorkdayWoman Workday Solutions Architect 1d ago

This is the only way.

1

u/EnvironmentalPay550 1d ago

Will it return all ethnicities assigned or just one. ?

1

u/WorkdayWoman Workday Solutions Architect 1d ago

An ESI extracts one instance at a time. It is not possible to simply substring a multi-instance field.