Hi,
Can someone please help with where i’m going wrong extracting this text with Formatter?
I know it’s going to be something small!
username: blobbyI want to extract the term blobby
Data out just says:
Fields with no value:
output
Best answer
Help with a simple Text Formatter question!
+1- Tinkerer
Best answer by 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!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
Hi
For us to have more context, post screenshots of the Description Text value from Step 1.
+1- Tinkerer
Hi
For us to have more context, post screenshots of the Description Text value from Step 1.
+6- Zapier Staff
Hi
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!
+1- Tinkerer
Hi
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
+14- Zapier Orchestrator & Solution Partner
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
+1- Tinkerer
- Answer
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!
+3
const text = "{{data}}";
const usernameMatch = text.match(/username:\s*(\w+)/);
if (usernameMatch) {
const username = usernameMatch[1].trim();
return username;
}
+14- Zapier Orchestrator & Solution Partner
fyi...Formatter Zap steps count as 0 Tasks, but Code steps count as 1 Task.
+3Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.