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 10, 2018 in Tableau by ghost
• 1,790 points
947 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 10, 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
1,369 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 12, 2018 in Tableau by xyz
• 1,560 points
7,019 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 21, 2018 in Tableau by ffdfd
• 5,550 points
6,822 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 18, 2018 in Tableau by ffdfd
• 5,550 points
669 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
9,891 views
+2 votes
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
1,594 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 6, 2018 in Tableau by Atul
• 10,240 points
5,648 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 9, 2018 in Tableau by Atul
• 10,240 points
8,519 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP