utilizing regular expressions to retrieve data

Question

utilizing regular expressions to retrieve data

I am facing a challenge in extracting both the product name and price from the given data. The desired result, which includes both the product name and price, is not on the same line. How can I include the line that comes before the price as well?

Here is a sample structure of a product from a receipt:

RETAIL
UPRICE QTY TOTAL
ILLUSTRATION BOARD 15X20 (1/4 SIZE ) BY
1276
12.50 1.0 12.50
MONGOL PENCIL 1,2,3 PC
434
6.50 1.0 6.50
MS 300 (MGK) PERMANENT MARKER
1470
3.75 1.0 3.75
HBW White Glue 40 grans
1690
10.00 1.0 10.00
COLOR PEN 8 COLORS (VARIOUS BRAND)
1930
16.50 1.0 16.50
KS /CREATION CONSTRUCTION PAPER (105)
3503
23.00 1.0 23.00

I have attempted to use the following regex to solve the issue, but the result only displays the price without including the product name. The 'result' variable contains data similar to the sample provided above.

TypeScript file code snippet:

   this.result = {
      merchant: text.split("\n")[0],
      product: text.split("\n").filter(t => t.match(/([\w\s]+)(\d+\.\d{2})/)
   };

HTML file code snippet:

 <ion-card *ngIf="result">
    <ion-card-content>
      <p>Results:</p>
      <ion-item>
        <ion-label>Merchant</ion-label>
        <ion-input type="text" value="{{result.merchant}}"></ion-input>
      </ion-item>
      <ion-item *ngFor="let product of result.product; let i = index">
        <ion-label>Product #{{i+1}}</ion-label>
        <ion-input type="text" value="{{product}}"></ion-input>
      </ion-item>
    </ion-card-content>
  </ion-card>

regex typescript

Answer 1

Answer №1

If you want to extract the price from a text by capturing any character followed by a newline and then the price itself, you can use the following regex pattern:

(.+\n.+\n)(\d+\.\d{1,2})

Check out the Regex demo here

Here's the breakdown of the regex pattern:

(.+\n.+\n) This part captures 2 sequences of 1 or more characters followed by a newline
(\d+\.\d{1,2}) This part captures the price format with digits before and after the dot

You can test this regex pattern on a sample text like the one below:

const regex = /(.+\n.+\n)(\d+\.\d{1,2})/g;
let products = [];

// Sample text for testing
let str = `RETAIL
UPRICE QTY TOTAL
ILLUSTRATION BOARD 15X20 (1/4 SIZE ) BY
1276
12.50 1.0 12.50
MONGOL PENCIL 1,2,3 PC
434
6.50 1.0 6.50
MS 300 (MGK) PERMANENT MARKER
1470
3.75 1.0 3.75
HBW White Glue 40 grans
1690
10.00 1.0 10.00
COLOR PEN 8 COLORS (VARIOUS BRAND)
1930
16.50 1.0 16.50
KS /CREATION CONSTRUCTION PAPER (105)
3503
23.00 1.0 23.00`;

while ((m = regex.exec(str)) !== null) {
    if (m.index === regex.lastIndex) {
        regex.lastIndex++;
    }
    products.push([m[1].replace(/\n/g, ''), m[2]]);
}

console.log(products);

Answer 2

If you want to extract the price from a text by capturing any character followed by a newline and then the price itself, you can use the following regex pattern:

(.+\n.+\n)(\d+\.\d{1,2})

Check out the Regex demo here

Here's the breakdown of the regex pattern:

(.+\n.+\n) This part captures 2 sequences of 1 or more characters followed by a newline
(\d+\.\d{1,2}) This part captures the price format with digits before and after the dot

You can test this regex pattern on a sample text like the one below:

const regex = /(.+\n.+\n)(\d+\.\d{1,2})/g;
let products = [];

// Sample text for testing
let str = `RETAIL
UPRICE QTY TOTAL
ILLUSTRATION BOARD 15X20 (1/4 SIZE ) BY
1276
12.50 1.0 12.50
MONGOL PENCIL 1,2,3 PC
434
6.50 1.0 6.50
MS 300 (MGK) PERMANENT MARKER
1470
3.75 1.0 3.75
HBW White Glue 40 grans
1690
10.00 1.0 10.00
COLOR PEN 8 COLORS (VARIOUS BRAND)
1930
16.50 1.0 16.50
KS /CREATION CONSTRUCTION PAPER (105)
3503
23.00 1.0 23.00`;

while ((m = regex.exec(str)) !== null) {
    if (m.index === regex.lastIndex) {
        regex.lastIndex++;
    }
    products.push([m[1].replace(/\n/g, ''), m[2]]);
}

console.log(products);

utilizing regular expressions to retrieve data

Answer №1

Similar questions

Typescript's ability to have Enums with dynamic keys

What is the best way to modify the disabled attribute?

Error: Model attribute missing in Adonis JS v5 relationship

Executing a component method from a service class in Angular

Guide on dynamically applying a CSS rule to an HTML element using programming techniques

Troubleshooting problem with TypeScript observables in Angular 5

The attempt to upload a file in Angular was unsuccessful

The count of bits is not producing the anticipated result

Array of dynamically typed objects in Typescript

Why does React redirect me to the main page after refreshing the page, even though the user is authenticated in a private route?

Creating a JSX syntax for a simulated component and ensuring it is fully typed with TypeScript

Issue encountered during frida-il2cpp-bridge module installation

Exploring Angular Unit Testing: A Beginner's Guide to Running a Simple Test

After each save, gulp-typescript is emitting errors, however, it works without any issues upon subsequent saves

Can you explain the significance of this code snippet 'true <=> false'?

Tips on informing the TS compiler that the value returned by a custom function is not null

Tips on personalizing the FirebaseUI- Web theme

Module 'serviceAccountKey.json' could not be located

Why is it advantageous to use Observable as the type for Angular 5 component variables?

The dramatist strategically positioning the cursor at the conclusion of an input field