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