Hi @JolteonPixel 

For us to have more context, post screenshots of the Description Text value from Step 1.

Hi @JolteonPixel,

I’m jumping in to see if I can help!

I believe the Extract Pattern function is best for your use case here. You can use this regex in the “Pattern” field: username:\s*(.*)

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Hi, thanks for the response!

Progress! I do get blobby, but then sadly I get all the text which succeeds blobby, so

blobby Manager: etc etc etc etc etc etc etc

@JolteonPixel 

Can you show the raw DATA OUT from step 1?

Formatter help: https://zapier.com/apps/formatter/help

Try this:

• Action: Formatter > Text > Split
  • Split by: username:
  • Keep the last segment
• Action: Formatter > Text > Split
  • Split by: Manager:
  • Keep the first segment
• Action: Formatter > Text > Trim Whitespace
  • Used to remove the leading/trailing spaces

Other options:

• Code for parsing text
• AI

@JolteonPixel

Can you show the raw DATA OUT from step 1?

 

Formatter help: https://zapier.com/apps/formatter/help

Try this:

• Action: Formatter > Text > Split
  • Split by: username:
  • Keep the last segment
• Action: Formatter > Text > Split
  • Split by: Manager:
  • Keep the first segment
• Action: Formatter > Text > Trim Whitespace
  • Used to remove the leading/trailing spaces

 

Other options:

• Code for parsing text
• AI

 

 

Thank you Troy! I never thought about doing subsequent activities on the output of a formatter step.  So I did what you said and grabbed the username, then split it and kept the first string, then removed the whitespace, so 3 actions. It would have been nice to get the regex working to make it a little more elegant, but your post got me what I wanted, thank you!

@JolteonPixel If you want to save action steps, you can do extraction using javascript with something like this. Replace {{data}} with your description text

const text = "{{data}}";
const usernameMatch = text.match(/username:\s*(\w+)/);
if (usernameMatch) {
  const username = usernameMatchM1].trim();
return username; 
}

@fiona819 

fyi...Formatter Zap steps count as 0 Tasks, but Code steps count as 1 Task.

@Troy Tessalone Thank you for your correction!