RE: field created from Excel download

["Janice Chester" <janice@xxxxxxxxxxxxx>]

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