Dear All,
Oracle Database 11g R2 11.2.0.1 SE1
Consider the below string
Madhu, No 34 Church street, main road, TMK
I need to split the string based on the below conditions.
Condition 1: Split string 35 characters each
Condition 2: search until previous comma and display upto comma.
Condition 3: split for next 35 characters.
Required output for above string
Addr1 | Addr2 |
---|
Madhu, No 34 Church street | main road, TMK |
Comment:
Condition 1: Addr1 --> 35 char = Madhu, No 34 Church street, main ro
Condition 2: Addr1 --> search previous comma-->so output--> Madhu, No 34 Church street
Condition 3: Addr2 --> Search for next 35 characters (i.e from 'main road') --> Condition 1 --> Condition 2
Kindly help with this regard.