Break the Address in 3 Parts with Complete Words


Hi All, I am trying to Split a address in Address1 Addresss 2 and Address 3 , and maximum length of a part is 25 characters, is there any shortcut for this.
I have tried splitting by breaking all address in parts and then add them one by and check the length.
For first time address is working fine but always in second address it is breaking the loop.


Can you post a sample address ? If it is a fixed width you can use substring, if comma separated u can use split, what is stopping you from using them ?