MQSeries.net :: View topic

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 » substring

substring

« View previous topic :: View next topic »

Author

Message

paustin_ours

Posted: Thu Jun 26, 2014 3:40 am Post subject: substring

Yatiri

Joined: 19 May 2004
Posts: 667
Location: columbus,oh

trying to get the last character of a string.

substring(<expression> from -1 for 1) doesnt work

substring(<expression> from -1 - returns the entire string

substring(<expression> from -1 for -1) - didnt make sense but tried it anyway but didnt work.

any suggestions?

paustin_ours

Posted: Thu Jun 26, 2014 3:49 am Post subject:

Yatiri

Joined: 19 May 2004
Posts: 667
Location: columbus,oh

nevermind just used the length as a start point but still would like to know why a negative start point doesnt work. It says it can be used in the infocenter.

aggarwal.intouch

Posted: Thu Jun 26, 2014 4:01 am Post subject:

Acolyte

Joined: 30 May 2011
Posts: 56
Location: India

SUBSTRING (<expression> FROM LENGTH(<expression>) - 1)

zpat

Posted: Thu Jun 26, 2014 5:45 am Post subject:

Jedi Council

Joined: 19 May 2001
Posts: 5866
Location: UK

Use the RIGHT function.
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » substring

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