Count objects closed contours

Formulas for extracting string name data

Use the following formulas when you want to:

Measure the length of strings.

Display the positions of string symbols within a string.

Display parts of strings.

Formula pattern

USE

MEASURE THE LENGTH OF A STRING

$StrLen(string)$

EXTRACT THE POSITION OF A SPECIFIC STRING SEGMENT (CASE-SENSITIVE)

$StrPos((where-to-search), what-to-search-for, idx)$

EXTRACT THE POSITION OF A SPECIFIC STRING SEGMENT (NOT CASE-SENSITIVE)

$StrPosNoCase((where-to-search), what-to-search-for, idx)$

EXTRACT STRING SEGMENTS

$SubStrIdx(where-to-search, first-idx[, last-idx])$

EXTRACT A SPECIFIED NUMBER OF SYMBOLS

$SubStrLen((where-to-search, first-idx[, length])$

NOTES

In the notes and examples that follow, item refers to a letter, digit or symbol.

The StrPos formula is case-sensitive.

where-to-search indicates, for example, a 1up drawing.

what-to-search-for indicates an item or a series of items to search for.

idx indicates the position of the searched-for item in the string. IMPORTANT: The first item is counted as 0, the second as 1, and so on. The following rules apply:

You can omit stating idx. In this case, the formula returns the first occurence of the searched-for item from left to right.
If idx equals or is greater than zero, the formula returns the respective occurrence of the searched-for item from left to right.
If idx is less than zero, the formula returns the first occurrence of the searched-for item from right to left. IMPORTANT: Note that in this case the rightmost item is counted as 1, the next one as 2, and so on.

The SubStrIdx formula returns the item that starts from a specified position (first-idx) and ends at a second position (last-idx). If the second position is omitted, the formula returns all the string items from the initial position until the end of the string. The positions are extracted with the StrPos or StrPosNoCase formulas.

The SubStrLen formula returns a series of items that (1) starts at a specified position and (2) has as many items as is the specified number. The item positions are extracted with the StrPos or StrPosNoCase formulas.

Examples

The examples that follow refer to a material named W-12xy EB-WB-00. In the formulas, n0 ensures that no zeroes will appear after the decimal point.

TO DISPLAY

USE

YOU WILL SEE

The number of string items, spaces included

$StrLen((#OneUp1.Material.Name)), n0$

The position of the first dash

$StrPos((#OneUp1.Material.Name), "–", 0), n0$

The position of the second dash

$StrPos((#OneUp1.Material.Name), "–", 1), n0$

The position of the third dash

$StrPos((#OneUp1.Material.Name), "–", 2), n0$

The position of the fourth dash

$StrPos((#OneUp1.Material.Name), "–", 3), n0$

–1 There is no fourth dash in the string.

The position of the first dash from right to left

$StrPos((#OneUp1.Material.Name), "–", –1), n0$

3 In right-to-left counting, the first position counts as 1.

The position of the letter "E"

$StrPos((#OneUp1.Material.Name), "EB"), n0$

The the position of the letters "eb"

$StrPos((#OneUp1.Material.Name), "eb"), n0$

-1 Because case-sensitivity is respected, the item series "eb" has not been found.

The position of the letter "E"

$StrPosNoCase((#OneUp1.Material.Name), "EB"), n0$

7 The position of the letter "E". No case-sensitivity.

The position of the letter "E"

$StrPosNoCase((#OneUp1.Material.Name), "eb"), n0$

7 The position of the letter "E". No case-sensitivity.

The symbols between two specified string positions

$SubStrIdx((#OneUp1.Material.Name), strpos((#OneUp1.Material.Name), "–", 0)+1, strpos((#OneUp1.Material.Name), "–", 1))$

12xy EB The item series between the first and second specified dashes.

Four items after a specified items

$SubStrLen((#OneUp1.Material.Name), strpos((#OneUp1.Material.Name), "–", 0)+1, 4)$

12xyThe four symbols after the specified dash.