Solved

Document Generation - variable value after dot


Hi,

when a file is generated (by using Document Generation action) and inside the file there is a variable after fullstop, then the value of variable is not transformed.

 

For example:

when I have a string variable like <<Variable_Year>> = 2022

and text in the template file is 01.01.<<Variable_Year>> 

then the outcome in the generated file should be: 01.01.2022, instead I receive 01.01.<<Variable_Year>>

 

That only happens when a variable is placed after fullstop/dot.

 

Does anyone have a workaround for this?

 

Thanks!

 

icon

Best answer by cecilia-penha 14 June 2022, 18:42

View original

2 replies

Do you have the ability to change the separator from a period to a dash or a slash? You might want to report to the support team at customer central.
Userlevel 3
Badge +8

Hi @DavidL2,


 


As a workaround you can use a field to get the variable filled properly as show below :


 


From the template, insert a Field and add the following formula :




 


 


Formula = IF "<<Variable_9999>>"="<<Variable_9999>>" "<<Variable_9999>>" "<<Variable_9999>>"


 


The results :



 


 


Hope that helps. ^^

Reply