Function reference
Finds one string within another string.

Pos ( string1, string2 {, start } )

Argument Description
string1 The string in which you want to find string2.
string2 The string you want to find in string1.
start (optional) A long indicating where the search will begin in string. The default is 1.

Data type: Long
Returns a long whose value is the starting position of the first occurrence of string2 in string1 after the position specified in start. If string2 is not found in string1 or if start is not within string1, Pos returns 0.

The Pos() function is case sensitive.

Example 1
This expression returns the position of the letter a in the value of [data]
Pos(‘[data]’, “a”)

Example 2
This expression returns 6:
Pos(‘BABE RUTH’, ‘RU’)

Last modified: 23 May 2021


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment