Archives of the TeradataForum
Message Posted: Thu, 12 Apr 2012 @ 09:57:58 GMT
I have following scenario.
Col1 contains values such as
Col1 ------- ABC-123-VAL1 XAYZ-12-VAL2 SK-1234-VAL3
Now I want the data as following:
Col1 Col2 Col3 Col4 ABC-123-VAL1 ABC 123 VAL1 XAYZ-12-VAL2 XAYZ 12 VAL2 SK-1234-VAL3 SK 1234 VAL3
Basically I want to extract values from one column based on the positioning of hyphen and put that data in separate columns. Does Teradata have any standard function to achieve this?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|