How to fix Text Parser?

Hi,
I have a question about Text Parser. It isn’t sending data to SeaTable.

I check the text parser output, there is no output there, so I think problem is here.

Here are my pattern and text, but I have no idea how to fix the issue.


By the way, here is my HTTP input and output.


1 Like

Welcome to the Make community!

When reaching out for assistance with extracting text, it would be super helpful if you could share the actual text you’re trying to match. Screenshots of text can be a bit tricky, so if you could copy and paste the text directly here, that would be awesome! It ensures we can run it against test patterns effectively. If there’s any sensitive info, feel free to change it to something fictional yet still valid by keeping the format intact.

Providing clear text examples saves time on both ends and helps us give you the best possible solution. Without proper examples, we might end up playing a guessing game, and nobody wants that as it is a waste of time! You are more likely to get a correct answer faster. So, help us help you by sharing those text snippets.

Please format the example text this way to preserve line breaks and special characters:

These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Hope this helps! Let me know if there are any further questions or issues.

@samliew

Hi Samliew,
Thank you for replying.

The content of HTTP

URL	https://openrouter.ai/api/v1/chat/completions
Request content	{
  "model": "gpt-3.5-turbo",
  "messages": [
    {
      "role": "user",
      "content": "Please create three 5-day travel itinerary suggestions for a group trip to New Zealand.\n\nEach itinerary must include:\n- Daily activities and dining plans\n- A detailed schedule including destinations and travel routes\n- Estimated expenses per day (rough estimates are fine)\n- Suggested accommodations (hotel names or types)\n- Contingency plans for bad weather or unexpected changes\n\nPlease present the itineraries clearly labeled as Plan A, Plan B, and Plan C."
    }
  ]
}

The output of HTTP

Output

* Bundle 1<small>Collection</small>

  * Status code

200

  * Headers<small>Array</small>

  * Cookie headers<small>Array</small>

  * Data<small>Collection</small>

  * fileSize

6350

The content of Text Parser

Plan A: North Island Exploration

Day 1: Explore Auckland
- Morning: Visit the Auckland War Memorial Museum
- Lunch: Try local cuisine at Depot Eatery & Oyster Bar
- Afternoon: Take a ferry to Waiheke Island for wine tasting
- Dinner: Dine at The Grove
- Accommodation: Rydges Auckland
- Estimated expenses: $150 per person
- Contingency plan: Visit indoor attractions in case of bad weather

Day 2: Rotorua Adventure
- Morning: Visit Te Puia and see Pohutu Geyser
- Lunch: Have a traditional Maori lunch at Tamaki Maori Village
- Afternoon: Explore Wai-O-Tapu Thermal Wonderland
- Dinner: Enjoy a dinner cruise on Lake Rotorua
- Accommodation: Millennium Hotel Rotorua
- Estimated expenses: $200 per person
- Contingency plan: Visit a nearby spa for relaxation if outdoor activities are hindered by bad weather

Day 3: Taupo and Tongariro National Park
- Morning: Take a cruise on Lake Taupo
- Lunch: Grab a bite at The Brantry
- Afternoon: Visit Tongariro National Park for hiking
- Dinner: Dine at Plateau Restaurant
- Accommodation: Suncourt Hotel & Conference Centre Taupo
- Estimated expenses: $180 per person
- Contingency plan: Explore local museums or go shopping in case of bad weather

Day 4: Wellington City Tour
- Morning: Visit Te Papa Museum
- Lunch: Try local food at Ortega Fish Shack
- Afternoon: Explore Wellington Botanic Garden
- Dinner: Dine at Shed 5
- Accommodation: QT Wellington
- Estimated expenses: $160 per person
- Contingency plan: Visit art galleries or attend cultural performances indoors if outdoor sightseeing is not feasible

Day 5: Return to Auckland
- Morning: Fly back to Auckland
- Lunch: Enjoy a meal at The Sugar Club overlooking the city
- Afternoon: Explore shopping at Queen Street
- Estimated expenses: $100 per person
- Contingency plan: Visit indoor markets or shopping centers if outdoor activities are limited


Plan B: South Island Adventure

