Hi, I need your help about an issue I have with a column that comes from the source like this:
I need to split this column in two: one with the quantity and one with the unit of measure, teradta version is 13.1. My last hope was otranslate but is not supported. Other thing I tried is char2hexint and look for the numbers, but there are special characters as well. I have searched many teradata forums and have not found a clue. This has to be developed in data stage ETL.
I would greatly appreciate any help that you can give me in this.
I think you need to write a udf.
In 13.1, (regex) regular expressions may not be there. Just double check by running one small regex function.
I hate writing substr(col, 1,1) , obtaining 1 character after another
or LIKE operator iterativelyand compare with list of strings :) .
If you can install a UDF (talk to your DBA) the eCStrSpn from Ebay will be helpfull:
eCStrSpn(size,'0123456789.') will return the position of the last digit, based on that you can easily split it.