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+)
I used the idea from Kerry’s answer, but simplified it since I was just looking for something simple for my specific purpose. Here is what I have: Show code snippet The regex uses 2 lookahead assertions: a positive one to look for any point in the string that has a multiple of 3 digits in … Read more
One of the way would be using NumberFormat. Output: 4.00
You are printing a formatted string. The {0} means to insert the first parameter following the format string; in this case the value associated with the key “rtf”. For String.Format, which is similar, if you had something like you’d create a string “This is a test. The value is 42“. You can also use expressions, and print … Read more