Alright so I’ve already updated this question a ton and it’s starting to get overloaded, so I figured I’d write this as an answer even though it isn’t a full one. Extrapolating from @bueltge’s answer, I actually went back and found his previous post in question. In that post, there was a plugin listed that … Read more
Highlight/ select the lines you want indented, then press TAB as often as needed until they reach the proper indent level. You can remove spaces with SHIFT TAB. You can also use CTRL+ALT+I to auto-indent the selection.
You need to take out the $ signs before the row numbers in the formula….and the row number used in the formula should correspond to the first row of data, so if you are applying this to the (“applies to”) range $B$2:$B$5 it must be this formula =$B2>$C2 by using that “relative” version rather than … Read more
I have a string “1112224444′ it is a telephone number. I want to format as 111-222-4444 before I store it in a file. It is on a datarecord and I would prefer to be able to do this without assigning a new variable. I was thinking: but that does not seem to do the trick. … Read more
Use the below function (changing [E:E] to the appropriate range for your needs) to circumvent this issue (or change to any other format such as “mm/dd/yyyy”): P.S. In my experience, this VBA solution works SIGNIFICANTLY faster on large data sets and is less likely to crash Excel than using the ‘warning box’ method.
The json module already implements some basic pretty printing in the dump and dumps functions, with the indent parameter that specifies how many spaces to indent by: To parse a file, use json.load():
On Windows and Linux : Ctrl + Shift + F On Mac : ⌘ + ⇧ + F (Alternatively you can press Format in Main Menu > Source)
Use strtotime() and date(): (See the strtotime and date documentation on the PHP site.) Note that this was a quick solution to the original question. For more extensive conversions, you should really be using the DateTime class to parse and format 🙂
It’s an old question but I’d add something potentially useful: I know you wrote your example in raw Python lists, but if you decide to use numpy arrays instead (which would be perfectly legit in your example, because you seem to be dealing with arrays of numbers), there is (almost exactly) this command you said you made … Read more
Quick way (Probably too much horizontal space though): Better way: And using f-strings (Python3.6+)