# How to do a double split text? **URL:** \ **Category:** Questions\ **Tags:** ai\ **Created:** [August 14, 2024, 3:00pm UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970 "2024-08-14T15:00:25Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Tommyst](https://avatars.discourse-cdn.com/v4/letter/t/45deac/32.png) [@Tommyst](https://community.make.com/u/Tommyst)\ **Post date:** [August 14, 2024, 3:00pm UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970/1 "2024-08-14T15:00:25Z")
Hi, I have text with three sections (coming from a chat model). Start, Stop and Continue. How to split these in three separate variables so I can put them in different cells in Google Sheets. Is it possible to a double split? With Stop and Continue? The first part split works and I can also can make the last part work, but how to get the middle section, that’s for my the tricky part. Hereby an output ```auto [ { "textResponse": "Start:\n1. Visual Enhancement:\n - Incorporate more dynamic b-roll footage to showcase the product in use\n - Use close-up shots to highlight product details\n - Display ingredient measurements on-screen\n\n2. Content Improvement:\n - Add clickable timestamps in the video description for easy navigation\n - Implement a clear call-to-action (CTA) at the end of the video\n - Include a brief comparison with similar products in the market\n - Showcase common substitutions for dietary restrictions\n\n3. Accessibility:\n - Add English subtitles\n - Include a printable recipe card in the video description\n\nStop:\n1. Audio Issues:\n - Using generic stock music that doesn't match the brand's vibe\n - Using background music that overpowers the narrator's voice\n\n2. Content Problems:\n - Overloading the video with too many sponsorship mentions\n - Rushing through important product features or complex cooking techniques\n - Spending too much time on the unboxing process\n - Using technical jargon without explanation\n - Assuming viewers have advanced cooking knowledge\n\n3. Visual Distractions:\n - Filming in a cluttered background that distracts from the product\n\nContinue:\n1. Production Quality:\n - Maintaining high-quality video production and crisp audio\n - Maintaining high-quality food videography\n\n2. Presentation:\n - Engaging with viewers through witty and relatable commentary\n - Maintaining enthusiasm and energy throughout the video\n - Injecting humor and personality into the narration\n\n3. Content Delivery:\n - Collaborating with the influencer who has great on-screen presence\n - Demonstrating key features with hands-on examples\n - Providing useful cooking tips and tricks throughout the video\n\n4. Audience Engagement:\n - Responding to viewer comments for increased engagement\n", "id": "msg_012Cb9zkyHkKVvCEehCxn8zD", "type": "message", "role": "assistant", "model": "claude-3-5-sonnet-20240620", "content": [ { "type": "text", "text": "Start:\n1. Visual Enhancement:\n - Incorporate more dynamic b-roll footage to showcase the product in use\n - Use close-up shots to highlight product details\n - Display ingredient measurements on-screen\n\n2. Content Improvement:\n - Add clickable timestamps in the video description for easy navigation\n - Implement a clear call-to-action (CTA) at the end of the video\n - Include a brief comparison with similar products in the market\n - Showcase common substitutions for dietary restrictions\n\n3. Accessibility:\n - Add English subtitles\n - Include a printable recipe card in the video description\n\nStop:\n1. Audio Issues:\n - Using generic stock music that doesn't match the brand's vibe\n - Using background music that overpowers the narrator's voice\n\n2. Content Problems:\n - Overloading the video with too many sponsorship mentions\n - Rushing through important product features or complex cooking techniques\n - Spending too much time on the unboxing process\n - Using technical jargon without explanation\n - Assuming viewers have advanced cooking knowledge\n\n3. Visual Distractions:\n - Filming in a cluttered background that distracts from the product\n\nContinue:\n1. Production Quality:\n - Maintaining high-quality video production and crisp audio\n - Maintaining high-quality food videography\n\n2. Presentation:\n - Engaging with viewers through witty and relatable commentary\n - Maintaining enthusiasm and energy throughout the video\n - Injecting humor and personality into the narration\n\n3. Content Delivery:\n - Collaborating with the influencer who has great on-screen presence\n - Demonstrating key features with hands-on examples\n - Providing useful cooking tips and tricks throughout the video\n\n4. Audience Engagement:\n - Responding to viewer comments for increased engagement" } ], "stop_reason": "end_turn", "stop_sequence": null, "usage": { "input_tokens": 406, "output_tokens": 422 } } ] ``` ---
**Author:** ![Mr.Make](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/mr.make/32/93066_2.png) [@Mr.Make](https://community.make.com/u/Mr.Make)\ **Post date:** [August 14, 2024, 3:04pm UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970/2 "2024-08-14T15:04:05Z")
Honestly easiest way is to go and input this as constraints right into the model itself this is what I would say. "Please provide the feedback in a JSON format with three keys: ‘Start,’ ‘Stop,’ and ‘Continue.’ Each key should contain the corresponding feedback text. Here is the format: ```auto { "Start": "Your Start feedback here...", "Stop": "Your Stop feedback here...", "Continue": "Your Continue feedback here..." } ``` Please follow this structure strictly." ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [August 14, 2024, 4:38pm UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970/3 "2024-08-14T16:38:05Z")
Welcome to the Make community! ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/a/3a0c58927f26b0aa42ae058e92d98af878686a3a.png) You can use a Text Parser “[Match Pattern](https://www.make.com/en/help/tools/text-parser)” module with this Pattern (regular expression): `Start:\s+(?[\w\W]+?)\s+Stop:\s+(?[\w\W]+?)\s+Continue:\s+(?[\w\W]+?)\s+$` **Proof** [https://regex101.com/r/6t4ENA/1](https://regex101.com/r/6t4ENA/1) ### Important Info - ⚠ **Global match** must be set to **NO**! ## Screenshot ![Screenshot_2024-08-15_000825](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/a/aa0492147fa1f37de9122580fa832054f67cf612.png) ## Output ![Screenshot_2024-08-15_000811](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/c/0c932209f5178a829038cd4c60349aa51081138f.png) * * * For more information, see [Text Parser](https://www.make.com/en/help/tools/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](https://en.wikipedia.org/wiki/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](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions). > - For a tutorial on how to create regular expressions, we recommend the [RegexOne website](https://regexone.com/). > - For an easy, quick regex generator, try the [Regular Expressions generator](https://regex-generator.olafneumann.org/). > - For experimenting with regular expressions, we recommend the [regular expressions 101 website](https://regex101.com/). Just make sure to tick the ECMAScript (JavaScript) FLAVOR in the left panel. ## Module Export You can **copy** and **paste** this module export into your scenario. This will paste the modules shown in my screenshots above. 1. Copy the JSON code below by clicking the copy button when you mouseover the **top-right** of the code block ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/b/2b1b692880388420db5045bf51ef344e6698a816.png) 2. Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the canvas. 3. Click on each imported module and save it for validation. You may be prompted to remap some variables and connections. > **Click to Expand Module Export Code** > > **JSON** - Copy and Paste this directly in the scenario editor > > ```json > {"subflows":[{"flow":[{"id":116,"module":"regexp:Parser","version":1,"parameters":{"pattern":"Start:\\s+(?[\\w\\W]+?)\\s+Stop:\\s+(?[\\w\\W]+?)\\s+Continue:\\s+(?[\\w\\W]+?)\\s+$","global":false,"sensitive":true,"multiline":false,"singleline":false,"continueWhenNoRes":false},"mapper":{"text":"{{115.textResponse}}"},"metadata":{"designer":{"x":1381,"y":19},"parameters":[{"name":"pattern","type":"text","label":"Pattern","required":true},{"name":"global","type":"boolean","label":"Global match","required":true},{"name":"sensitive","type":"boolean","label":"Case sensitive","required":true},{"name":"multiline","type":"boolean","label":"Multiline","required":true},{"name":"singleline","type":"boolean","label":"Singleline","required":true},{"name":"continueWhenNoRes","type":"boolean","label":"Continue the execution of the route even if the module finds no matches","required":true}]}}]}],"metadata":{"version":1}} > > ``` Hope this helps! Let me know if there are any further questions or issues. — @samliew * * * P.S.: Did you know, [the concepts](https://community.make.com/t/make-academy-course-overview/29699) of about 70% of questions asked on this forum are already covered in the [Make Academy](https://academy.make.com). Investing some effort into it will save you lots of time and frustration using Make later! ---
**Author:** ![Tommyst](https://avatars.discourse-cdn.com/v4/letter/t/45deac/32.png) [@Tommyst](https://community.make.com/u/Tommyst)\ **Post date:** [August 15, 2024, 9:32am UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970/4 "2024-08-15T09:32:35Z")
Hi, Thanks for the responses! @samliew I used your example but I do not get any output. Any clue why? Input ```auto [ { "text": "Start:\n1. Visual Enhancement:\n - Incorporate more dynamic b-roll footage to showcase the product in use\n - Use close-up shots to highlight product details\n - Display ingredient measurements on-screen\n\n2. Content Improvement:\n - Add clickable timestamps in the video description for easy navigation\n - Implement a clear call-to-action (CTA) at the end of the video\n - Include a brief comparison with similar products in the market\n - Showcase common substitutions for dietary restrictions\n\n3. Accessibility:\n - Add English subtitles\n - Include a printable recipe card in the video description\n\nStop:\n1. Audio Issues:\n - Using generic stock music that doesn't match the brand's vibe\n - Using background music that overpowers the narrator's voice\n\n2. Content Problems:\n - Overloading the video with too many sponsorship mentions\n - Rushing through important product features or complex cooking techniques\n - Spending too much time on the unboxing process\n - Using technical jargon without explanation\n - Assuming viewers have advanced cooking knowledge\n\n3. Visual Distractions:\n - Filming in a cluttered background that distracts from the product\n\nContinue:\n1. Production Quality:\n - Maintaining high-quality video production and crisp audio\n - Maintaining high-quality food videography\n\n2. Presentation:\n - Engaging with viewers through witty and relatable commentary\n - Maintaining enthusiasm and energy throughout the video\n - Injecting humor and personality into the narration\n\n3. Content Delivery:\n - Collaborating with the influencer who has great on-screen presence\n - Demonstrating key features with hands-on examples\n - Providing useful cooking tips and tricks throughout the video\n\n4. Audience Engagement:\n - Responding to viewer comments for increased engagemen" } ] ``` ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [August 15, 2024, 3:23pm UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970/5 "2024-08-15T15:23:53Z")
Did you import the module I provided above? If you need further assistance, please provide the following: # 1. Relevant Screenshots Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at. You can upload images here using the Upload icon in the text editor: ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/0/20b53cdf28d223e85fc9654c350eadebd37f5d3c.png) # 2. Scenario Blueprint Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item. ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/2/2ff55ee04419049c127f183db2b3eebfbbbbfc64.png) # 3. Output Bundles of Modules Please provide the **output** bundles of the modules by running the scenario (or get from the [scenario History tab](https://www.make.com/en/help/scenarios/scenario-execution-history)), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”. ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/8/2876156ab3ea5bc9e40bbc0edfb9f025406b7c48.png) ### A. Upload as Text File Save each bundle contents in your text editor as a `bundle.txt` file, and upload it here into this discussion thread. ### B. Insert as Formatted Code Block If you are unable to upload files on this forum, alternatively you can paste the formatted bundles. These are the two ways to format text so that it won’t be modified by the forum: - **Method 1: Type code block manually** - **Method 2. Highlight and click the format button in the editor** Providing the input/output bundles will allow others to _replicate_ what is going on in the scenario even if they do not use the external service. Following these steps will allow others to assist you here. Thanks! ---
**Author:** ![Tommyst](https://avatars.discourse-cdn.com/v4/letter/t/45deac/32.png) [@Tommyst](https://community.make.com/u/Tommyst)\ **Post date:** [August 19, 2024, 7:07am UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970/6 "2024-08-19T07:07:14Z")
@samliew Yes, I imported it module. I created a new scenario just with the module to test it out again. No output (unless you have to create a module afterwards to get the output?) Hereby the scenerio: [blueprint.json](https://community.make.com/uploads/short-url/2kYqw126xXHUDH3tX2cJJfFTczI.json) (5.8 KB) Also a screenshot ![Schermafbeelding 2024-08-19 090511](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/0/10e2e3aa24b53c6fff999c7d040288b1edc31b52.png) ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [August 19, 2024, 7:21am UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970/7 "2024-08-19T07:21:51Z")
Hmm, looks like the Match pattern module might have a bug. Anyway, we can also use this alternate pattern: ```plaintext Start:\s+(?[\w\W]+?)\s+Stop:\s+(?[\w\W]+?)\s+Continue:\s+(?[\w\W]+) ``` ## Module Export You can **copy** and **paste** this module export into your scenario. This will paste the modules shown in my screenshots above. 1. Copy the JSON code below by clicking the copy button when you mouseover the **top-right** of the code block ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/b/2b1b692880388420db5045bf51ef344e6698a816.png) 2. Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the canvas. 3. Click on each imported module and save it for validation. You may be prompted to remap some variables and connections. > **Click to Expand Module Export Code** > > **JSON** - Copy and Paste this directly in the scenario editor > > ```json > {"subflows":[{"flow":[{"id":1,"module":"regexp:Parser","version":1,"parameters":{"pattern":"Start:\\s+(?[\\w\\W]+?)\\s+Stop:\\s+(?[\\w\\W]+?)\\s+Continue:\\s+(?[\\w\\W]+)","global":false,"sensitive":true,"multiline":false,"singleline":false,"continueWhenNoRes":false},"mapper":{"text":"Start:\n1. Visual Enhancement:\n - Incorporate more dynamic b-roll footage to showcase the product in use\n - Use close-up shots to highlight product details\n - Display ingredient measurements on-screen\n\n2. Content Improvement:\n - Add clickable timestamps in the video description for easy navigation\n - Implement a clear call-to-action (CTA) at the end of the video\n - Include a brief comparison with similar products in the market\n - Showcase common substitutions for dietary restrictions\n\n3. Accessibility:\n - Add English subtitles\n - Include a printable recipe card in the video description\n\nStop:\n1. Audio Issues:\n - Using generic stock music that doesn't match the brand's vibe\n - Using background music that overpowers the narrator's voice\n\n2. Content Problems:\n - Overloading the video with too many sponsorship mentions\n - Rushing through important product features or complex cooking techniques\n - Spending too much time on the unboxing process\n - Using technical jargon without explanation\n - Assuming viewers have advanced cooking knowledge\n\n3. Visual Distractions:\n - Filming in a cluttered background that distracts from the product\n\nContinue:\n1. Production Quality:\n - Maintaining high-quality video production and crisp audio\n - Maintaining high-quality food videography\n\n2. Presentation:\n - Engaging with viewers through witty and relatable commentary\n - Maintaining enthusiasm and energy throughout the video\n - Injecting humor and personality into the narration\n\n3. Content Delivery:\n - Collaborating with the influencer who has great on-screen presence\n - Demonstrating key features with hands-on examples\n - Providing useful cooking tips and tricks throughout the video\n\n4. Audience Engagement:\n - Responding to viewer comments for increased engagement\n\n​"},"metadata":{"designer":{"x":266,"y":6},"parameters":[{"name":"pattern","type":"text","label":"Pattern","required":true},{"name":"global","type":"boolean","label":"Global match","required":true},{"name":"sensitive","type":"boolean","label":"Case sensitive","required":true},{"name":"multiline","type":"boolean","label":"Multiline","required":true},{"name":"singleline","type":"boolean","label":"Singleline","required":true},{"name":"continueWhenNoRes","type":"boolean","label":"Continue the execution of the route even if the module finds no matches","required":true}]}}]}],"metadata":{"version":1}} > > ``` > > Note: Did you know you can reduce the size of blueprints and module export code like the above, using the [Make Blueprint Scrubber](https://community.make.com/t/free-tool-reduce-blueprint-module-export-by-removing-extra-details/50697)? Hope this helps! Let me know if there are any further questions or issues. — @samliew * * * P.S.: Did you know, [the concepts](https://community.make.com/t/make-academy-course-overview/29699) of about 70% of questions asked on this forum are already covered in the [Make Academy](https://academy.make.com). Investing some effort into it will save you lots of time and frustration using Make later! ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [August 19, 2024, 9:56am UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970/8 "2024-08-19T09:56:55Z")
Hi @Tommyst Please enable global match and multiline in the setting as follows: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/4/c46fb033f5819faf4d1fb3ee70c6308ca2b0d013.png) Output: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/2/62d6dab912e1df65a214a06064be2fdc58422e46.png) **Best regards,** **Msquare Automation** _Gold Partner of Make_ @Msquare_Automation ---
**Author:** ![Tommyst](https://avatars.discourse-cdn.com/v4/letter/t/45deac/32.png) [@Tommyst](https://community.make.com/u/Tommyst)\ **Post date:** [August 19, 2024, 11:26am UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970/9 "2024-08-19T11:26:23Z")
@samliew This one works wonderful, thank you! ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [August 19, 2024, 12:01pm UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970/10 "2024-08-19T12:01:17Z")
No problem, glad I could help! 1. If anyone has a new question in the future, please **start a new thread**. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely. 2. The [Make Community guidelines](https://community.make.com/t/make-community-the-ultimate-topic/11682) encourages users to try to **mark helpful replies as solutions** to help keep the Community organized. This marks the topic as solved, so that: - others can _save time_ when catching up with the latest activity here, and - allows others to _quickly jump to the solution_ if they come across the same problem To do this, simply **click the checkbox** at the bottom of the post that answers your question: ![Screenshot_2023-10-04_161049](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/d/5d9b26fbef0fd7385a34084f61cd5b9165786f42.png) 3. Don’t forget to like and **bookmark** this topic so you can get back to it easily in future! Hope this helps! Let me know if there are any further questions or issues. — @samliew * * * P.S.: Did you know, [the concepts](https://community.make.com/t/make-academy-course-overview/29699) of about 70% of questions asked on this forum are already covered in the [Make Academy](https://academy.make.com). Investing some effort into it will save you lots of time and frustration using Make later! ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [September 2, 2024, 11:35am UTC](https://community.make.com/t/how-to-do-a-double-split-text/50970/11 "2024-09-02T11:35:08Z")