×
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.
Thanks Tim.
Janice Chester
Tefron USA, Inc.
P.O. Box 100
720 Main Street
Valdese, NC 28690
janicechester@xxxxxxxxxxxxx
Phone: (828) 879-6518
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of tim
Sent: Friday, June 29, 2007 12:19 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: field created from Excel download
Janice,
In excel you can use the upper() function to convert it to upper case.
If you want to convert after the upload to the as400, you can run a pgm
over
it using the %xlate function.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Janice Chester
Sent: Friday, June 29, 2007 12:06 PM
To: midrange-l@xxxxxxxxxxxx
Subject: field created from Excel download
I am downloading data from Excel to a database file on the /400. The
data in one of the fields has lower case data. Is there a way to make it
upper case?
Thanks,
Janice
Janice Chester
Tefron USA, Inc.
P.O. Box 100
720 Main Street
Valdese, NC 28690
janicechester@xxxxxxxxxxxxx
Phone: (828) 879-6518
midrange.com
