Re: characters to not use in files with sql and rpgle functions

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

Yes, Loyd, I agree.

It's even worse when you're working with international addresses that 
won't use words like "road" and "lane", and punctuation symbols may 
appear in places where you don't expect them, and might even having an 
important meaning.

Personally I don't advocate stripping anything.  Especially when the 
stripping is purely due to technical/programming limitations, and those 
limitations are easy to eliminate.


On 8/17/2010 12:31 PM, Loyd Goodbar wrote:
> The thing that bothers me is the difference between "sanitizing data for
> internal use" versus "sanitizing data and distributing to others".
>
> For a silly example, let's suppose we collect addresses and don't like
> "Lane". So on the import, "Lane" is stripped from the street address.
> Suppose there's a city with Main Street, Main Drive, and Main Lane. If there
> is a 100 Main Street and 100 Main Lane, where is "100 Main" delivered?
>
> This is why I advocated retaining as much of the imported data as possible
> without change, and only transforming it on the presentation (output)
> operation.
>
> --Loyd