Day 1: Arrival in Queenstown
- Afternoon: Visit Skyline Queenstown for panoramic views
- Dinner: Dine at Rata Dining
- Accommodation: Novotel Queenstown Lakeside
- Estimated expenses: $150 per person
- Contingency plan: Explore local wineries or take a scenic drive in case of bad weather

Day 2: Milford Sound
- Morning: Take a scenic bus tour to Milford Sound
- Lunch: Have a picnic at the waterfront
- Afternoon: Cruise through the fjords
- Dinner: Enjoy seafood at Fergburger
- Accommodation: Milford Sound Lodge
- Estimated expenses: $250 per person
- Contingency plan: Visit local museums or galleries if outdoor activities are not possible

Day 3: Wanaka and Mount Aspiring National Park
- Morning: Visit Puzzling World in Wanaka
- Lunch: Dine at Urban Grind Cafe
- Afternoon: Explore Mount Aspiring National Park
- Dinner: Enjoy a meal at The Big Fig
- Accommodation: Edgewater Hotel
- Estimated expenses: $180 per person
- Contingency plan: Visit local cafes or bookstores for indoor relaxation if outdoor exploration is hampered by bad weather

Day 4: Glacier Country
- Morning: Visit Fox Glacier and go hiking
- Lunch: Grab food at The Last Kitchen
- Afternoon: Explore Franz Josef Glacier
- Dinner: Dine at Alice May
- Accommodation: Scenic Hotel Franz Josef Glacier
- Estimated expenses: $200 per person
- Contingency plan: Visit local hot pools or spa for relaxation if outdoor activities are hindered by bad weather

Day 5: Return to Queenstown
- Morning: Drive back to Queenstown
- Lunch: Eat at Botswana Butchery
- Afternoon: Visit Arrowtown for shopping
- Estimated expenses: $100 per person
- Contingency plan: Explore local art galleries or attend cultural performances indoors if outdoor activities are limited


Plan C: North and South Island Highlights

Day 1: Arrival in Christchurch
- Afternoon: Visit the Canterbury Museum
- Dinner: Dine at Pescatore
- Accommodation: The George Christchurch
- Estimated expenses: $150 per person
- Contingency plan: Explore local cafes or bookstores if outdoor activities are hindered by bad weather

Day 2: Arthur's Pass National Park
- Morning: Take a scenic drive to Arthur's Pass
- Lunch: Have a meal at the Alpine Restaurant
- Afternoon: Explore the national park and go hiking
- Dinner: Enjoy dinner at Devils Punchbowl Cafe
- Accommodation: Wilderness Lodge Arthur's Pass
- Estimated expenses: $200 per person
- Contingency plan: Visit local museums or galleries if outdoor activities are not possible

Day 3: Marlborough Wine Region
- Morning: Drive to Marlborough region for wine tasting
- Lunch: Dine at Hans Herzog
- Afternoon: Visit vineyards for tasting
- Dinner: Enjoy a meal at Arbour
- Accommodation: Marlborough Vintners Hotel
- Estimated expenses: $180 per person
- Contingency plan: Visit a local market or shop for souvenirs in case of bad weather

Day 4: Abel Tasman National Park
- Morning: Visit Abel Tasman National Park for kayaking
- Lunch: Grab a meal at Hooked on Marahau
- Afternoon: Explore the coastal trails
- Dinner: Dine at The Park Cafe
- Accommodation: Parklands Marina Holiday Park
- Estimated expenses: $220 per person
- Contingency plan: Visit local spas or hot pools for relaxation if outdoor activities are limited due to bad weather

Day 5: Return to Christchurch
- Morning: Drive back to Christchurch
- Lunch: Eat at 27 Steps
- Afternoon: Explore Christchurch Botanic Gardens
- Estimated expenses: $100 per person
- Contingency plan: Visit local art galleries or attend cultural performances indoors if outdoor activities are not feasible.

There is no output in Text Parser.
Please help me find the problems. Thank you

1 Like

Welcome to the Make community!

You can use a Text Parser “Match Pattern” module with this Pattern (regular expression):

^Plan A:\s+(?<plan_a>[\w\W]+?)\s+Plan B:\s+(?<plan_b>[\w\W]+?)\s+Plan C:\s+(?<plan_c>[\w\W]+)

