You could use a query like this: SELECT id, SUBSTRING_INDEX(SUBSTRING_INDEX(colors, ‘,’, n.digit+1), ‘,’, -1) color FROM colors INNER JOIN (SELECT 0 digit UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3) n ON LENGTH(REPLACE(colors, ‘,’ , ”)) <= LENGTH(colors)-n.digit ORDER BY id, n.digit Please see fiddle here. Please notice that this query … Read more
tldr; format just calls obj.__format__ and is used by the str.format method which does even more higher level stuff. For the lower level it makes sense to teach an object how to format itself. It is just syntactic sugar The fact that this function shares the name and format specification with str.format can be misleading. … Read more
You can do something like this: Console.WriteLine(String.Format(“{0,-10} | {1,5}”, “Bill”, 51)); You’ll get “51” aligned to right on 5 characters. More examples here: Align String with Spaces. For official reference, see Composite Formatting
There is now an easy way to automatically sign-off any commit that is not already signed-off by using hooks and the git-interpret-trailers command. In the upcoming version 2.15 of git the command allows to trivially check for an existing sign-off (no matter what’s its value/author is) and add yours if there is non yet. As … Read more
I think you need first reset default header style, then you can change it: pd.core.format.header_style = None All together: import pandas as pd data = pd.DataFrame({‘test_data’: [1,2,3,4,5]}) writer = pd.ExcelWriter(‘test.xlsx’, engine=”xlsxwriter”) pd.core.format.header_style = None data.to_excel(writer, sheet_name=”test”, index=False) workbook = writer.book worksheet = writer.sheets[‘test’] font_fmt = workbook.add_format({‘font_name’: ‘Arial’, ‘font_size’: 10}) header_fmt = workbook.add_format({‘font_name’: ‘Arial’, ‘font_size’: 10, … Read more
select right (’00’+ltrim(str( <number> )),2 )
The “default format” of a datetime is: ShortDatePattern + ‘ ‘ + LongTimePattern at least in the current mono implementation. This is particularly painful in case you want to display something like 2001-02-03T04:05:06Z i.e. the date and time combined as specified in ISO 8606, but not a big problem in your case: using System; using … Read more
email.utils has a parsedate() function for the RFC 2822 format, which as far as I know is not deprecated. >>> import email.utils >>> import time >>> import datetime >>> email.utils.parsedate(‘Mon, 16 Nov 2009 13:32:02 +0100’) (2009, 11, 16, 13, 32, 2, 0, 1, -1) >>> time.mktime((2009, 11, 16, 13, 32, 2, 0, 1, -1)) 1258378322.0 … Read more
The MessageFormat class looks like what you’re after. System.out.println(MessageFormat.format(“{0} + {1} = {2}”, x, y, x + y));