Hi, I’m a newbie and I want to extract the exact text in between values to get email to send Gmail and Phone number to send Sly.
I don’t want to use the extract Phone,Email and Number because it can only extract the first one.
I tried using Extract Pattern (?<=Email:).*?(?=\n\nPhone#:) but I keep getting no result but if I useÂ
(?<=Email:).*?(?=Phone#:) I get this sample.task@gmail.com,task.sample@gmail.com\n\n
/
 {
 "id": "7625674839",
 "assigner_id": null,
 "assignee_id": null,
 "project_id": "2327416095",
 "section_id": "145718943",
 "parent_id": null,
 "order": 2,
 "content": "Follow Ups: Ramsky Padig 112233",
 "description": "Email: sample.task@gmail.com,task.sample@gmail.com\n\nPhone#: **‪(480) 000-0000, 481-0000-0000** ",
 "is_completed": false,
 "labels": l
  "FollowUp_AccOfferSeller"
 ],
 "priority": 1,
 "comment_count": 0,
 "creator_id": "35937575",
 "created_at": "2024-01-23T20:17:53.873722Z",
 "due": null,
 "url": "https://todoist.com/showTask?id=7625674839",
 "duration": null
 },
 {
 "id": "7625674824",
 "assigner_id": null,
 "assignee_id": null,
 "project_id": "2327416095",
 "section_id": "145718943",
 "parent_id": null,
 "order": 3,
 "content": "KPi",
 "description": " http://tinyurl.com/469hnnpt](http://tinyurl.com/469hnnpt)",
 "is_completed": false,
 "labels": /],
 "priority": 1,
 "comment_count": 0,
 "creator_id": "35937575",
 "created_at": "2024-01-23T20:17:53.649574Z",
 "due": null,
 "url": "https://todoist.com/showTask?id=7625674824",
 "duration": null
 }
]
Page 1 / 1
Hi
Some options:
- Formatter > Text > Split
- Use multiple steps to isolate the values
- Formatter steps count as 0 Tasks
- AI
- AI by Zapier > Parse Data from Text: https://zapier.com/apps/ai/integrations#triggers-and-actions
- ChatGPT > Extract Structured Text: https://zapier.com/apps/chatgpt/integrations#triggers-and-actions
- OpenAI: https://zapier.com/apps/openai/integrations#triggers-and-actions
- Code: https://zapier.com/apps/code/help
- Ask ChatGPT for help coming up with the regex.
Â
Reference
Â
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.