Table of Contents

Search

  1. Preface
  2. Introduction
  3. Accessing Data Archive
  4. Working with Data Archive
  5. Scheduling Jobs
  6. Viewing the Dashboard
  7. Creating Data Archive Projects
  8. Salesforce Archiving
  9. SAP Application Retirement
  10. Creating Retirement Archive Projects
  11. Integrated Validation for Archive and Retirement Projects
  12. Retention Management
  13. External Attachments
  14. Data Archive Restore
  15. Data Discovery Portal
  16. Data Visualization
  17. Oracle E-Business Suite Retirement Reports
  18. JD Edwards Enterprise Retirement Reports
  19. Oracle PeopleSoft Applications Retirement Reports
  20. Smart Partitioning
  21. Smart Partitioning Data Classifications
  22. Smart Partitioning Segmentation Policies
  23. Smart Partitioning Access Policies
  24. Language Settings
  25. Appendix A: Data Vault Datatype Conversion
  26. Appendix B: Special Characters in Data Vault
  27. Appendix C: SAP Application Retirement Supported HR Clusters
  28. Appendix D: Glossary

Delimited Text Files

Delimited Text Files

When you export to a delimited text file, the system exports data to a .csv or .txt file.
When you export to a delimited text file, specify the following parameters:
Column and Row Separators
When you search the Data Vault by entity and select delimited text file as the export file type, the separators include default values. The following table describes the default values for the separators:
Separator
Default Value
Column Separator
,
Row Separator
\n
The values for the column and row separator parameters determine the type of delimited text file the system exports to. If you use the default values for the column and row separator parameters, then the system exports data to a .csv file. If you use values other than the default values, then the system exports data to a .txt file.
Put Values in Quotes
The Put Values in Quotes parameter is for .csv export. Enable the parameter if the source data includes new line characters. The parameter determines whether the system puts the source values in quotes internally when the system creates the .csv file. The quotes ensure that source data with new line characters is inserted into one column as compared to multiple columns.
For example, the source data contains the following information:
Name
Address
John Doe
555 Main Street
Apartment 10
The address column contains a new line character to separate the street and the apartment number. If you enable the parameter, the exported file includes the address data in one column. If you disable the parameter, the exported file splits the address data into two columns.
Only use this parameter if you use the default values for the separators. If you enable this parameter and use values other than the default values for the separators, then the system puts the values in quotes in the exported data.

0 COMMENTS

We’d like to hear from you!