Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Help Splitting text fields (http://www.go4expert.com/forums/help-splitting-text-fields-t1775/)

Hellojames 1Nov2006 14:46

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

shabbir 1Nov2006 14:54

Re: Help Splitting text fields
 
Refer Split text field. I am sure it will be of help to you.

Hellojames 1Nov2006 15:01

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

shabbir 2Nov2006 10:40

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.

Hellojames 2Nov2006 13:52

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


All times are GMT +5.5. The time now is 21:25.