I can’t seem to find a simple way (5 steps or less) to extract the content out of a numbered list. For example. passive income money income business wealthI want to be able to extract the words and remove the numbers; then put them as separate fields so I can map it to individual sections in another step.

Can I extract words from a numbered list in Google Sheets when a new row is added?

I can’t seem to find a simple way (5 steps or less) to extract the content out of a numbered list.

For example.

passive income
money
income
business
wealth

I want to be able to extract the words and remove the numbers; then put them as separate fields so I can map it to individual sections in another step.

Page 1 / 1

Hi there @Tina Lopez,

Have you considered using the Utilities in Formatter function, specifically the "Line-item to Text" feature? It might help you separate the fields in the desired way.

(view larger)

If that doesn’t work, could you please share a screenshot of your Zap setup? This will give us more context. Please don't include personal information in the screenshot, or be sure blur out any personal information.

Please keep us posted!

Hi,

I’ve tried that and it doesn’t seem to work:

I’ve even tried separating via “.” with split text but that doesn’t work. I would have to create more actions to get rid of the numbers - henceforth looking for an easier solution.

This is how it looks like with splitting the text by”.”

Hi @Tina Lopez,

Thanks for the additional screenshots and details.

Based on the screenshot, it seems that we can make use of the Text in Formatter - Split Text function. Kindly leave the "Separator" field empty to use the default value. Then, in the "Segment Index" field, select "All as (Separate Fields)". Like so:

(view larger)