Icon

Row Number for String

Options

Column to search
Specify the column to search for the given string
Limit row number (for First After, or Last Before)
If specifying the row number to find "first after" or "last before". eg if this is set to 10 and "first after" is specified, this will only return results of 11 onwards
Matching type
Specify if exact match or uses wildcards (? and *) or regular expressions
Search type
Specify whether to search for first, or last, or first after a given row number, or first before a given row number
Returned row numbers start from row 1 or row 0?
Should the first row be returned as row 0 or row 1?%%00010The choice depends on what the primary use of the variable will be. %%00010%%00010For Row Splitter and Row Filter, the number passed should be 0 based, even though the UI shows row counting starting at 1%%00010%%00010For Table Cropper the number passed should be 1 based, matching the UI.%%00010%%00010
If not found, return...
What to return if the string is not found
String to find
Enter the character string to find.
Name of flow variable to create
Enter name of the flow variable to create

Input Ports

This node has no input ports

Output Ports

This node has no output ports

Nodes

Extensions

Links