Question

Extracting Text From in Between Specific Values Problem

  • 25 January 2024
  • 1 reply
  • 52 views

Userlevel 1

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": [
   "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
 }
]


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @kaseandcourt 

Some options:

 

Reference