Since | is a valid regex expression, it needs to be escaped with \\| or put in square brackets: [|]. You can do this: awk -F’ \\|\\|\\| ‘ ‘{print $1}’ file Some other variations that work as well: awk -F’ [|][|][|] ‘ ‘{print “$1”}’ file awk -F’ [|]{3} ‘ ‘{print “$1”}’ file awk -F’ \\|{3} … Read more
split_part() does what you want in one step: SELECT split_part(col, ‘,’, 1) AS col1 , split_part(col, ‘,’, 2) AS col2 , split_part(col, ‘,’, 3) AS col3 , split_part(col, ‘,’, 4) AS col4 FROM tbl; Add as many lines as you have items in col (the possible maximum). Columns exceeding data items will be empty strings … Read more
There is no need to set the delimiter by breaking it up in pieces like you have done. Here is a complete program you can compile and run: import java.util.Arrays; public class SplitExample { public static final String PLAYER = “1||1||Abdul-Jabbar||Karim||1996||1974”; public static void main(String[] args) { String[] data = PLAYER.split(“\\|\\|”); System.out.println(Arrays.toString(data)); } } If … Read more
Therefore, I would like to separate the string by the furthest delimiter. I know this is an old question, but this is a simple requirement for which SUBSTR and INSTR would suffice. REGEXP are still slower and CPU intensive operations than the old subtsr and instr functions. SQL> WITH DATA AS 2 ( SELECT ‘F/P/O’ … Read more
Just do not give any delimeter? >>> a=”test result” >>> a.split() [‘test’, ‘result’]
Raw string literals let you specify an almost arbitrary* delimiter: //choose ### as the delimiter so only )###” ends the string R”###( Some Text)” )###”; *The exact rules are: “any member of the basic source character set except: space, the left parenthesis (, the right parenthesis ), the backslash \, and the control characters representing … Read more
It is possible to change the inter-word delimiter for cin or any other std::istream, using std::ios_base::imbue to add a custom ctype facet. If you are reading a file in the style of /etc/passwd, the following program will read each :-delimited word separately. #include <locale> #include <iostream> struct colon_is_space : std::ctype<char> { colon_is_space() : std::ctype<char>(get_table()) {} … Read more
If you can re-create or parse your input data, you can specify an escape character for the CREATE TABLE: ROW FORMAT DELIMITED FIELDS TERMINATED BY “,” ESCAPED BY ‘\\’; Will accept this line as 4 fields 1,some text\, with comma in it,123,more text
The csv module seems to recommend using the csv sniffer for this problem. They give the following example, which I’ve adapted for your case. with open(‘example.csv’, ‘rb’) as csvfile: # python 3: ‘r’,newline=”” dialect = csv.Sniffer().sniff(csvfile.read(1024), delimiters=”;,”) csvfile.seek(0) reader = csv.reader(csvfile, dialect) # … process CSV file contents here … Let’s try it out. [9:13am][wlynch@watermelon … Read more
Something like this? var dict = text.Split(new[] {‘;’}, StringSplitOptions.RemoveEmptyEntries) .Select(part => part.Split(‘=’)) .ToDictionary(split => split[0], split => split[1]); Of course, this will fail if the assumptions aren’t met. For example, an IndexOutOfRangeException could be thrown if the text isn’t in the right format and an ArgumentException will be thrown if there are duplicate keys. Each … Read more