This guide will teach you how to make a file conversion using FileSculptor.
1. Load a Source File
In the Import tab, select the type of the source file, if it is a CSV/Text file or a Excel-compatible spreadsheet. Configure the file so that the Content Preview grid shows data correctly.
You can define field names and types by clicking on Field Properties button. If the source file is in text format and the field has a date or number value, you can configure the format of the date or decimal separator for the number value and FileSculptor will convert the data in the field from text to the specified value.
2. Transform Fields
In the Transform tab, add calculated fields based on the source fields. Click on Add New Field button to add and configure a calculated field. Define its name and functions, selecting fields from the source.
Configure calculated fields using Excel-like functions like Upper and Concatenate.
3. Create Destination File
In the Export tab, select the type of the destination file, if it is a CSV/Text file or a Excel-compatible spreadsheet. Select fields from the source(s) and/or calculated fields and reorder the fields in the order that they mush be exported. You can configure the program to create a destination file or append data to a existing file.
In the Run tab, the Task Summary grid will show a summary of the export process. Click the Run Now button to begin the export process.
5. Save Project
Use the File menu to save all the import/transform/export configuration as a project. Now you can open the file and repeat the process whenever you want to make the same conversion.