Skip to content
Infoveave Help

FIND

FIND is a function that finds the position of a substring in a text.

Applicable to

Calculated Columns

Return Value

The FIND function returns the starting position of the first occurrence of a substring within a text string.

Remark

  • The FIND function is case-sensitive, meaning that it considers uppercase and lowercase characters as distinct.
  • If the substring is found, the FIND function returns the position of the first character of the first occurrence of the substring within the text string.
  • The first character in the text string starts at position 1.
  • If the substring is not found, the function returns 0.
  • FIND function is applicable only for text values

Syntax

FIND(<expression>,find)

FIND in Calculated Columns

ParameterDescription
ExpressionA placeholder in a function that is replaced with the column names.
Column NameThe name of the column in the dataset or Datasource that contains the values you want to analyze.
findThe substring that you want to find within the text.

Steps to use FIND in Calculated Columns

  1. Write the FIND function. For instance FIND(<expression>,find)
  2. Replace <expression> with VALUE([Column Name]) and replace find with the substring you want the position of.Replace the Column Name with the actual name of your column required.
  3. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.

Example

Objective Consider that you have the below sales dataset, your goal is to find the position of the text “e” in CATEGORY.

ORDER DATECOUNTRYCATEGORYUNIT PRICEMARKET PRICEQUANTITY
2024-01-03BrazilBaby Food38.4143.78742
2024-01-07JapanSpices45.5650.815520
Japan43.787410
2024-01-1832.30194
2024-01-22BrazilCosmetics28.33523.01097
2024-01-26Canada20.18523.01099
2024-01-04FranceCereal25.2628.79649
2024-01-09BrazilCereal44.57550.81558
2024-01-14BrazilSnacks20.1854
BrazilCosmetics40.48546.15292

You can use the FIND function like

FIND(VALUE([CATEGORY]), "e")

The new calculated column “Text Position” will return

ORDER DATECOUNTRYCATEGORYUNIT PRICEMARKET PRICEQUANTITYTEXT POSITION
03-01-2024BrazilBaby Food38.4143.787420
07-01-2024JapanSpices45.5650.8155205
Japan43.7874100
18-01-202432.301940
22-01-2024BrazilCosmetics28.33523.010975
26-01-2024Canada20.18523.010990
04-01-2024FranceCereal25.2628.796492
09-01-2024BrazilCereal44.57550.815582
14-01-2024BrazilSnacks20.18540
BrazilCosmetics40.48546.152925