Re: Convert unquoted text to upper case?

Do NOT use the bit approach unless you are absolutely sure the ONLY
characters in the field are guaranteed to be in the ranges of:
x'81' - x'89'
x'91' - x'99'
x'A2' - x'A9'
x'C1' - x'C9'
x'D1' - x'D9'
x'E2' - x'E9'

Otherwise I can assure you that you are going to be surprised
(unpleasantly).

Bruce

On Thu, Aug 16, 2018 at 1:15 PM Musselman, Paul <pmusselman@xxxxxxxxxxxxxxxx>
wrote:

Only things I'm aware of convert the string you pass to it.

You'd have to parse the string to find the beginning and ending quotes and
ignore that part...

I'm sure that there's a simple SQL trick to scan-and-replace up to but not
including the first ", resuming after the 2nd ", but I'm only dangerous
with SQL.
Or maybe scan-and-replace from both ends towards the middle, and stop at
the " (assuming only one "quoted string" in the string being changed).
The MC Press article mentions that changing bit #1 in an EBCDIC character
will force lower to uppercase.

I'm assuming the quoted portion is not in a fixed position.

I've used QDCXLATE for a complete string (
https://www.ibm.com/support/knowledgecenter/ja/ssw_i5_54/apis/QDCXLATE.htm
)

MC Press had this roll-your-own article:
https://www.mcpressonline.com/programming/rpg/toupperconvert-lowercase-letters-to-uppercase

In CL:
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/rbam6/rbam6upperbif.htm

In SQL: http://www.rpgpgm.com/2015/02/changing-case-using-sql.html

Paul E Musselman
PaulMmn@xxxxxxxxxxxxx

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD