Field limit?
Dave Cragg
dcragg at lacscentre.co.uk
Fri Dec 14 06:12:01 EST 2001
At 6:24 pm -0500 13/12/01, Shari wrote:
>I have a very large text file I wanted to import into a field.
>
>When I use the IMPORT button, the entire file ends up on one line,
>even with the wrapping turned on. And it doesn't import the entire
>file.
Are there any "unfriendly" characters in the file?
How about running a function like this before putting the text into the field:
function cleanUpText pData
repeat with i = 0 to 8
replace numToChar(i) with "" in pData
end repeat
repeat with i = 14 to 31
replace numToChar(i) with "" in pData
end repeat
replace numToChar(11) with "" in pData
replace numToChar(12) with "" in pData
replace numToChar(127) with "" in pData
replace crlf with cr in pData
replace numToChar(13) with cr in pData
return pData
end cleanUpText
Cheers
Dave Cragg
More information about the metacard
mailing list