Skip to main content
Question

Formatting Issue: Extra Space at End After Date Format Change in Form

  • August 21, 2023
  • 3 replies
  • 71 views

it-telepski

 

I retrieve a date from a form and subsequently aim to alter its format from DD-MM-YYYY to DD.MM.YYYY utilizing the replace function.

However, I've encountered an additional space at the end of the resulting text, which reads "DD.MM.YYYY ".

 

I am presently employing a workaround by conducting a secondary replacement of the space with an empty character in a subsequent step.

 

Where does this extra space come from?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

jayeshkumarbhatia
Forum|alt.badge.img+7

Hi @it-telepski ,

 

There could be chance that the space is coming directly from the form submission. You can use Formattter by Zapier or Code by Zapier to transform the data.


it-telepski
  • Author
  • Beginner
  • August 21, 2023

It does get imported as a date, and there is no space at this step.

Directly after this, I change the format and the space appears.


jayeshkumarbhatia
Forum|alt.badge.img+7

Ok @it-telepski , It looks fine with me here. You should report this issue to Zapier team here. Alternatively you can use Formatter by Zapier or Code by Zapier for data transformation.