I have a long text field in a database which I need to split after 40 charaters at the next space.
This is a long text field
this is a long
this is a long te
anyone any ideas??
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.
There are quite a few string functions like
Format (with Strings)
Concat with & Left Right Trim
Use them to split the string of your field.
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