HTML text coming out fine and match pattern input is also fine this is text coming out (Detalle de la transacciónFecha:22/06/2024Hora:12:41:00Moneda:RD Monto:000.00Comercio:BRAVO SAN xxxxEstado:Transacción Aprobada
Balance disponible:
RD: 00000) everything works fine until match pattern output to sheets and this is the pattern expression I have been using Fecha:(\d{2}/\d{2}/\d{4})Moneda:([\w\s]+)Monto:([\d,]+.\d{2})Comercio:([\w\s]+)Estado:([\w\s]+)Balance disponible:\sRD:\s([\d,]+.\d{2}) don’t understand whats going on thank you in advance for you help
Bonjour @Claudel_Guerrier et bienvenue sur Make!
If your pattern is correct, here are a couple of errors I found:
- / is a special character so you need to escape it if you want it to match
- After “Fecha” there is “Hora” but you’re not matching it. If it’s important you should match it.
So try this:
.+Fecha:(\d{2}\/\d{2}\/\d{4})Hora:(\d{2}:\d{2}:\d{2})Moneda:([^\d:]+)Monto:([\d,]+\.\d{2})Comercio:([^\d:]+)Estado:([^\d:]+)Balance disponible:\s*RD:\s*([\d,]+(?:\.\d{2})?)
L