Hi, within the text below I want to extract:
1. the 5-digit code after the string ‘homi.one ‘, i.e. 12345
2. the mobile number i.e. +3069xxxxxxxx
3. the first name Jane
4. the surname Doe
The text is the body_plain of text extracted from Gmail for enquiries from customers.
The order of info should remain the same
How can I do this? I am using the text formatter, and I think I may need to use the extract pattern, or split text, but not sure where to go from there.
Any help would be greatly appreciated
I have tried parsing, but I had a LOT of trouble, and the parser was always getting it wrong.
Body_plain
Visit request for the following listing.
# homi.one 43866
Suburb (Region)
Property 41 m<sup>2</sup> for sale
€42,000
https://www.site.com/abc
I really like this property.
Please send me more information.
It will be me and my two dogs.
Jane Doe
+3069xxxxxxxx (All day)