And by the way, in case the Key is part of string with different characters around, but on a fixed position in the string, the column can be copied and in the copied column the key can be set standalone using EXTRACT transformation.
If it isn‘t a fixed position it can be checked if with SPLIT COL the key can be extracted and used.
1 Like