I am looking for a json query to format Currency column in SharePoint Online

I am looking for a json query to format Currency column in SharePoint Online. Below query works but removes currency icon from the value.

{ “$ schema”: “http://columnformatting.sharepointpnp.com/columnFormattingSchema.json”, “elmType”: “div”, “style”: { “font-weight”: “bold”, “background-color”: “yellow” }, “txtContent”: “@currentField” }

CIS 2.3.4.1 (L1) Ensure ‘Devices: Allowed to format and eject removable media’ is set to ‘Administrators and Interactive Users’

I am implementing CIS on Windows 10 1803 and I cannot work out this control.


Description: This policy setting determines who is allowed to format and eject removable NTFS media. You can use this policy setting to prevent unauthorized users from removing data on one computer to access it on another computer on which they have local administrator privileges. The recommended state for this setting is: Administrators and Interactive Users.

Rationale: Users may be able to move data on removable disks to a different computer where they have administrative privileges. The user could then take ownership of any file, grant themselves full control, and view or modify any file. The fact that most removable storage devices will eject media by pressing a mechanical button diminishes the advantage of this policy setting.


For a start, I have never known anyone not be allowed to eject and format removable media (assuming hard disks, usb drives etc).

But I am even less sure on why the control is asking me to set it to ‘Administrators and Interactive Users’ when the default is just ‘Administrators’.

CSC CIS Windows 1803: The recommended state for this setting is: Administrators and Interactive Users. The default value is Administrators only. Administrators and Interactive Users will be able to format and eject removable NTFS media.

docs.microsoft: It is advisable to set Allowed to format and eject removable media to Administrators. Only administrators will be able to eject NTFS-formatted removable media.

Would this setting also upset software that manages USB devices, such as Checkpoint Removable Media Encryption?

MQ integration: How to notify consumers of upcoming message format changes?

We have multiple microservices communicating over MQ. As MQ messages are the interface/contract between the services, whenever we make changes to the MQ message published by a service we need to make the same adjustments on the services which consume the message.

As of now, the number of services is small enough so that we know which services communicate with each other, and can keep the MQ message contract in sync between them. But as the number of services grow this becomes harder.

Option 1: Break things first, then fix it

I’ve been thinking maybe of implementing some kind of health check. Let’s say service A during operations may emit message type X, which is consumed by service B. Service A could then on startup emit a health check type of message, something in the lines of a message X dry-run. When service B receives this, it simply verifies that the message is according to contract. If not, for example if service A have remove a critical field in the message, then service B will reject the message which in turn will end up on a dead-letter exchange, which again will trigger a warning notification to the devops staff.

This approach won’t prevent us from deploying non-compatible message types, but will notify us pretty much instantly when we do. For our use case, this might work due to our very small number of developers and projects, so if we break things like this we’d be able to fix it quite quickly.

Option 2: Early probes

A variation over this might be that we start versioning the MQ message format (which we probably should and will do anyway). Then, when service A plans to upgrade from version 1 of message type X to version 2, server A could early on start emitting “dry-run” type of version 2 of message type X. This would cause service B to drop the message. Say this happens a few days or weeks before service A perform the actual switch from version 1 to version 2, then the devops team will have time to add support for version 2 in the mean time.

Option 3: Manually detecting conflicts before deployment

Another approach would be to have some way of detecting – before the actual deployment – that service A is about to start emitting non-compatible messages in the first place. This would mean that would need to maintain some matrix or something over which versions of message X is support by which consumer, and defer deploying service A (with the new version of message X) until all the consumer are ready for it. How to implement this effectively I don’t know.

Other alternatives

How does other handle message type compatibility between services that communicate using MQ – how do you know that when your service A makes a change to message type X, it won’t break any of the consumers?

PS. I posted this over at Reddit a few days ago, but due to the lack of feedback I decided to post here as well.

Format double to 3 decimal places without decimal separator to a certain lenght

I need to format a double value to three decimal places to a string with length of 9 with leading spaces and no decimal separator.

My approach is this

NumberFormatInfo nfi = new NumberFormatInfo(); nfi.NumberDecimalSeparator = "a"; nfi.NumberGroupSeparator = "";  double a = 334.44554;  Console.WriteLine($  "{a.ToString("####0.000", nfi).Replace("a", ""), 9}"); 

Is there a more elegant way to do this?

Format double to 3 decimal places without decimal separator to a certain lenght

I need to format a double value to three decimal places to a string with length of 9 with leading spaces and no decimal separator.

My approach is this

NumberFormatInfo nfi = new NumberFormatInfo(); nfi.NumberDecimalSeparator = "a"; nfi.NumberGroupSeparator = "";  double a = 334.44554;  Console.WriteLine($  "{a.ToString("####0.000", nfi).Replace("a", ""), 9}"); 

Is there a more elegant way to do this?

How to visually format questions/answers to easily follow the story?

I’m designing a booklet about science facts and stories for kids. The format is based on questions and answers between a teacher and a student. It’s text based; few images/graphics are used. The booklet tries to emulate a real interaction between a student that wants to learn more about science and the teacher. My question is how to visually format all those questions/answers in an easy to follow the story?

Things that I want to avoid.

  • Enclose the spoken words with quotation marks. The whole booklet is a “dialog”, so it will look quite ugly having every sentence/paragraph quoted.

  • Using an indicator like A: and Q:. That can help separate the questions from the answers, but it doesn’t indicate who is “talking”, if is the teacher or the student.

I initially thought of separating the content by colours. For example. When the teacher “talks”, the font or background would be in blue. The student will be yellow. My concern is that a) it will increase the printing price b) it may become “too” colourful. So, I’m not sure now.

TWRP unable to wipe or format `Failed to mount ‘/system’ (Device or resource busy)`

I’m trying to install LineageOS and then GAPPS on my Pixel XL from TWRP recovery. I’ll try to Advance Wipe the /systems directory and Format Data, but I continue to get multiple errors:

Failed to mount '/system' (Device or resource busy)

Failed to mount '/vendor' (Device or resource busy)

And

Unable to wipe 'System'

Unable to wipe '/system'

 to

If I just continue with adb sideload lineageos.zip most of the time it stops about halfway (PowerShell shows 47%) through and then TWRP shell shows:

Installing zip file '/sideload/package.zip' Step 1/2 Step 2/2  

I then try to sideload the gapps.zip file and get another error saying /system doesn’t have enough space. I’ve tried sideloading several different gapps versions including their smallest pico zip fie of 91.39 MiB.

I am able to then boot into LineageOS, but no GAPPS show and I’m not able to run any new apps installed via APK without them crashing.

My assumption is that I need to fully wipe system and format it, but I’ve been trying for two days now and still get the above (Device or resource busy) errors. Any help would be much appreciated!