golden nugget online

MANISH RFS

MANISH RFS

  • 2.1k
  • 3
  • 90

Split String Data

May 3 2022 1:00 PM

I Have String Wise Data In table

 

My Out put Look Like

i have write Query 

SELECT 
   REVERSE(PARSENAME(REPLACE(REVERSE(Data1), '|', ','), 1)) AS BatchQty
   , REVERSE(PARSENAME(REPLACE(REVERSE(Data1), '|', ','), 2)) AS Qty
  ,Data1
FROM RFS21_HeatChargeSplitRec

But Output Column (BatchQty,Qty)Return Null 

Thank In Advance


Answers (1)