Replace delimiter from field value

Question

How to replace delimiter from order id in tableau? Is there any direct function to do that?

Answer 1

Hi Sindhu,

You can use split function and then join them by using + similar to concatenate.

Follow below steps:

1. Create a calculated field to split the sub-string between delimiters with split function.

SPLIT([Order ID],'-',1)

2. Then use + to join with required delimiter.

The order-id after replacing delimiter is shown below.

Hope this helps you.