Extract string between the first two hyphens

Q&A
,
1

Hi team,
Is there a way to extract the string from the first two hyphens in the column?

For example, I want to extract ‘firstvalue’ and ‘secondvalue’ from the below values.
qq-firstvalue-ww-rr-ii
ww-secondvalue-qq-zz

Any support would be appreciated. Thanks.

2

Hi @cijod - You can use split function and extract the require details.

Documentation Link - Split - Amazon QuickSight

For example - For extracting the first position, I created a calculated field, where the rec is the input string

split({rec},‘-’,1)

See the screenshot below

image
image723×220 8.21 KB

Regards - Sanjeeb

1 Like
3

Thanks Sanjeeb. It worked. :slight_smile:

1 Like