Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

D lang syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:rightfind(column_string,string_pattern,[ignore_case], [start_index])

rightfind(columnstring_to_stringsearch,stringsearch_patternfor,[ignore_case], [start_indexat])


ArgumentRequired?Data TypeDescription
columnstring_to_stringsearchYstringName of the column or string literal to be applied to the functionstring_patternstring, function returning a string, or a column containing strings.
search_forYstringString literal

The string or pattern

to find

you want to search. This can be a string, function returning a string, or string literal or

Pattern pattern or regular expression.
ignore_caseNbooleanIf true, a case-insensitive match is performed. Default is Indicates if the Rightfind function ignores case when trying to match the string or pattern. The default value is false.
start_indexatNinteger (non-negative)

If specified, this value identifies the start index value of the source data to search for a match.

Info

NOTE: This value is specified from the end of the string.

 

Indicates the position in the column or string literal value at which to begin the search. This value can be an integer, a function returning an integer, or a column containing integers. The default value is 0.

If not specified, the entire string is searched.

D s lang notes

...

...

Name of the item to be searched. Valid values can be:

...

Required?Data TypeExample Value
YesString literal or column reference (String, Array, or Object)myColumn

...

search_

...

for

String literal or pattern to find. This value can be a string literal, a

D s lang
itempattern
, or a regular expression.

...

Required?Data TypeExample Value
NoBooleantrue

start_

...

at

The index of the character in the column or string literal value at which to begin the search, from the end of the string. For example, a value of 2 instructs the RIGHTFIND function to begin searching from the third character in the column or string value.

Info

NOTE: Index values begin at 0. If not specified, the default value is 0, which searches the entire string from the end of the string.

  • Value can be an integer, a function returning an integer, or a column containing integers. 

    • If a column name is specified, start_at can be different for each row.
    • If a constant integer value is specified, the start_at is same for all rows.

  • Value must be a non-negative integer value.

  • If this value is greater than the length of the string, then no match is possible.

...