instr

[Former Member]

Hi,

in Oracle, instr is to return the exact position of one substring within another string. How to achieve the same in Crystal report syntax?

Thanks & Best Regards

[Former Member · Accepted solution]

Hi

1.Create a formula

2.In the formula you can have the "InStr" itself .

InStr (str1, str2)

InStr (start, str1, str2)

InStr (str1, str2, compare)

InStr (start, str1, str2, compare)

Eg: InStr("abcdefg", "bcd")

This will Return 2

Eg: InStr(3, "abcdefg", "cde")

Return 3

Eg: InStr("KarenJudith","karen",1)

Return 1

If you need further reference go to CR Help and Search InStr in it.

Regards

Vivek

Edited by: viveksr on Sep 14, 2011 6:00 AM