×
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.
Unfortunately this is common with Excel. I don't think it's an issue related to Scott's tool, but it's probably due to the column formatting in Excel and how it's handled.
Usually the single quote resolves the problem, but the Excel formatting may also.
If you need to do some formatting directly with Excel, our RPG2SQL Integrator functionality actually uses Excel to format the data and can be integrated to any RPG application.
Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
------------------------------
message: 2
date: Tue, 15 Jan 2013 08:39:25 +0100
from: Dirk.Marien@xxxxxxxxxxxxxxxxx
subject: 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.
midrange.com
