URGNT!!! Need Help to bifercate field in two three fields

[anaghaphadke]

Hello All,

I have a Address field, I want to bifurcate this filed in two three fields because of length problem.

E.g - 1112/3 Raja Ram Apt Udhav Nagar Near Mahadev School Pune 411000 Maharashtra

I have two three fields like

Address 1,Address 2, Address 3

how should I bifurcate this in these address fields

So I use substring but data is not bifurcating as I expected

Data is showing like this

Address 1 - substring(e.address,1,30) - 1112/3 Raja Ram Apt Udhav Naga

Address 2 - substring(e.address,31,30) - r Near Mahadev School Pune 411

Address 3 - substring(e.address,61,30) -000 Maharashtra

Address 4 - substring(e.address,91,30)

Address 5 - substring(e.address,121,30)

Have to show like this

Address 1 - substring(e.address,1,30) - 1112/3 Raja Ram Apt Udhav Nagar

Address 2 - substring(e.address,31,30) - Near Mahadev School Pune 411000

Address 3 - substring(e.address,61,30) - Maharashtra

Address 4 - substring(e.address,91,30)

Address 5 - substring(e.address,121,30)

 

Address should be bifurcate selecting 30 character after space

Please give me solution on urgent basis

Thanks & Regards,

-Anagha

[anaghaphadke]

Please give me solution

Thanks & Regards,

-Anagha