Help Splitting text fields

Hellojames's Avatar, Join Date: Nov 2006
Newbie Member
Little help?

I have a long text field in a database which I need to split after 40 charaters at the next space.

e.g
from this:
This is a long text field

to this:
this is a long
text field

not this:
this is a long te
xt field

anyone any ideas??

Thanks
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Refer Split text field. I am sure it will be of help to you.
0
Hellojames's Avatar, Join Date: Nov 2006
Newbie Member
Yeah it was. But I have tried modifying the code so that it would not cut off mid word but I couldn't if I take off the -2 it takes the first word out of the text field.

What I need is to find the 9th space in the field and cut from there.

Any idea

Thanks
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
There are quite a few string functions like
Asc
Format (with Strings)
Mid
Str
Chr
LCase
Replace
StrConv
Concat with & Left Right Trim
CurDir
Len
RTrim
UCase
Instr
LTrim
Space

Use them to split the string of your field.
0
Hellojames's Avatar, Join Date: Nov 2006
Newbie Member
Hi Shabbir

You where right the first time. When I looked again then looked at the function of 'instr' I found I could specify how many characters along I wanted to start from then find a space. I had trouble getting the right hand section but fixed that using 'mid'.

Thanks a lot