I'm using a workflow in CRM to update a text field.

Below is the line of the code that matters:

1. orderedLength = shoulder + "__________(TRY: "+tryOnLength+"          ADJ: "+lengthAdjustment+")";

To be clear, I've added an arbitrary 10 underscore "_" characters into the string before the word "(TRY" and I also added an arbitrary 10 blank spaces before the word "ADJ"

My problem is that the spaces are being ignored such that output looks like below:

20__________(TRY: 21 ADJ: -1)

The 10 space characters between "21" and "ADJ" seem to be artificially trimmed down to just a single space. Expected output would be:

20__________(TRY: 21          ADJ: -1)

Any way to avoid the space trimming or to ensure that the spaces actually display properly? I tried the LEFTPAD function but it had similar behaviour.

Thank you in advance,

Darryl