Re: Using REGEXP_REPLACE -- MIDRANGE-L

Subject: Re: Using REGEXP_REPLACE
From: David Gibbs <david@xxxxxxxxxxxx>
Date: Mon, 11 Jul 2022 12:47:18 -0500
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

On 7/11/22 12:45 PM, Scott Klement wrote:

One possibility is that you have a CCSID misconfiguration on your system. The [] characters have different code points in different flavors of EBCDIC, so if you have a CCSID mismatch, it won't recognize these characters properly, and it'll end up not replacing the letters 'Red'.

Oh, good callout Scott.

Back when I was working on Implementer, and we were starting to use regex for pattern matching, we had to externalize our expressions in message files so we could retrieve them in a job appropriate CCSID.

david

This mailing list archive is Copyright 1997-2026 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.