[ic] Cleaning carriage returns etc.
Thu, 12 Apr 2001 16:51:36 -0700
> > Hi list,
> > I bumped in problems with a field that I clean from tabs, carriage returns
> > etc. The formatting afterwards is not really what I want when I
> > display the
> > value somewhere...
> > Can someone help me with some tips in what way <textarea> fields should be
> > collected and stored (eg. tab replaced with 3 spaces etc.), in
> > other words:
> > what is safe to store in a tab-delimited file and what is not, and how
> > should these characters be replaced/removed.
The only TWO things a Tab-delimited file can't have stored as a record is a
tab and a return (newline). :-) Specifically, a tab indicates a new field,
and a newline indicates the end of the row.
These can be easily removed with a little Perl regexp such as s/\t// or
s/\n// , but I'm dangerous with Perl regexps, we'll let someone else post
better code, or you can do some studying on your own. Interchange may have
filters that handle this automatically... Check the docs.
I don't believe it is possible for a browser to enter a tab into any form
field... but that isn't a good reason not to trap it. :-)
>I forgot to ask also that how should I handle the displaying for this value
>in eg. a table cell after it is pulled out from the database...
If you want to "Reconstruct" the formatting after storing it in a
tab-delimited file, perhaps the regexp should replace the newlines with a
difficult-to-guess word or string that can be undone later. That is,
replace the newline with "!!!newline!!!" or such, so that you can later
replace that with the \n return.
Don't forget that in HTML, returns are ignored. So either display the
results within <PRE> or (as previous) replace the newlines with <BR>
Ryan Hertz tel 800-645-BAIT
Webmaster fax 520-645-2588
Advertising Director http://www.baits.com
Gary Yamamoto Custom Baits, Inc. mailto:firstname.lastname@example.org