How can I concatenate the result obtained from a text parser (match pattern) to write the result in a Google Sheets cell?

How To
1

Hello everyone,

I want to extract the URLs of images from a web page and add them to a Google Sheets cell in the format ‘url1,url2,url3…’.

I use HTTP to extract the HTML from the page and then use a text parser ‘match pattern’ to find the URLs of the images I want.

My problem: When I send the result from the text parser to another Google Sheet, the results are spread across multiple lines.

What is the best solution for this?

here my workflow

pour-make
pour-make1094×323 12.1 KB

Thank you all.

2

Hey @Seuachita

welcome to the make community

You can use the text aggregator here to gather all the text into one bundle.

image

I hope this will help you.

3 Likes
3

Welcome to the Make community!

Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.

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 —

General

Help Center Basics

Articles & Videos

samliew – request private consultation

Join the Make unofficial Discord server!

2 Likes
4

Hello everyone, thank you all. This helped me find “Table Aggregator,” which is perfect for my case.

pour-make-2
pour-make-2921×506 10.1 KB

Thanks again.