Fixed Width to Delimited Wizard
This wizard saves time by creating a large group of filters to convert fixed width data to CSV (comma-separated), Tab-delimited or Pipe-delimited data. If you need the final output in XML, follow this filter with a Convert CSV to XML filter.
To use this wizard, simply paste (or use the right-click menu to load) your field specification, then click the [Build] button.
Field Specification
TextPipe expects a field specification like this:
Record_Type_P 2
Acct_No_Prefix 2
AcctNo 12
Patient_Status 3
Admit_Dt 8
ABS_Status_Date 8
Patient_Name 30
Pt_Addr_1 30
Pt_Addr_2 30
Pt_City 20
Pt_State 2
Pt_Zip 10
Pt_Sex 1
Pt_DOB 8
Pt_Fin_Class 12
Pt_Phone_No 10
Pt_SSN 9
Pt_Country 10
Pt_County 10
Pt_Discharge_Di 2
Admit_Priority 1
Pt_Weight_in_Kg 7
Leading and trailing spaces are allowed and will be removed.
Output Format
You can choose if TextPipe outputs CSV (comma-separated) data, Tab delimited or Pipe-delimited data. If you need the final output in XML, you can use the Convert CSV to XML filter.
Output Header Record
When checked, TextPipe will add a header record at the top of the file with the field names you have provided. This is very useful for importing the file into Excel or a database.
Trim leading spaces and zeroes from the output file
By default, TextPipe leaves leading spaces, zeros and even '+' signs on numerics. Check this option to remove them to save space in the output file.
|
