Using FORMAT> with variables - SOLVED!

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
mightycpa
Automation Wizard
Posts: 343
Joined: Mon Jan 12, 2004 4:07 pm
Location: Vienna, VA

Using FORMAT> with variables - SOLVED!

Post by mightycpa » Fri Aug 25, 2017 3:11 pm

I can't get right padding to work correctly. What has to change to make it work?

Code: Select all

Let>v_padding=Y
//left padding is right aligned
Let>v_align=R
Let>v_len=10
Let>v_format=s
Let>v_data=hello

If>v_padding=Y
//  If>v_align=L
//  Left aligned is right padding
     Format>%-%v_len%%v_format%,%v_data%,v_data_paddedR
     Length>v_data_paddedR,v_newlen
//  Else>
     Format>%%v_len%%v_format%,%v_data%,v_data_paddedL
     MessageModal>Left padding works: %v_data% and %v_data_paddedL% %CRLF% right padding doesn't %v_data_paddedR% is length %v_newlen%
//  Endif>
Endif>
//Format>%-v_len%v_format%,%v_data%,v_data_paddedR
//Format>%-v_lenv_format,%v_data%,v_data_paddedR
MessageModal>Removing percent signs makes the script blow up

Format>%-10%v_format%,%v_data%,v_data_padded2
MessageModal>Replacing only one variable doesn't work either: %v_data_padded2%

Format>%-10s,%v_data%,v_data_padded3
Length>v_data_padded3,v_len3
MessageModal>Replacing both does: %v_data_padded3% is %v_len3% chars

Last edited by mightycpa on Fri Aug 25, 2017 10:22 pm, edited 1 time in total.
"A facility for quotation covers the absence of original thought." - Lord Peter Wimsey

User avatar
JRL
Automation Wizard
Posts: 3497
Joined: Mon Jan 10, 2005 6:22 pm
Location: Iowa

Re: Using FORMAT> with variables

Post by JRL » Fri Aug 25, 2017 8:53 pm

Make the percent sign a variable for that first "%".

Code: Select all

Let>v_padding=Y
//left padding is right aligned
Let>v_align=R
Let>v_len=10
Let>v_format=s
Let>v_data=hello

//Make the percent sign a variable for that first "%" only
Let>Percent=%

If>v_padding=Y
//  If>v_align=L
//  Left aligned is right padding
     Format>%percent%-%v_len%%v_format%,%v_data%,v_data_paddedR
     Length>v_data_paddedR,v_newlen
//  Else>
     Format>%percent%%v_len%%v_format%,%v_data%,v_data_paddedL
     MessageModal>Left padding works: %v_data% and %v_data_paddedL% %CRLF% right padding doesn't %v_data_paddedR% is length %v_newlen%
//  Endif>
Endif>

mightycpa
Automation Wizard
Posts: 343
Joined: Mon Jan 12, 2004 4:07 pm
Location: Vienna, VA

Re: Using FORMAT> with variables

Post by mightycpa » Fri Aug 25, 2017 10:22 pm

Outstanding, JRL!

Thank you once again!
"A facility for quotation covers the absence of original thought." - Lord Peter Wimsey

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts