Back

Explore Courses Blog Tutorials Interview Questions

Tableau substring

0 votes
2 views
in BI by (17.6k points)

I am not sure how to use the mid function.

This is the account number

10010730000091

and I want to do Substring(Account_Id, 4, 6) in Tableau. Basically, I need the six numbers from the fourth position. 

1 Answer

0 votes
by (22.5k points)
edited by

Use this MID Syntax in tableau:

MID(Account_Id, 4, 6)

Want to become an expert in Tableau? Join now: Tableau certification

Related questions

0 votes
1 answer
Substring in SSRS
asked Feb 3, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
Extract characters from string using SQL
asked Jul 24, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
Returning the string between the 5th and 6th Spaces in a String
asked Jul 19, 2019 in BI by Vaibhav Ameta (17.6k points)
+2 votes
3 answers
Does Python have a string 'contains' substring method?
asked May 21, 2019 in Python by James21 (1.2k points)
0 votes
1 answer
Extract substring in Tableau
asked Dec 1, 2019 in BI by Vaibhav Ameta (17.6k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...