How can I remove { } from columns in Tableau?

0 votes

What I have?

One of the column had value within {}, for instance, {00945837}. I just want value 00945837and I don't want { }. Can someone help me out? Thanks in advance.

Aug 9, 2018 in Tableau by ghost
• 1,790 points
60 views

1 answer to this question.

0 votes

Create the following calculated field and use the regexp_replace function.

REGEXP_REPLACE([the field], "[{}]", " ")
answered Aug 9, 2018 by Atul
• 10,240 points

Related Questions In Tableau

0 votes
0 answers

How can I sort date field in presence of another date field in Tableau?

Goal: Sort the new ship date in ...READ MORE

Apr 10, 2018 in Tableau by ghost
• 1,790 points
143 views
0 votes
1 answer

How can I calculate the median of sales price using 3 variables in Tableau

First let me clarify things for you. ...READ MORE

answered Apr 11, 2018 in Tableau by xyz
• 1,550 points
731 views
0 votes
1 answer

How can I add legends to worksheet in Tableau?

Just add the worksheet on the dashboard ...READ MORE

answered Apr 20, 2018 in Tableau by Atul
• 5,530 points
253 views
0 votes
1 answer

How can I calculate current 1 year in Tableau?

A quick solution to this would be ...READ MORE

answered Aug 17, 2018 in Tableau by Atul
• 5,530 points
39 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,028 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
89 views
+2 votes
1 answer
0 votes
1 answer

How can I count the aggregate function in Tableau

Create two calculated fields one for 100's ...READ MORE

answered Apr 5, 2018 in Tableau by Atul
• 10,240 points
1,729 views
0 votes
1 answer

How can I use COUNTD function in Tableau?

First add Col1 to the Columns shelf. Then ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 10,240 points
690 views