Xavier, I'm a little unclear about the actual form of your data. What sort of file holds this data? You seem to be saying you have rows of data that contain long strings separated by the piping character. Are these text files? You know you can bring these into Excel as 'other' delimited text files:
If this is an option, it's your easiest route, because now all you have to do is trim the space off the front of the email address in either Excel or Tableau. If this is not an option, you're still better off trying to manipulate these strings in Excel rather than Tableau, because Excel supports the wildcard * (all) character and has robust find/replace functionality. We could probably come up with a way to do this in Tableau, but it would almost certainly be a tortured formula.
Always best to manipulate, shape, reshape your data before you bring it into Tableau, then let Tableau do what it does best -- visualize your data.
1 of 1 people found this helpful
In case this wasn't clear from Shawn's explanation, Tableau can import with the pipe (vertical bar) delimiter, there are some caveats: Spaces between the delimiter can be preserved in both column names and values, so you'd need to manually trim column names by renaming them in the Dimensions & Measures windows in Tableau, and then create calculated fields using the TRIM() function to clean up the necessary dimensions and measures.
Shawn, thanks ever so much, that is why I like posting here, clever cookies like yourself can think out of the box, this worked a treat!!
Thanks Jonathan, was responding to Shawn whilst you replied, his solution was fine so am going to stick with that one, but thanks for the alternative option. Happy new year to you Both!