Proof https://regex101.com/r/grfMVZ/1

Important Info

  • :warning: Global match must be set to NO!

For more information, see the Text Parser page 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, 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.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

Thank you for your reply. I have resolved the Text Parser problem. Now I have some other issues with the voting process.

After adding Plan A, Plan B, and Plan C in SeaTable, I want to implement a voting process to detect which plan receives the highest number of votes. In Make, should I add a Webhook to trigger the voting process? If so, I can only find the Webhook response.

After the voting is submitted, should I use the following modules in this order: SeaTable - List Rows, Array Aggregator, Router, and then SeaTable - Create a Row?

1 Like

Sorry, I have no idea why Text Parser doesn’t work again. There is no output in Text Parser.
Please help me find the problems. Thank you

HTTP’s content

	{
  "messages": [
    {
      "role": "user",
      "content": "Please create three 5-day travel itinerary suggestions for a group trip to New Zealand.\n\nEach itinerary must include:\n- Daily activities and dining plans\n- A detailed schedule including destinations and travel routes\n- Estimated expenses per day (rough estimates are fine)\n- Suggested accommodations (hotel names or types)\n- Contingency plans for bad weather or unexpected changes\n\nPlease present the itineraries clearly labeled as Plan A, Plan B, and Plan C."
    }
  ]
}

Text Parser’s pattern

### Plan A: North Island Adventure

**Day 1: Auckland**
- **Morning:** Arrive in Auckland, check into hotel (e.g., Cordis, Auckland).
- **Afternoon:** Visit the Sky Tower and have lunch at Orbit 360° Dining.
- **Evening:** Explore Viaduct Harbour, dinner at The Sugar Club.
- **Accommodation:** Cordis, Auckland (~$250/night).
- **Estimated Expenses:** $300/person (activities, meals, transport).

**Day 2: Rotorua**
- **Morning:** Drive to Rotorua (~3 hours), visit Te Puia Geothermal Valley.
- **Afternoon:** Lunch at Eat Streat, explore Redwoods Treewalk.
- **Evening:** Dinner at Atticus Finch, stay at Pullman Rotorua (~$200/night).
- **Estimated Expenses:** $250/person.

**Day 3: Taupo**
- **Morning:** Drive to Taupo (~1 hour), visit Huka Falls.
- **Afternoon:** Lunch at The Bistro, cruise Lake Taupo.
- **Evening:** Dinner at Plateau, stay at Hilton Lake Taupo (~$220/night).
- **Estimated Expenses:** $280/person.

**Day 4: Waitomo Caves**
- **Morning:** Drive to Waitomo (~2 hours), explore glowworm caves.
- **Afternoon:** Lunch at HuHu Café, visit Ruakuri Cave.
- **Evening:** Drive back to Auckland (~2.5 hours), dinner at Depot Eatery.
- **Accommodation:** Cordis, Auckland.
- **Estimated Expenses:** $300/person.

**Day 5: Waiheke Island**
- **Morning:** Ferry to Waiheke Island, wine tasting at Mudbrick Vineyard.
- **Afternoon:** Lunch at The Oyster Inn, beach time.
- **Evening:** Return to Auckland, farewell dinner at Sidart.
- **Estimated Expenses:** $350/person.

**Contingency Plans:**
- If weather is bad, replace outdoor activities with Auckland Museum or indoor skydiving.
- If roads are closed, stay in Rotorua and visit Polynesian Spa.

---

### Plan B: South Island Highlights

**Day 1: Christchurch**
- **Morning:** Arrive in Christchurch, check into hotel (e.g., The George, Christchurch).
- **Afternoon:** Visit Botanic Gardens, lunch at Riverside Market.
- **Evening:** Dinner at Pescatore, stay at The George (~$300/night).
- **Estimated Expenses:** $320/person.

**Day 2: Franz Josef Glacier**
- **Morning:** Fly to Hokitika (~45 mins), drive to Franz Josef (~2 hours).
- **Afternoon:** Helicopter tour of Franz Josef Glacier (weather permitting).
- **Evening:** Dinner at The Landing, stay at Te Waonui Forest Retreat (~$350/night).
- **Estimated Expenses:** $600/person (helicopter tour included).

