You can make use of regex to match the pattern and get the desired result
You can modify the patterns as per your requirement.
Kindly go through the below links for some knowledge about regular expression.
Please refer the attached workbook
Hope this helps!
mySmallExample_v10.2.twbx 14.2 KB
Hi Naveen B ,
Thanks for the tip
Nice catch, I noticed it too, I was just trying to put a general idea to the solution.
But your sophisticated reply made my doubts clear as well (I started to explore about Regex recently)
1 of 1 people found this helpful
Check this blogspot i have recently explore the regex and covered all the options and written blogspot about it
Hope this will helps
I'm new to Tableau but experienced in Excel.
I would have used
Keen to explore the REGEX suggestions though
Thanks this is a great solution. But what can I do if this string contains comma instead of point for decimals like in some regions of the world?
E.g instead of 1.5% this string has 1,5% . Or another example -> 15 days after invoice, 2,2% cashback
If I try to replace (\.) to (\,) this method doesn't work (see my example workbook).
Thanks in advance.
mySmallExample_16042019.twbx 14.9 KB