Fetching multiple itemlist using regex

Question

The below code is used to fetch item list from order_details

Output expected multiple items

Below code works fine for 1 ITEM but the 2nd item/multiple items are not fetched using the below regex.

I want it to be dynamic so that it should work for any number of the item found in the matching pattern.

 var order_details = "Detalle\n Unidad\n Cantidad\n Total\n     Triple Insomnio Especial   S/37 1  S/37.90  Insomnio Especial  S/21 2 S/23.12 *Tipo de papa:*  - Papa Amarilla Tumbay S/0.00\n     *Adicional :*  - Quesp cheddar S/0.00\n     *Agrega Bebida:*  - Fanta 400 ml S/0.00\n     *Salsas:*  - Mayonesa S/0.00\n - Ketchup S/0.00\n - Golf S/0.00\n - Guacamole S/0.00\n - Ají S/0.00\n - Tártara S/0.00\n - Mayo-aji S/0.00\n      "     ;
    
    var rx = /\s+(.*?)\s+(S\/.*?)\s+(\d+)\s+(S\/.*?)\s+([\s\S]*)/
    
    var m = rx.exec(order_details)
    
    var Detalle = m[1]
    var Unidad = m[2]
    var Cantidad = m[3]
    var Total = m[4]
    var Other = m[5]
    
    console.log(Detalle)
    console.log(Unidad)
    console.log(Cantidad)
    console.log(Total)
    console.log(Other)

your string is not proper, new lines should be for each row right? why did new line came at "Insomnio Especial \nS/212" ? — Tilak Putta
– Tilak Putta, Commented Sep 9, 2018 at 14:16
string comes from the web so I have no control over it that's why I have to write a regex which will work for the case, even if we remove \n from Insomnio Especial \nS/212 the above regex doesnt work @TilakPutta — art
– art, Commented Sep 9, 2018 at 14:19
regex wont work if we remove \n .. but you can split once by \n and then by \t to get it as rows and columns — Tilak Putta
– Tilak Putta, Commented Sep 9, 2018 at 14:21

The Scientific Method · Accepted Answer · 2018-09-10 05:57:30Z

1

You may try this one,

(?:\s+?).+?\s+(S\/\d+)\s+(\d+)\s+(S\/\d+\.\d+)

try demo here

edited Sep 10, 2018 at 5:57

answered Sep 9, 2018 at 18:41

The Scientific Method

2,4362 gold badges17 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

art Over a year ago

output id different as expected only 2 items should have been fetched , like in the output image @The Scientific Method

The Scientific Method Over a year ago

@art check it now, it is fetching two rows only.

Collectives™ on Stack Overflow

Fetching multiple itemlist using regex

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related