Help Splitting text fields
 

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??

:confused: Thanks

Re: Help Splitting text fields
 

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

Re: Help Splitting text fields
 

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

Re: Help Splitting text fields
 

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.

Re: Help Splitting text fields
 

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