Delimiters in MySQL

I often see people are using Delimiters. I tried myself to find out what are delimiters and what is their purpose. After 20 minutes of googling, I was not able to find an answer which satisfies me. So, my question is now: What are delimiters and when should I use them? 4 Answers 4

How to make the ‘cut’ command treat same sequental delimiters as one?

I’m trying to extract a certain (the fourth) field from the column-based, ‘space’-adjusted text stream. I’m trying to use the cut command in the following manner: cat text.txt | cut -d ” ” -f 4 Unfortunately, cut doesn’t treat several spaces as one delimiter. I could have piped through awk awk ‘{ printf $4; }’ … Read more

Split string with multiple delimiters in Python [duplicate]

This question already has answers here: Split Strings into words with multiple word boundary delimiters (31 answers) Closed 8 years ago. I found some answers online, but I have no experience with regular expressions, which I believe is what is needed here. I have a string that needs to be split by either a ‘;’ … Read more

How do I use a delimiter with Scanner.useDelimiter in Java?

The scanner can also use delimiters other than whitespace. Easy example from Scanner API: String input = “1 fish 2 fish red fish blue fish”; // \\s* means 0 or more repetitions of any whitespace character // fish is the pattern to find Scanner s = new Scanner(input).useDelimiter(“\\s*fish\\s*”); System.out.println(s.nextInt()); // prints: 1 System.out.println(s.nextInt()); // prints: 2 … Read more