Hey guys,
I would like to transform the access user in Celonis (user.celonis@outlook.com) into just the name. Example: User Celonis
I looked in the PQL documentation but I couldn't find it.I looked in the PQL documentation but I couldn't find it.
Question
KPI-CARD
+4I don't think there is a direct method or function to do this, however you can try the following
STRING_SPLIT ( 'celonis.user@gmail.com', '.', 0) || ' ' ||
STRING_SPLIT(STRING_SPLIT ( 'celonis.user@gmail.com', '.', 1),'@',0)
I don't think there is a direct method or function to do this, however you can try the following
STRING_SPLIT ( 'celonis.user@gmail.com', '.', 0) || ' ' ||
STRING_SPLIT(STRING_SPLIT ( 'celonis.user@gmail.com', '.', 1),'@',0)
Very good, thank you Abhishek. Another question, would it be possible to put the first letter in uppercase?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.