CODEWITHSUNDEEP
regexescapingsparqlquotation-marks
linous
linous

Reputation: 263

sparql regex quotation marks and dash

I have a literal string like "10-16.7" . I want to filter it and take the first number. In this example, I want to filter only the number 10 .

I think this is the correct regex: (["'])(.*-*)-.* but when I try it on my query it doesn't recognize the ["'] pattern. So I found this Escape sequences in strings but when I try FILTER regex(?mystring, "(\")(.*-*)-.*") } it doesn't give an error but it doesn't catch anything either. ( My dataset contains values like "50-58", "9.4-13", "72-85", etc.)

Upvotes: 0

Views: 1101

Answers (1)

evsheino
evsheino

Reputation: 2287

If you have a number followed by a dash followed by anything, I would use the following regex (assuming you don't need to worry about the numbers being valid, as this matches strings like "00323..23....3.-2", for example):

^([0-9.]+)-.*

I'm assuming the quotation marks are not actually part of the string. If they are, just add \": ^\"([0-9.]+)-.*

To extract the number, you need to BIND it to a variable, like so:

FILTER(REGEX(?test, "^[0-9.]+-"))
BIND(REPLACE(?mystring, "^([0-9.]+)-.*", "$1") AS ?number)

Here I get the number by replacing the string with the first capture group ($1), which matches the number, and bind the result to a variable called ?number.

Upvotes: 1

Related Questions