I have an Athena table with a string column which looks like: +-------------------+ | employee_size | +-------------------+ | GREATER THAN 2000 | +-------------------+ | 500 - 999 | +-------------------+ | 28.00 | +-------------------+ | unknown | +-------------------+ | 563 |…
I'm trying to write regular expression for the next pharse "AE/ME 5101" or "AWE/ME 5101" or or "any text or no text AWE/MERL 5101 any text or no text" I need to catch "AWE/MERL 5101" or "AE/ME 5101" or "AWE/ME…
I have a string containing html that is outputted from Wix Studio. I am trying to manipulate and put back within the original tags. So far I have managed to strip the tags and manipulate the string (wrapping each letter…
I have the regex below ^(?=.*[A-Z])(?=.*[a-z])(?=.*d)(?=.*W)[A-Za-z0-9W][x00-x7F]{8,}$ am expecting from the regex the below not less than 8 in length at least one capital letter at least one small letter at least one digit at least one non-alphanumeric symbol all characters…
I have a yaml file and I have to change some letters to uppercase. F.e. here I want to change only the words after "value:" As is: field_map: assess_1: type: column value: assess_1 assess_10: type: column value: assess_10 As to…
I have the path ../dir1/dir2/dir3/filename.txt and want to extract just filename between the final and . using regex. The file extension will also not always be .txt. Currently I am doing (?<=/).+(?=.) but selects from the first , including the…
I get a response from the backend as text in which I have to find a match for numbers which is minimum 16 digits in length. Let's say I have data something like this: {"BIG_INT": 123456789012345675,"BIG_INT_ARRAY_SINGLE": [123456789012345676],"BIG_INT_ARRAY_MULTIPLE": [123456789012345661,12345678901234562,12345678901234563,12345678901234564],"STRING_BIG_INT_ARRAY": "[12345678901234567,12345678901234567, 12345678901234567,12345678901234567]","STRING_BIG_INT":"12345678901234567","BIG_INT_FLOATING_DECIMAL":…
I am trying to make a validation for URL which is accept only 'https' and reject 'http'. I am using form_field_validator for it and I probably understand how to use it. However, I have no idea how to write the…
I have a if statement that checks if the user left the input empty and did not enter the correct pattern (which is essentially a student number). However, it seems when I input a random mash of words and number,…
I have several functions across different files, and they usually are like this: "prefix":"functionName (...)", like pub:isInt. And I wanted to put the first letter of the function as capital, so I did this regex to change to pub:IsInt (this…