Regex not working correctly in JavaScript sorting function

Question

I've a problem with a sorting JS plugin for my tables. It's named "Sortable". When you checkout the documentation of this plugin you can find out that you can define your custom sorting types:

https://github.hubspot.com/sortable/api/options/

So I've defined my custom filter and named it price:

sortable.setupTypes([{
    name: "numeric", defaultSortDirection: "descending", match: function (a) {
        return a.match(d)
    }, comparator: function (a) {
        return parseFloat(a.replace(/[^0-9.-]/g, ""), 10) || 0
    }
}]);

It works particular great but when I add a refund price it works not correctly:

My normal price: 2.372,11 €
My refund price: ~~765,38 €~~0,00 €

When the function extracts the refund price, the outcome looks like this: 765,38 € 0,00 € but I must look like this 000.

So I've setup my regex this way /[^0-9-]/g but it's not filtering the del price. Logically the regex needs to get modified the way that it starts after the first €_ or something like this.

Is this possible? If yes, how?

AP inc. · Accepted Answer · 2019-03-11 14:29:01Z

2

I would go with something like this

a.replace(/^.*?([0-9]+),([0-9]+)\s*€\s*$/, "$1$2")

https://regex101.com/r/FHOYja/1

answered Mar 11, 2019 at 14:29

AP inc.

15611 bronze badges

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

3 Comments

Mr. Jo Over a year ago

Looks good but enter this here like a value: 2.076,14 € seems to be an issue.

Chrᴉz remembers Monica Over a year ago

@Mr.Jo replace ([0-9]+),([0-9]+)with ([0-9]*).?([0-9]+),([0-9]+) and your replace with $1$2$3. This includes a optional sumber block with a following dot at the start of the price => ^.*?([0-9]*).?([0-9]+),([0-9]+)\s*€\s*$

Mr. Jo Over a year ago

Thanks guys for your help! Works great :o

wbarton · Accepted Answer · 2019-03-11 14:21:34Z

0

A regex to grab everything after the first "€ " would be (?<=€ ).*$ example on regex101:https://regex101.com/r/pULCel/1

answered Mar 11, 2019 at 14:21

wbarton

1366 bronze badges

1 Comment

VLAZ Over a year ago

Regex101 reports a pattern error. That's because lookbehinds are not officially supported - AFAIK, Chrome has them but not all browsers.

Collectives™ on Stack Overflow

Regex not working correctly in JavaScript sorting function

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related