Hello,
Tableau has a veru useful "split" function that allows you to split a string with a delimiter and specify the number of the result you want
https://onlinehelp.tableau.com/current/pro/desktop/en-us/functions_functions_string.htm
Qlik has the same function, subfield : https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...
I think this is quite useful and a very standard feature.
Best regards,
Simon