This is based on a question previously asked which was deleted by the OP but it got me thinking and playing round with it, and I managed to do it without using a regex. The question is also a lesson…
I’m looking for the most straighforward way to figure out which string was inserted somewhere into a known other string. Here’s what I have to work with: I have an existing variable representing a particular string. For instance: var originalString…
I'm new. I'm working on a program that reads a bunch of docx documents. I get the document content from his XML with XPATH and xmldom. It gives me an array with every line of the document. The thing is,…
I have a rawurlencoded string and want to get everything from the beginning of a string until a rawurlencoded newline (%0A) or carriage return (%0D) or the whole string if neither are in the string. Example From these strings: First%20sentence.%0D%0ASecond%20Sentence.…
I have a 16-character, input string composed of hexadecimal characters. I need to isolate the last two characters, extend that string to four characters by repeating the two isolated characters, then replace them using an associative lookup/map. My sample input…
Let's say I have the following string: Would you like some tea? I want to replace only the second and third occurences of o with 0, so it becomes: Would y0u like s0me tea? Or maybe I would like to…
I have lines of text that look like this... My name is George 123123123 I like cheese and crackers 123456789 Each sentence can be any length but always ends with a space followed by 9 digits. I need the sentences…
The Issue: I am trying to select from multiple tables, Table A and B but this is mainly regarding the Only column I am choosing from Table B. The values in this column contain an Array of string. Aim is…
I have a table with a column of DR. ID #'s. I want all the rows that have a 2 in them. first_name dr_id joe 534 eric 267 allen 309 steven 125 gary 11 I have been searching for a…
I'm trying to extract only a certain portion of a string URL field in my query. I am doing this in Amazon Redshift. The query is very simple, essentially SELECT email_id, url FROM emailsends WHERE date > '01-01-2023' Pretty simple…