FindOneOf - script and chart function

Overview

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• A dataset which is loaded into a data table called Example.

• One field in the data table called Phrase, which contains the original text strings to be processed.

Load script

Example:
Load *
Inline
[Phrase
Many tiny beads
For a very long time
Has the potential for growth
];

Results

Load the data and open a sheet. Create a new table and add this field as a dimension:

• Phrase

Create the following calculated dimensions:

• =FindOneOf(Phrase, 'e', 1)

• =FindOneOf(Phrase, 'y', 1)

• =FindOneOf(Phrase, 'ey', 1)

• =FindOneOf(Phrase, 'e', 2)

• =FindOneOf(Phrase, 'y', 2)

• =FindOneOf(Phrase, 'ey', 2)

For each calculated dimension, the output returns the position of the occurrence of the characters from the search set for each phrase. For example, the first occurrence of the letter e is found at position 8, 7, and 12 for each phrase respectively. The second occurrence of the letter e in each phrase is found at position 20, 12, and 0 (not found). Similarly, the first occurrence of the letters 'e or y' is found at position 8, 7, and 4, for each phrase respectively. Notice that in the phrase For a very long time, the first occurrence of 'e or y' is found at position 8, an e, and the second occurrence at position 10, a y.

The following code shows how to use the function in a load script.

Example:
Load *, FindOneOf(InputText, SearchFor, Occurrence) AS FindOneOf_Matches
Inline
InputText, SearchFor, Occurrence
my example text string, et%s,1
my example text string, et%s,3
my example text string, ¤%&,1
];

Overview

This example uses the FindOneOf function to analyze customer comments in a dataset of customer orders and identify orders that may require action. Each order has a CustomerComment field where customers can leave notes or comments about their orders. By analyzing the comments, you can identify specific keywords or characters, such as '!', '@', '#', that might indicate urgency or special requests.

Open the Data load editor and add the load script below to a new tab.

The load script contains:

• A dataset which is loaded into a data table called Example.

• The following fields in the data table:

  • TicketID the identity number of the ticket

  • CustomerComment the original text string

Load script

Example:
Load * inline [
TicketID, CustomerComment
1, I need this order ASAP!
2, Please confirm my order @12345.
3, Can you update my order?
4, I have a question about #discount.
5, Thank you!
];

Results

Load the data and open a sheet. Create a new table and add these fields as dimensions:

• TicketID

• CustomerComment

Create the following calculated dimensions:

• =FindOneOf(CustomerComment, '!,@,#')

• =If(FindOneOf(CustomerComment, '!,@,#')>0,'High Priority','Normal Priority')

Compare the output of the FindOneOf function to the original CustomerComment string values that loaded in the script. Using the values !,@,#, the function successfully returned the position where those characters occur in the comment string. The final measure uses a conditional If statement to identify records that include any of the search characters and assign these as High Priority. If none of the search characters !,@,# are found, for example row 3, then the ticket is classified as Normal Priority.