Re: Trimming field data
In article: <47an60$4pt@cssun.mathcs.emory.edu> rt10hp@csl.gov.uk
(Richard Thomas) writes:
> There's probably a more flashy way to do this, but if you've got ISQL,
> use an ACE report to unload the data from the table:
>
> output
> report to "datafile"
> top margin 0
> left margin 0
> page length 10000 {make sure this is larger than the number of rows =
> returned}
> end
>
> format
> on every row
> print col1 clipped, "|", col2 clipped, "|", col3 clipped, "|", .....
> end
>
> Then delete the data from the table, and reload from the file:
>
> delete from tablename;
> load from datafile insert into tablename;>
> The "clipped" keyword in ACE removes any trailing blanks.
>
>
Uhmm...
I dont think so - the spaces will be put straight back in again!
If your using Online - what about using a varchar ?
--
Mike Aubury