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

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.