betachristopher
Programmer
hello world
i have a SQL table with a memo field containing string lengths from 1 to ~6,000 characters. the client system can only accept strings that are <=75 characters. i have searched some examples of arrays, but most people seem to be splitting by a delimiter or searching for specific information in the memo field.
i just want it to put the first 75 characters in one string, move to the next 75 characters, etc. of course i first started creating multiple variables and changing the starting point like
but i got tired of that really fast. i would like something that allows growth so i don't have to define set1, set2,...set80, etc.
also, since the client system will just display these line for line as i sent them, i would like to avoid splitting them in the middle of a word. so if the 75th character is not a blank space, it should return to the previous blank space making the string <75 characters.
does anyone have any code like this already?
i have a SQL table with a memo field containing string lengths from 1 to ~6,000 characters. the client system can only accept strings that are <=75 characters. i have searched some examples of arrays, but most people seem to be splitting by a delimiter or searching for specific information in the memo field.
i just want it to put the first 75 characters in one string, move to the next 75 characters, etc. of course i first started creating multiple variables and changing the starting point like
Code:
if length({results}) >75 then mid({results},76,75) else ""
also, since the client system will just display these line for line as i sent them, i would like to avoid splitting them in the middle of a word. so if the 75th character is not a blank space, it should return to the previous blank space making the string <75 characters.
does anyone have any code like this already?