**Day 3: Queenstown**
- **Morning:** Drive to Queenstown (~5 hours), scenic stops.
- **Afternoon:** Lunch at Fergburger, explore Queenstown Gardens.
- **Evening:** Dinner at Rātā, stay at Hilton Queenstown Resort (~$400/night).
- **Estimated Expenses:** $450/person.

**Day 4: Milford Sound**
- **Morning:** Drive to Milford Sound (~4 hours), cruise.
- **Afternoon:** Lunch on cruise, return to Queenstown.
- **Evening:** Dinner at Jervois Steak House.
- **Accommodation:** Hilton Queenstown Resort.
- **Estimated Expenses:** $400/person.

**Day 5: Wanaka**
- **Morning:** Drive to Wanaka (~1 hour), visit #ThatWanakaTree.
- **Afternoon:** Lunch at Kika, hike Roy’s Peak (or alternative if weather is bad).
- **Evening:** Return to Queenstown, farewell dinner at Botswana Butchery.
- **Estimated Expenses:** $300/person.

**Contingency Plans:**
- If helicopter tour is canceled, visit Hot Pools or do a guided glacier hike.
- If Milford Sound road is closed, take a scenic flight or explore Glenorchy.

---

### Plan C: Mixed Island Experience

**Day 1: Auckland**
- **Morning:** Arrive in Auckland, check into hotel (e.g., Sofitel Auckland Viaduct Harbour).
- **Afternoon:** Visit Auckland War Memorial Museum, lunch at Federal Delicatessen.
- **Evening:** Dinner at Ostro, stay at Sofitel (~$300/night).
- **Estimated Expenses:** $350/person.

**Day 2: Wellington**
- **Morning:** Fly to Wellington (~1 hour), check into hotel (e.g., InterContinental Wellington).
- **Afternoon:** Visit Te Papa Museum, lunch at Logan Brown.
- **Evening:** Dinner at Ortega Fish Shack, stay at InterContinental (~$250/night).
- **Estimated Expenses:** $400/person.

**Day 3: Abel Tasman National Park**
- **Morning:** Fly to Nelson (~1 hour), drive to Abel Tasman (~1 hour).
- **Afternoon:** Kayak tour, lunch at The Park Café.
- **Evening:** Dinner at The Shed, stay at Awaroa Lodge (~$400/night).
- **Estimated Expenses:** $500/person.

**Day 4: Queenstown**
- **Morning:** Fly to Queenstown (~1.5 hours), check into hotel (e.g., Kamana Lakehouse).
- **Afternoon:** Lunch at Vudu Café, explore Queenstown.
- **Evening:** Dinner at Madam Woo, stay at Kamana Lakehouse (~$350/night).
- **Estimated Expenses:** $450/person.

**Day 5: Arrowtown**
- **Morning:** Drive to Arrowtown (~20 mins), explore historic town.
- **Afternoon:** Lunch at The Chop Shop, visit wineries.
- **Evening:** Return to Queenstown, farewell dinner at Rātā.
- **Estimated Expenses:** $300/person.

**Contingency Plans:**
- If kayaking is canceled, hike Abel Tasman Coast Track.
- If flights are delayed, explore Wellington’s Weta Workshop or Zealandia Sanctuary.
1 Like

Well that’s because the formatting has changed. Now you have three ### at the start of the headings.

You can update the pattern to

#*\s?Plan A:\s+(?<plan_a>[\w\W]+?)\s+#*\s?Plan B:\s+(?<plan_b>[\w\W]+?)\s+#*\s?Plan C:\s+(?<plan_c>[\w\W]+)

(copy-paste the above into the field, or type it exactly as shown)

Thank you for your reply. I succeed now!

1 Like

No problem, glad I could help you with “How to fix Text Parser?

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 as newer questions are displayed higher on the forum’s “new” page.

2. The Make Community guidelines 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

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

Sorry, my Text Parser isn’t working again. The input is empty, and there’s no output.

I checked the text, and it’s black color, which means there’s an error here. It shows a 429 status.

So I’m stuck at the Text Parser step and can’t send data to SeaTable.

1 Like

That’s a different issue, as it has nothing to do with the text parser now. Please mark this question as solved and create a new topic.

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 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

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

1 Like