Download
FileSheeter Free (latest version)
Download
User’s Guide
Runtime environment is Windows 10 64bit x64
FileSheeter provides an interactive environment in which to create your application and represents how the application will manipulate your file.
In addition to the GUI, FileSheeter provides:
- Edit a project of FileSheeter Application.
- LayoutEditor features to simplify creating or modifying your template of a file.
- Full support for managing the FileSheeter’s options.
- Preview data of a file.
- Export a new file of data.
FileSheeter is a utility for converting files into different formats, and/or translating field-level data into other types.
FileSheeter is a quick and easy way to:
data integration with various files (Flat, CSV, Excel)
reorganize very Large transaction file (2GB moreover)
record selector that identifies records conditionally
Design multiple record layouts in one or more files
Transform between plain and personalized data.
Select, join, sort, filter, aggregate, calculate, convert, and re-format
Translate EBCDIC to ASCII fields, MBCS(like CJK) to Unicode, etc.
Remap field sizes and offsets
Reformat files by changing their field layouts from fixed length to delimited (or vice versa)
Only use certain fields on the output
Create multiple output files, and formats, from a single input format
Also, supports select, join, sort, filter, aggregate, calculate, convert, and re-format.
Select via record selector that conditional include also predefined condition
Sort multiple numbers of keys in fields, custom sort, 2GB over within available memory
Filter subset using criteria
Join match syntax 1-1, n-1
Append Place other records below a record
Convert translate input field data types to new types
Aggregate min, max, average, sum, count (collection only)
Calculate across rows to perform math (+ mbcs functions)
Re-map change field positions, sizes, and values
Report paging, multiple output formats