HomeForum
Welcome, Guest
ETL-Forum
Forum
Advanced ETL Processor

Retaining leading zeros in EXCEL cell export
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Retaining leading zeros in EXCEL cell export

Retaining leading zeros in EXCEL cell export 9 months, 4 weeks ago #3392

  • oxalagu
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
  • Karma: 0
Hi,
when I use EXCEL-Writer, leading zeors from seemingly numeric fields are removed.

04711 is stored as 4711.


Immediate thought was to escape the umber with a quote. But when I "Ensure Prefix" = "'" (quote) the quote is not treated as EXCEL Escape for TEXT-Fields but physically prefixed.

04711 becomes '04711


Greets
Axel
Reply Quote

Re: Retaining leading zeros in EXCEL cell export 9 months, 4 weeks ago #3393

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Looking at it now

Peter
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Advanced ETL Processor
Powered by Kunena
Time to create page: 0.14 seconds

Testimonials

"The products are stable and the support is good. I would (and have) recommend to anyone needing to automate data management tasks or integrate disparate systems."

Gene Kovacs,
Director of Technical Business Operations,
A2B

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC

Databases we work with

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top