u

• ashokputta9

  SSC Enthusiast

  Points: 172

  More actions

  January 19, 2015 at 10:03 pm

  #296792

  Hi everyone i want split the data this below format..

  1.Split the RR ("PL:TW RR:1.8%,PL:TX RR:0.9%") into LowendRR ("PL:TW RR:1.8%") and HighendRR ("PL:TX RR:0.9%")

  2.Split the LowendRR ("PL:TW RR:1.8%") into LowendPL ("TW"), LowendPLValues ("1.8%")

  3.Split the HighendRR ("PL:TX RR:0.9%") into HighendPL ("TX"), HighendPLValues ("0.9%")

  using charindex,substrings am waiting for reply...