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: blobby
I want to extract the term blobby
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/d391623b-18a6-4edf-a3f9-614cd2ed6bbc.png)
Data out just says:
Fields with no value:
output
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: blobby
I want to extract the term blobby
Data out just says:
Fields with no value:
output
Hi
For us to have more context, post screenshots of the Description Text value from Step 1.
Hi
For us to have more context, post screenshots of the Description Text value from Step 1.
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
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
Can you show the raw DATA OUT from step 1?
Formatter help: https://zapier.com/apps/formatter/help
Try this:
Other options:
Can you show the raw DATA OUT from step 1?
Formatter help: https://zapier.com/apps/formatter/help
Try this:
Other options:
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!
const text = "{{data}}";
const usernameMatch = text.match(/username:\s*(\w+)/);
if (usernameMatch) {
const username = usernameMatch[1].trim();
return username;
}
fyi...Formatter Zap steps count as 0 Tasks, but Code steps count as 1 Task.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.