Question Re: Adding White Space to Help with Formatting in Technology Q&A

Adding White Space to Help with Formatting

Former Member — Tue, 03 Jul 2018 16:06:16 GMT

Moving right along and now comes the fun part -- formatting. Usually I would just use the built in editor features, but the string is concatenated to display Wd x Ht x Dp depending on a condition.

While it currently displays ok, I need to pad out each field with white spaces (and center) to align with my headers above.

Wd, Ht and Dp are currently defined as strings, is it possible to format and center using white spaces and calculating the length of each value?

global stringvar Width := totext({width},0,"")
global stringvar Height := totext({height},0,"")
global stringvar Depth := totext({depth},0,"")

Default Condition:

(Width) & ' X ' & (Height) & ' X ' & (Depth)

Gary

Re: Adding White Space to Help with Formatting

abhilash_kumar — Wed, 04 Jul 2018 07:59:50 GMT

Hi Gary,

Could you please post a screenshot of how the alignment is right now?

I'm guessing you'd have to use a fixed-width font to get it perfectly aligned.

-Abhilash

Re: Adding White Space to Help with Formatting

Former Member — Wed, 04 Jul 2018 10:23:31 GMT

If you do not want to use fixed length font you will need to convert to 3 fields. So instead of changing order of a concatenated string. Create 3 formulae, for Position 1 which changes from width, depth or height., repeat for position 2 & 3.

Place these formula fields on designer, align with your headers and then place text boxes with X between,

Ian

Re: Adding White Space to Help with Formatting

Former Member — Wed, 04 Jul 2018 12:12:37 GMT

Sure, here it is. Understanding that width, height and depth values can be both 4 characters each. I manually put in 4 spaces each to at least clean it up a bit.

width-height-depth.png

Gary

Re: Adding White Space to Help with Formatting

Former Member — Wed, 04 Jul 2018 12:13:58 GMT

I thought of this as well, will toy with that idea today actually. I would prefer though to keep it all one, as each condition triggers the format of Width, Height and Depth.

Gary

Re: Adding White Space to Help with Formatting

DellSC — Thu, 05 Jul 2018 14:53:24 GMT

Is there a particular reason why you can't just make the text box a specific width and center its contents?

-Dell

Re: Adding White Space to Help with Formatting

Former Member — Thu, 05 Jul 2018 17:24:38 GMT

Because I have a flair for over complicating the simplest of things. I've made a text box and monkeyed with some manual spacing. While it's not perfect, it does align itself a little better. It will work for now but a proper solution will always be on my list. OCD does this to a person.

Gary

Re: Adding White Space to Help with Formatting

DellSC — Thu, 05 Jul 2018 17:37:35 GMT

Or, as I say to my daughter, CDO, for those who are so bad it has to be in alphabetical order. 😄