[Hellojames]

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

[shabbir]

Refer Split text field. I am sure it will be of help to you.

[Hellojames]

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

[shabbir]

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.

[Hellojames]

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