How to make a numbered list un-numbered?

Status: Closed · Asked by Pabblynaut on · 0 views

Pabblynaut — Question ·
I get some external data into Pabbly that looks similar to this:
  1. Bob
  2. Karen
  3. Rob
  4. Hans
  5. Robert
  6. Hans
  7. Elsa
  8. Peter
  9. Bjorn
  10. Nina

How can I get Pabbly to instead format it like this:
Bob
Karen
Rob
Hans
Robert
Hans
Elsa
Peter
Bjorn
Nina

Also, the number of lines varies, so one input could have 7 rows, and one could have 23.

Any help is appreciated!

Pabblymember11 — Reply ·

Hey @Pabblynaut

Currently, there is no dedicated action event available to convert the line item numbering to plain text in every new line.

Though you can try the "Text Formatter by Pabbly: Extract Pattern" action step to extract the desired data with the help of a certain regex which is available online.

Pabblynaut — Reply ·

Any solution that works is fine with me, but what kind of regex and where do I put it, I wonder :-)

Pabblymember11 — Reply ·
Any solution that works is fine with me, but what kind of regex and where do I put it, I wonder :)

You simply need to pass the regex in the Pattern fields which you can search online and pass the content from where you want to extract the data.
Pabblynaut — Reply ·

I don't know anything about Regex, but I managed to make this work inside Google Sheets by using this formula:

=REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(F3,"9. ",""),"8. ",""),"7. ",""),"6. ",""),"5. ",""),"4. ",""),"3. ",""),"2. ",""),"1. ",""),"10. ","")

But this only works inside Google Sheet, and not when I paste it into "Pattern" inside the Pabbly text formatter. Any advice on how to use it also there is highly appreciated!

Pabblymember11 — Reply ·

Hey @Pabblynaut

I am afraid to say that there is no other possibility to convert the numbered row into a non-numbered one with the Text Formatter action step.

shahidul islam pranto — Reply ·
Hey @Pabblynaut

Currently, there is no dedicated action event available to convert the line item numbering to plain text in every new line.

Though you can try the "Text Formatter by Pabbly: Extract Pattern" action step to extract the desired data with the help of a certain regex which is available online.


Can you please check if this regex work ^\d+\.\s

If works please let me know.

Hello,
Get customized Automations,
or get errors fixed.
Find me here: FlowMateo
Pabblynaut — Reply ·
Can you please check if this regex work ^\d+\.\s

If works please let me know.


That code gave only this as a result for the list in the original post:
1.

Back to all forum threads · Log in to reply