How to find a certain string of text/pattern?

Hi @DarkRoom 

Good question.

Can you further describe the desired output using a specific example.

Perhaps try this Zap action: Formatter > Text > Extract Pattern

To be more specific, I want to extract every mention of specific words/phrases. In this case it would be EMB 1. I want to use every mention of the specified word (EMB 1 is mentioned 3 times here) individually to make 3 separate items in Monday.com containing the word I’m referencing.

As far as using the action you had mentioned, I’m not sure what regular python expression to use in order to achieve my desired outcome.

@DarkRoom 

Try asking ChatGPT for help with the regex to use in the Zap step.

I’m still having trouble. I want to create a new item in Monday.com for every specific word or phrase I look up. So in this exact instance, I would want 3 new items in Monday.com (because I was looking for EMB and there were 3 mentions of the word) all with the same Order Nickname found within the Printavo Trigger step. Is this doable?

@DarkRoom 

Yes it’s possible once you configure this Zap action correctly.

Zap action: Formatter > Text > Extract Pattern

Then the Looping app can be used to iterate: https://zapier.com/apps/looping/help

This is the result I get when using code to find a specific word.

And when I try and add it to the loop function (I’m using the create loop from line item option) the option for the previous step comes up

Also, how would I go about getting this integrated into Monday.com?

@DarkRoom 

We would need to see screenshots with how your Formatter step is configured to have context.

Hopefully this is what you’re looking for

@DarkRoom 

Try using a JavaScript Code step.

Then use this Zap action: Looping - Create Loop from Numbers

CONFIG

Set the Input Data values.

CODE

let text = inputData.text;
let match = inputData.match;
let count = countOccurrences(text, match);

function countOccurrences(text, match) {
  // Use a regular expression with the global flag to find all occurrences
  const regex = new RegExp(match, 'g');
  const matches = text.match(regex);

  // Return the number of matches (or 0 if there are no matches)
  return matches ? matches.length : 0;
}

output = [{count, match, text}];

I’m not quite sure what I’m doing wrong so I’ll go over my entire process and then you can point out if something looks wrong.

1. I start by setting the trigger. Steps 2-4 are related to something else and they’re working so please disregard them. 
2. Step 5 looks like this: 

   

   This is the field I want to get the text from.

3. This is the code that I use to try and extract all of the information I want (I know that this example doesn’t have some of these words. I’m generalizing it so that it can automate anything that comes my way).

4. 

   Finally this is the code that I use. Not exactly sure what it’s supposed to do.

5. 

   I’m at a loss for what I’m supposed to do. I have no background on any of this stuff. Hopefully this gives you more insight into what I’m working with. If not please let me know and I will show you.

@DarkRoom 

Try these Zap steps:

1. Trigger: Printavo
2. Action: Filter
3. Action: Code
4. Action: Looping - Create Loop from Numbers
5. Action: Monday - Create Item

Not sure if you need any of the Formatter steps.

I think there’s one issue with the code. The text I’m searching is in line item form. Would this matter?

@DarkRoom

We would need to see screenshots with how your Code steps is configured and how your Zap steps are outlined now.

The match input is not meant to handle regex, rather just the single match term.

Okay that makes a bit more sense. How would I go about specifying what words I want to find? It could be a multitude of different things. Anything from SP-13 to HT 2 and Vinyl 4 to EMB 21 .

Here’s my steps. Set up to find an updated Invoice based off of a key word

Here’s how the code is set up.

This is a shot in the dark on how I would rectify the match input not handling code. Does this look right?

I would obviously add any words I want to find in similar fashion

@DarkRoom 

The code that was provide was only configured for the “match” input.

So the input for “match_1” won’t work unless the code is adjusted.

Is there any way I can have all of the words I want to find in one field? For example, SP-(0-9) (depending on what number is found), HT (0-9) and so on? or is the match only set up to handle one term?

@DarkRoom 

The custom Code is only configured to check for 1 “match” term.

If you are interested in having the Code configured to handle multiple terms, then you can submit a lead here: https://zapier.com/experts/automation-ace

@Troy Tessalone 

I have the code set up to search for multiple match fields. My question is: can I have one match field contain all of the words I want to find? It would be less effort on my part if I could have all of the words I want to find in one match field.

Example: match

SP-1, SP-2, SP-3 (and so on)

Instead of

match

SP-1

match_1

SP-2

(and so on)

@DarkRoom 

Yes, that’s possible, but the code needs to be reconfigured to handle multiple terms in for the “match” input.

How would I go about wording the match field for multiple words?

Also, I’m trying to see if the loop step works and I’m still only getting one item to be created. 

@Troy Tessalone 

@DarkRoom 

Make sure to review the help articles for using the Looping app in Zaps: https://zapier.com/apps/looping/help

If you are interested in having the Code configured to handle multiple terms, then you can submit a lead here: https://zapier.com/experts/automation-ace

@DarkRoom 

We would need to see updated screenshots with how your Zap steps are configured to have true context.