MQSeries.net :: View topic - How to determine input value is 'A-Z' (Character)

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to determine input value is 'A-Z' (Character)

How to determine input value is 'A-Z' (Character)

« View previous topic :: View next topic »

Author

Message

tanishka

Posted: Mon Feb 07, 2011 5:46 pm Post subject: How to determine input value is 'A-Z' (Character)

Centurion

Joined: 24 Nov 2008
Posts: 144

Hi,

I need to determine if the incoming data is Alpha character or numeric.

Some thing like this

Possible input data values '305' , '240', 'DC' 'STORE' etc....

If it is ' Alpha character Contains( indata, 'A-Z') THEN -- ( I tested and not working

----
---

else

logic -----

---.

Please Share your thoughts.

mqjeff

Posted: Mon Feb 07, 2011 6:07 pm Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Code:

--see how much better using code tags is?
DECLARE temp CHAR;
Set TEMP = myInputField;
IF LENGTH(TRANSLATE(TEMP,'ABCDEFGHIJKLMNOPQRSTUVWXYZ'))=0)

tanishka

Posted: Wed Feb 09, 2011 8:19 pm Post subject:

Centurion

Joined: 24 Nov 2008
Posts: 144

Mqjeff,

Thanks it would work.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to determine input value is 'A-Z' (Character)

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP