String replace

Question

Hi

I am trying to replace a string which contains [dbo].[Office_name]

I am using the calculated field

Replace "[dbo].[Office_name]" , "[dbo].", " " ]. By doing this I'am able to get rid of the [dbo]. The output I'm getting is [Office_name] . Is there a way to get only Office_name without the brackets?

I tried to first split the string name at the data source level. But I'm not able to do so somehow. It's not showing as one of the options.

Any help would be appreciated.

Thanks

Tableau Community Forums Member (Inactive) · Accepted Answer

You can use REPLACE() twice to get the desired result:

REPLACE(REPLACE([String name], "[dbo].[", " "), "]" , "")

The open bracket is also included along with dbo [ and then take off the outer bracket with the outer REPLACE!

Tableau Community Forums Member (Inactive) · Answer

I have another question. Since I can't use REPLACE with non-aggregate functions i am using REPLACE(REPLACE(ATTR([String name]), "[dbo].[", " "), "]" , "" to make the calculation work. I am basically trying to match the string name with the "String Names" that I have from a different source. So I am looking to do a kind of blend on the String names from two different sources so that I can do a match up and see what string names are being used from the same data source.   Any idea on this?   Thanks

String replace

Tableau Desktop & Web Authoring

Related Learning

More Help