L4X - an intelligent text filter for Excel

Are you having problems converting lines of text into rows of cells in a Microsoft Excel worksheet because:

• The text is arranged in columns, but is irregulary tabulated or paginated?
• The text contains blank lines and/or blank pages?
• The text contains more data than you actually want to import?
• The text contains data that requires "de-normalizing"?
• The worksheet has formats and formulae which must be preserved and adjusted?
• The worksheet requires the insertion of formulae for "live" sub-totals.?

If you are spending too much time in Excel, editing the result of such imports or conversions, then L4X may be the solution to your problems. L4X is an "add-in" for Microsoft Excel which allows "example" worksheets to be scripted in a little language that controls exactly what text is imported into Excel and when. L4X is designed to make the import of text from "legacy" reports into Excel worksheets as easy and as fast as possible, it can also import comma-separated values (CSV) and other delimited values from a text-file.

Of course, you can always solve such problems using Visual Basic for Applications (VBA). However, consider using L4X first because: The L4X scripting language is concise and easy to learn because it is designed specifically for tasks of this nature. A script for most import problems will only be few lines long and will be self explanatory because L4X is a "domain specific language". The L4X editor/debugger (IDE) for developing and running an L4X script is much simpler than VBA, easy to use and is designed specifically for the task. The L4X IDE has comprehensive and context-sensitive help, The L4X IDE shows pages of text the text-file you are importing. The L4X IDE has a "wizard" that help you create L4X statements, that reflect the position of any selected text. Once "scripted", worksheets can import text independently of Excel. Please click here to find out more about L4X.

We pride ourselves on our prompt and responsive support of our products, and we value feedback from customers and visitors, as it allows us to continually improve the reliability and functionality of L4X. .