Loading

Extracting Strings Between Keywords Using Formulas

Дата публикации: Aug 4, 2026
Описание

Learn how to extract specific strings enclosed by keywords in text fields using a combination of MID, FIND, LEN, and TRIM functions in formulas.

Решение

This section explains how to create a formula to extract a specific string enclosed by keywords from data entered in a Text or Text Area field. The formula uses a combination of the FIND, MID, and LEN functions to identify the "starting position" and the "number of characters" for extraction.

・Implementation Example:

To extract only the string "IT" between the keywords "【１】" and "【２】" from the following text in a Text Area field (Field1__c)

Field value: "【１】IT【２】Salesforce"

・Formula Sample:

TRIM(
  MID(
    Field1__c,
    FIND("【１】", Field1__c) + LEN("【１】"),
    FIND("【２】", Field1__c) - (FIND("【１】", Field1__c) + LEN("【１】"))
  )・Role of Each Function:

FunctionGeneral RoleSpecific Role in the Above Formula
FINDReturns the position of a specific string within a text string as a number.Identifies the numerical character positions of the keywords "【１】" and "【２】".
LENReturns the number of characters in a text string.Counts the length of the keyword itself to correctly offset the starting position.
MIDReturns a specific number of characters from a text string starting at a specified position.Extracts only the target characters based on the identified start point and length.
TRIMRemoves spaces and tabs from the beginning and end of a text string.Ensures any unnecessary whitespace around the extracted "IT" is removed.

 

・Result:

The formula above successfully extracts the string "IT" located between "【１】" and "【２】".

 

 

・Considerations:

  • This formula assumes that each keyword appears only once and that "【１】" always precedes "【２】".

  • If these conditions are not met (e.g., the order of keywords is reversed), the formula may not return the intended result.

  • This is a general configuration example. Please adjust the logic according to your specific business requirements.

Дополнительные ресурсы

TRIM
FIND
MID
Scope of support for formulas

Номер статьи базы знаний

005232627

 
Загрузка
Salesforce Help | Article