santosh kumar

santosh kumar

  • NA
  • 14
  • 1.1k

split value according to deliminitor

Nov 11 2014 2:52 AM
I have one field as like route the data inside as like(hyd-bang-hyd) i need the result it into two row in first row from is hyd to is bang and 2nd row from is bang and to hyd .the data is not specfic length it may be 4 as like (hyd-pune-mumbai-hyd)this case it should be 3 rows.from hyd to pune in first row and 2nd row from pune to mumbai and 3rd row from mumbai and to hyd 

Answers (2)