I have this file that I copy/pasted into Excel. Sometimes the rows look like this: 귀신 신 (spirit, ghost) And I have to split by the character ( But som...

I am trying to concatenate the range A2:A200, separated by " OR ", but have the VBA stop once it reaches a blank cell. How do I adjust the VBA I am us...

I have a data frame with a column that potentially can be filled with 3 options (a,b, and/or c) with a comma delimiter. import pandas as pd df = pd.D...

I want to split query string which might have multiple delimiter. My strings are, book_id=123&start_date>=2023-09-12&end_date We have 6 delimiters, =,...

How to read file names from a file and store file names and contents to another file with '|' as delimiter. I have a file called Filenames.txt, which ...

I have a long text, about 10k characters that contain many sections. I need to chunk the text based on these sections. Every chunk should contain a se...

I have a text like this: 'a:b:c:d' I would like to ignore the last part of the split text, my result should be 'a:b:c' I tried split_part on it, but i...

I have a tibble, e.g. a value 1 201.1, 202 (abc) 203, 204 2 301 / 302.22 def, 303 Now I would like to get a da...

When Thymeleaf tries to parse a JS file containing a given RegExp like the following one it will fail: new RegExp("^[+]*[(]?\\d{1,4}[)]?[-\\s\./\\d]*$...

I want to avoid the issue of "new line character" that is generated by pressing the enter key when I enter a number for nextInt(), since nextLine() wi...

My input is 'Apple-Pie-1024' Desired output is 'Apple-Pie' I can do this using python rsplit() method as s.rsplit('-',1)[0].strip() which will give me...

I just want my loop to run, but when I try to do it, it fails. It has to increment each letter by an increasing amount based on how many iterations ha...

I have a table with a column that looks like the below: +----------------+ | name | +----------------+ | Tim^*^Abas | | Roy^*^Techs |...

My problem is I'm unable to pass 2nd parameter to str_getcsv function. $rows = array_map('str_getcsv', file($filePath_product_names_t), [";"]); ...

This is no duplicate of another question, as I do not want to drop the rows. The accepted answer in the aforementioned post is very different from thi...

I have text like this: word1 word2 word3 word4 There may be more than one space between a pair of words and I want to get some columns of words f...

code s='id;some text here with possible ; inside' IFS=';' read -r id string "$s" echo "$id" error restore.sh: 2: restore.sh: Syntax error: redirection...

I have a comma separated file with many lines similar to one below. Sachin,,M,"Maths,Science,English",Need to improve in these subjects. Quotes is ...

A csv (comma delimited) file, where lines have an extra trailing delimiter, seems to confuse pandas.read_csv. (The data file is [1]) It treats the ex...

I would like to copy the contents of a vector to one long string with a custom delimiter. So far, I've tried: // .h string getLabeledPointsString(con...

What are the semantics behind usage of the words "delimiter," "terminator," and "separator"? For example, I believe that a terminator would occur aft...

Is there any way to specify a field delimiter for more spaces with the cut command? (like " "+) ? For example: In the following string, I like to reac...

I have several strings that I need to parse. The string is supposed to be delimited with a caret character, however, if the maximum number of allowed ...

DELIMITER // What is the of use of it? ...

Modifed. DROP FUNCTION IF EXISTS PersonName; DELIMITER |; CREATE FUNCTION PersonName( personID SMALLINT ) RETURNS CHAR(20) BEGIN DECLARE pname CHA...