Tableau Regex to get single letter after particular word
Tableau Code used in Calculated Fields:
IF ELSE:
IF CONTAINS([Typel of Traveler], "couple") then "Couple"
ELSEIF CONTAINS([Typel of Traveler], "business") then "Business"
ELSEIF CONTAINS([Typel of Traveler], "solo") then "Solo"
ELSEIF CONTAINS([Typel of Traveler], "family") then "Family"
ELSEIF CONTAINS([Typel of Traveler], "friends") then "Friends"
ELSE "Unknown"
END
Regex:
regexp_extract([Aspect Rating],'Cleanliness-(.)')