Input : Pipe Delimited String in one field - Output : To split the string to different fields

Database
Enthusiast

Input : Pipe Delimited String in one field - Output : To split the string to different fields

Hi,

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.

1 REPLY
Junior Contributor

Re: Input : Pipe Delimited String in one field - Output : To split the string to different fields

What's your TD release?

Are there any UDFs like INSTR/STRTOK?

Dieter