× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. January 2013

XLParser treats text fields as numeric fields

Hi,

I?m using Scott Klement?s XLS Parser and it works file. However, the
parser sometimes treats zones in excel formatted as text as numeric
fields. For example : the as text formatted cel 000123 is parsed as 123
numeric where it should be treated as 000123 alpha. When I put an
apostrophe befor the zone (?00123) it is treated correctly. Unfortunately,
putting an apostrophe before each zone is no option for me?. . Anybody any
suggestions ?

Kr,
Dirk.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.