Hi All,
Could you please me how to implement it using REGEXP_REPLACE , because the same I need to implement in Teradata as replace function not available in teradata, there is oreplace function, but it is not working as expected as the source string is very big string.
with x as (
select '"^*TEST_SEQ=1, "^*TestName=Force & Prox, "^*Start_Ts_Local=1494459286.271805, "^*TestNumber=5, "^*Elapsed_Seconds=0, "^*Result=, "^*CARE_NAME=Phone 2i, "^*SYS_SERIAL_NUM=accd123, "^*TEST_SEQ=1, "^*Model=iPhone 2i, "^*Version=14D27, "^*FixtureID=0, 0123-0122, "^*FixtureRevision=0,Application_01.56,acfghjy_P01.07,2.0.8,abcd-01.00_b92,abcd-01.00_b92,abcd-01.00_b92,01.10.13,01.10.13,01.10.14,"^*EquipmentIdentity.EquipmentModel = A400 MP H4, "^*TestName=Force & Prox, "^*LCM#=acde123ffvd-112svds-C1073272FG2AQ0Y2P044-F71L2BG2S11727G2NAPNAA, "^*Sold2Ship2=, "^*MacOS=10.12.4, "^*Result=, "^*Start_Ts_Local=1494459286.271805, "^*TestNumber=5, "^*NvSN=asdfghjk123456gghhtecbvdfs, "^*ErrorDetail=, "^*ToolName=3D_TouchCal, "^*ToolVersion=2.4.Nirmal.3' as str from dual
)
select str, replace(str,'"^*TestNumber=5, "^*Elapsed_Seconds=0, "^*Result=','') as mod_str
from x;
thanks in advance for your help.
Regards,
Subba