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.
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
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
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.
- 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 select the ECMAScript (JavaScript) flavour in the left panel.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew