Hi, i have groups of data and If the string is longer than 40 characters, I need the text before and after split into seperate columns but at the last space before the 40 character limit.
For Example:
String:This is the long string that i want splitting into two columns
Result1:This is the long string that i want
Result2:splitting into two columns
If i split at 40 characters i would split a word so want it doing before this occurs.
Thanks for any help.
For Example:
String:This is the long string that i want splitting into two columns
Result1:This is the long string that i want
Result2:splitting into two columns
If i split at 40 characters i would split a word so want it doing before this occurs.
Thanks for any help.