1 of 1 people found this helpful
You can create a calculated field and use the REPLACE function in it. REPLACE([Agent Name], "Partners_TP_.", "" )
2 of 2 people found this helpful
You can try this:
you can replace 'Partners_TP_.John_Smith1' with your text field from data source.
Hope this helps you!
Tableau will also build this formula for you. Right click on the [Agent Name] field and choose Transform -> Custom Split. Choose . as your separator and keep the last column. Tableau will create a new field for you, called [Agent Name - Split 1], it's formula will be along the lines of
TRIM( SPLIT( [Agent Name], ".", -1 ) )