MQSeries.net :: View topic - Mask Characters on a field using ESQL

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 » Mask Characters on a field using ESQL

Mask Characters on a field using ESQL

« View previous topic :: View next topic »

Author

Message

latitude

Posted: Tue Aug 18, 2009 10:43 am Post subject: Mask Characters on a field using ESQL

Apprentice

Joined: 17 Aug 2009
Posts: 36

Hi All,

I get a field value of Max length up 20 and I need to mask first 4 characters and last 4 characters. Also note that field length may vary ie. 17, 18, 19, 20

If the value is WEBSPHEREMESSAGE output should be ****PHEREMES****

How can we do this using ESQL

Thanks

stallin

Posted: Tue Aug 18, 2009 2:05 pm Post subject:

Novice

Joined: 11 Jan 2009
Posts: 21

LENGTH, SUBSTRING and REPLACE functions will do the task.

Oneway
SET FIELD_OUT = '****'||SUBSTRING(FIELD_IN FROM 5 FOR (LENGTH(FIELD_IN) - 8 )) ||'****';

nagarjun_vv

Posted: Wed Aug 19, 2009 2:06 am Post subject:

Apprentice

Joined: 24 Jun 2008
Posts: 33

Use "overlay" function

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Mask Characters on a field using ESQL

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