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
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: … Read more
Unfortunately the JSON specification does not allow a trailing comma. There are a few browsers that will allow it, but generally you need to worry about all browsers. In general I try turn the problem around, and add the comma before the actual value, so you end up with code that looks like this: s.append(“[“); … 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
Delimiters other than the default ; are typically used when defining functions, stored procedures, and triggers wherein you must define multiple statements. You define a different delimiter like $$ which is used to define the end of the entire procedure, but inside it, individual statements are each terminated by ;. That way, when the code … Read more
Luckily, Python has this built-in 🙂 import re re.split(‘; |, ‘,str) Update:Following your comment: >>> a=”Beautiful, is; better*than\nugly” >>> import re >>> re.split(‘; |, |\*|\n’,a) [‘Beautiful’, ‘is’, ‘better’, ‘than’, ‘ugly’]
Single quotes are escaped by doubling them up, just as you’ve shown us in your example. The following SQL illustrates this functionality. I tested it on SQL Server 2008: DECLARE @my_table TABLE ( [value] VARCHAR(200) ) INSERT INTO @my_table VALUES (‘hi, my name”s tim.’) SELECT * FROM @my_table Results value ================== hi, my name’s tim.
You can use an alternative regex delimiter as a search pattern by backslashing it: sed ‘\,some/path,d’ And just use it as is for the s command: sed ‘s,some/path,other/path,’ You probably want to protect other metacharacters, though; this is a good place to use Perl and quotemeta, or equivalents in other scripting languages. From man sed: … Read more
If you can create a numbers table, that contains numbers from 1 to the maximum fields to split, you could use a solution like this: select tablename.id, SUBSTRING_INDEX(SUBSTRING_INDEX(tablename.name, ‘,’, numbers.n), ‘,’, -1) name from numbers inner join tablename on CHAR_LENGTH(tablename.name) -CHAR_LENGTH(REPLACE(tablename.name, ‘,’, ”))>=numbers.n-1 order by id, n Please see fiddle here. If you cannot create … Read more
with sed sed -r ‘s_([^/]+/)__’ similarly with awk awk ‘{sub(/[^/]+\//,””)}1’ however, cut is the most proper tool for this task cut -d/ -f2-