substring - Teradata Substring fetch

Question

I have data in a column which goes like this:
Phone:Yes,Mail:No,Email:Yes,SMS/MMS:No
I also have columns named Phone, Mail, Email, SMS/MMS

How can i extract the field values(Yes/No) and load the appropriate columns however order they appear ? (As an eg : Mail:No,Email:Yes,Phone:Yes,SMS/MMS:No)

Thanks in advance!

标签： substringteradata

Answer 1

有一个从 Name-Value-Pairs 中提取值的函数：

NVP(col, 'Mail', ',', ':')

NVP(col, 'Mail', -- name
                 ',', -- name delimiter
                      ':') -- value delimiter