Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

String function like Instr, Substring, Indexof and contains

6,291 views
Skip to first unread message

chithu.pa...@gmail.com

unread,
Apr 22, 2009, 7:56:19 AM4/22/09
to chida...@crawler.com
Hi All,

I'm new to PB. Please let me know the equal command or similar command
for the below:

Instr
Substring
Indexof
Contains

Because i have to find the one word in the string. Please let me know
ASAP.

Regards & Thanks,
Chidambaram

Terry Voth [TeamSybase]

unread,
Apr 22, 2009, 8:24:13 AM4/22/09
to
Pos (primary_string, search_substring [, starting_index])

Also LastPos (), same parms, may be of interest to you.

Good luck,

Terry and Sequel the techno-kitten

On Wed, 22 Apr 2009 04:56:19 -0700 (PDT), chithu.pa...@gmail.com
wrote:

*********************************
Build your vocabulary while feeding the hungry
http://www.freerice.com
*********************************
Newsgroup User Manual
=====================
TeamSybase <> Sybase employee
Forums = Peer-to-peer
Forums <> Communication with Sybase
IsNull (AnswerTo (Posting)) can return TRUE
Forums.Moderated = TRUE, so behave or be deleted
*********************************

Sequel's Sandbox: http://www.techno-kitten.com
Home of PBL Peeper, a free PowerBuilder Developer's Toolkit.
Version 4.0.4 now available at the Sandbox
PB Futures updated June 25/2008
See the PB Troubleshooting & Migration Guides at the Sandbox
^ ^
o o
=*=

Roland Smith [TeamSybase]

unread,
Apr 22, 2009, 8:36:19 AM4/22/09
to
The equivalent of InStr is Pos. There is also a LastPos function that starts
at the end. The equivalent of Substring would be Mid.

I'm not familiar with the others.

Open the Help file and look up "string functions".


Jerry Siegel [TeamSybase]

unread,
Apr 22, 2009, 12:29:14 PM4/22/09
to
Substring should map to Mid. The Left and Right functions may also be of
interest.

--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<chithu.pa...@gmail.com> wrote in message
news:715cb0a6-e078-4f42...@z8g2000prd.googlegroups.com...

sta...@sequelmed.com

unread,
Jan 30, 2018, 6:39:57 AM1/30/18
to
0 new messages