Home / Questions / 101642
Accepted
Norak
Asked: 2020-09-13 03:21:41 +0800 CST 2020-09-13 03:21:41 +0800 CST

How to include optional text alternatives in a regular expression

  • 772

I am using a JSON to validate data from a series of invoices. First of all, I have removed all the spaces from the data, and then I validate the fields according to the definition found in a JSON. It has served me perfectly, but now I find myself with a small problem:

If you wanted to validate the text:

Total electricity €54.60

I did it this way:

"regexp": {
          "productType": "Electricidad",
          "electricityTotal": "Totalelectricidad([\\d\\,\\.]+)€"
}

But I want to validate invoices in Basque, Catalan...etc. I don't know how to make it filter the following text:

Argindarra guztira / Total electricity €54.60

My problem is how to make it include the slash "/" and take it as part of the string, since it is the only thing that changes in the expression.

I want the character to be recognized "/"as part of the string, for example:

"regexp": {
          "productType": "Electricidad",
          "electricityTotal": "Argindarraguztira/Totalelectricidad([\\d\\,\\.]+)€"
}

In this case it gives me an error, because I need to include something in the expression so that it admits the "/".

javascript

1 Answers

  1. Best Answer

    Your expression may work but may fail.

    For example, with your part of [\\d\\,\\.]+you are telling him to take 1 or more of those elements but not all combinations are valid.

    That's why I would put:

    \d+(?:[,.]\d+)?€

    which searches for numbers followed by the possibility of a semicolon and more numbers.

    Ex:

    • Valid: 5555€, 55.55€,5,55555€
    • Invalid: 55,.55€, 55,€,.55€

    To accept the possibility of having another language in front of "Total electricity" you can put an optional group (?:Argindarra guztira \/ )?leaving everything:

    ^(?:Argindarra guztira \/ )?Total electricidad \d+(?:[,.]\d+)?€$

    If you would like to add other languages ​​you can add more using the "|"(or) operator and the other languages.

    (?:(?:Argindarra guztira|Total electricitat) \/ )?


    comprobar();

function comprobar() {
  var elem = document.getElementById("prueba");
  var p = document.getElementById("resultado");
  var pattern = /^(?:(?:Argindarra guztira|Total electricitat) \/ )?Total electricidad \d+(?:[,.]\d+)?€$/;

  if (pattern.test(elem.value.trim()) || elem.value.trim() == "") {

    p.innerHTML = "ok";

  } else {

    p.innerHTML = "nok";

  }
}

$('input').bind('input propertychange', function() {
  comprobar();
});
    input{

   width:100%
}
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<input type="text" id="prueba" value="Argindarra guztira / Total electricidad 555,5€">

<p id="resultado"></p>

    • 3