How Can I extract phrase after two dots with regex

Hi Makers

I have this outout from text aggregator

I need extract with regex the data show after metodo_pago: and moneda_pago: and monto_pagado:

and put it on a variable names

Metodo de pago:
Moneda de pago:
Monto pagado:

Thanks

Could you please copy the text in the output bundle here?

Format the text using three backticks ``` before and after, like this:

```
text goes here
```

2 Likes
is_vat_exempt: no
alg_cos_updated: yes
metodo_pago: Pago Móvil
moneda_pago: Bolívares
monto_pagado: 4521
_wcpdf_invoice_settings: [Collection]
_wcpdf_invoice_display_date: order_date
_wcpdf_invoice_creation_trigger: document_data
_wcpdf_invoice_date: 1695951212
_wcpdf_invoice_date_formatted: 2023-09-29T00:33:32.000Z
_wcpdf_invoice_number: ADEC-87
_wcpdf_invoice_number_data: [Collection]
_additional_wooccm0: 
_vicodemedia_add_field: EL PAGO

Welcome to the Make community!

You can use a Text Parser “Match Pattern” module with this regular expression pattern

metodo_pago: (?<metodo_de_pago>.+)\nmoneda_pago: (?<moneda_de_pago>.+)\nmonto_pagado: (?<monto_pagado>.+)

Output:
Screenshot_2023-10-05_101029

For more information, see Text Parser 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 (aka regex or regexp), 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!

2 Likes

Thank you so much for your help

1 Like