Pos
PowerScript function
Description
Finds one string within another string.
Syntax
|
1 |
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 string1. |
Return value
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. If any argument’s value is null, Pos returns
null.
Usage
The Pos function is case sensitive.
Examples
This statement returns 6:
|
1 |
Pos("BABE RUTH", "RU") |
This statement returns 1:
|
1 |
Pos("BABE RUTH", "B") |
This statement returns 0, because the case does not match:
|
1 |
Pos("BABE RUTH", "be") |
This statement starts searching at position 4 and returns 0, because
position 4 is after the occurrence of BE:
|
1 |
Pos("BABE RUTH", "BE", 4 ) |
These statements change the text NY in the SingleLineEdit sle_group
to North East:
|
1 2 3 4 |
long place_nbr place_nbr = Pos(sle_group.Text, "NY") sle_group.SelectText(place_nbr, 2) sle_group.ReplaceText("North East") |
These statements separate the return value of GetBandAtPointer into
the band name and row number. The Pos function finds the position of the
tab in the string and the Left and Mid functions extract the information
to the left and right of the tab:
|
1 2 3 4 5 6 7 8 |
string s, ls_left, ls_right integer li_tab s = dw_groups.GetBandAtPointer() li_tab = Pos(s, "~t", 1) ls_left = Left(s, li_tab - 1) ls_right = Mid(s, li_tab + 1) |
You could write similar code for a generic parsing function with
three arguments. The string s would be an argument passed by value and
ls_left and ls_right would be strings passed by reference.
Other functions that return a pair of tab-separated values for which
you could use the parsing function are GetObjectAtPointer and
GetValue.
See also
GetValue method for DataWindows in the section called “GetValue” in DataWindow Reference.
GetObjectAtPointer method for DataWindows in the section called “GetObjectAtPointer” in DataWindow Reference.
Pos method for DataWindows in the section called “Pos” in DataWindow Reference.