I want to add values in Column C with the conditions that Column B = 0, AND Column A = "a" OR "b" From what I've searched, this would work, but only in excel:
Simulator: https://www.jsonschemavalidator.net/s/L3FmJnoE It looks like json schema validation does not check for regex patterns for integers. How to validate f
I read data from csv data_frame2 = pd.read_csv("search query.csv") print(data_frame2['id'][0]') is HYPERLINK("https://something.com/resource/1308610617","130861
I'm trying to write a regex that will strip out $ and , from a value and not match at all if there are any other non-numerics. $100 -> 100 $12,203.00 -> 1
Recently I'm experimenting with logstach and Kibana on top of elastic over (web-)server logs. I tried to extract some attack signature like XSS & SQL inject
I am very new to regex, and I want to extract some data from API responses. I have a response from my API call: { server: 'nginx/1.21.0', date: 'Mon, 25 Apr
I am writing a program for a calendar and in a specific function, I have to add/delete a calendar event. In my delete_event function, I am taking the already gi
Question Perform a search and replace on the sentence using the arguments provided and return the new sentence. First argument is the sentence to perform the
Using regular expressions is a little bit tricky especially in Node.js applications. Because It can cause REDOS attacks. I thought that maybe running all regula
I'm trying to grep strings that end in a dash in R, but having trouble. I've worked out how to grep strings ending in any punctuation mark, maybe not the best w
I need to find the string in brackets that matches some specific string and all values in the string. Right not I am getting values from a position where the st
How can I check if the username is in the right format? For example in this format: Test#1234 And not check more than 4 numbers after #. How can I do that?
Here I want to post my Answer of the above question because the same issue I was facing but didn't find complete answer. After doing R&D, Mix and merge vari
Say you have the following text foobar bar And you want the following as your desired output foobar foobar You could use the following regex s/\v(foo)@<!(b
I'm trying to search a string for some numbers and insert a new line before each, not including the first one. I don't seem to be able to use the traditional r
I'm new to hiveSQL and I'm trying to extract a value from the column col_a from the data df which is in this format: \\\"id\\\":\\\"101_12345\\\" I only need to
I just got Black and Pre-Commit set up for my Django repository. I used the default config for Black from the tutorial I followed and it's been working great,
I am trying to figure out how to extract customer ID from string that looks loke this: {"param":"success","value":"10","level":"0","error_code":"101","customer
In an open text entry question on Qualtrics, I am adding a validation using regex ("match regex" condition). I would like to only accept answers that include at
I need to validate US phone number XXX-XXX-XXXX using vee-validate with this basic regex: (?:\d{3}-)\d{3}-\d{4}. The regex works fine by itself, but does not w