I have below requirement:-
Source Field - Value
name_field - first_name|middle_name|last_name
Expecting Output:- The source field should be split and it should go to different fields delimited by |
Target Field - Value
f_name - first_name
m_name - middle_name
l_name - last_name
Please advise how can we achieve this.
Thanks a lot in advance.
What's your TD release?
Are there any UDFs like INSTR/STRTOK?