Select to view content in your preferred language

Any way to split a string (label or value) on a report?

09-13-2023 08:27 AM
New Contributor II

My select_one menu has a list of plants (scientific name then a hyphen then the common name)

eg. Quercus rubra - Red Oak

I would like to display just the scientific name on the output. Is there a way to split the string into 2 substrings using that hyphen as a marker? I'd like to do something like ${ species | substr(getValue:"",'-')}  kind of function call

 Or some other idea that accomplishes the same?


0 Kudos
1 Reply
New Contributor II

Did you find a solution to this? I have a field that looks like "Business Name" - "ID" - "Address" that I would like to separate into different fields. The original field is coming from Workforce and then into Survey123.

0 Kudos