Hello Makersss! In a bit of a pickle and would love some helpp. I have the current Text Parser Setup to take texts after every colon, but it doesn’t take the details that are on a different line.
Context: We have a Slack form that our team puts in info, the idea in using Make, is to separate those infos and save them in their own variable to be used in creating a new task in ClickUp
Also attached my json fileee
Nariesss-Needs-Help.json (421.7 KB)
Thank youuuuu
It is assumed that each pair is on the same line.
If you want to match content across multiple lines you have to use the Text Parser “Match Pattern” module instead.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
Thank you for the replyyy. Would it be alright if I ask for help with how would the RegEx look like for ittt? We will constantly be receiving this type of format
Assigned AA: Name
Client: Client Name
Title of Your Question: Test Subject Line for Email
Request or Question: Request Bank Statement for July & August 2024
1. Bank Number 1 (July 2024) - covered date July 1-31, 2024.
2. Bank Number 2
Also something something something.
Attachment:
Thank youuuuu
Welcome to the Make community!
You can use a Text Parser “Match Pattern” module with this Pattern (regular expression):
Assigned AA: (?<assigned_aa>[\w\W]+?)\s+Client: (?<client>[\w\W]+?)\s+Title of Your Question: (?<title>[\w\W]+?)\s+Request or Question: (?<message>[\w\W]+?)\s+Attachment:
Proof https://regex101.com/r/aySwAL/1
Global match must be set to NO!For more information, see Text Parser in the Make Help Center:
Match Pattern
The Match pattern module enables you to find and extract string elements matching a search pattern from a given text. The search pattern is a regular expression (aka regex or regexp), which is a sequence of characters in which each character is either a metacharacter, having a special meaning, or a regular character that has a literal meaning.
- The complete list of metacharacters can be found on the MDN web docs website.
- For a tutorial on how to create regular expressions, we recommend the RegexOne website.
- For an easy, quick regex generator, try the Regular Expressions generator.
- For experimenting with regular expressions, we recommend the regular expressions 101 website. Just make sure to tick the ECMAScript (JavaScript) FLAVOR in the left panel.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
SUCH A HEROOO THANK YOUUUU SO MUCHHH!! @samliew! This worksss perfectlyyy!