Easter Sale 2024

  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Exporting Zip code field to CSV drops the first 0

Exporting Zip code field to CSV drops the first 0 13 years 6 months ago #11733

Hey guys, I am using REV33 of RSFORMPRO, when exporting the form (which includes a ZIP code field) the zipcodes that begin with 0 get dropped when exported to CSV. This is presenting a problem for our shipping provider.

How can this be fixed?

Thank you.
The administrator has disabled public write access.

Re:Exporting Zip code field to CSV drops the first 0 13 years 6 months ago #11740

  • andreic
  • andreic's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 722
  • Thank you received: 59
Hello,

Are you by any chance using Excel in order to view your CSV files? If this is the case then please note that the leading 0 is being removed by the program itself before the field is displayed. You can refer to the following article regarding this topic:

creativyst.com/Doc/Articles/CSV/CSV01.htm#CSVAndExcel

...just search for "Excel vs. Leading Zero & Space". Please try viewing your CSV file in a normal text editor, the leading 0 should be displayed correctly.
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!