How to pad space in O365 (no inline function)

  • 31 August 2018
  • 2 replies
  • 7 views

Badge +6

Good afternoon.

 

I have a requirement for a field (PN3) to always be 2 characters, but input on the form could be 1 character. What I do with the On-Prem version is I have a PadRight inline function for PN3, so that 2 characters are created for the policy number I build. PN3 could be a space and therefore the PadRight creates that if only 1 character in input. I have attached what that looks like.

 

However, since Inline functions are gone with O365, I am having trouble creating the same "PadRight" for PN3. I need it to always be 2 characters, but if 1 character is input on the form, I need to add a space.

 

Any thoughts?  Thanks.


2 replies

Userlevel 4
Badge +9

No easy way.
Add a regex to count the number of characters of your string :

  • Pattern: . (just a dot, meaning any character)
  • Split function
  • Store in collection

Count items in your collection

Do a loop, or even better a swith action, to add the required spaces to your input string

.(dot) doesn't work. "" does the split.

Reply