...
- The source file is missing \r (shown as CR in Notepad++):
2. The following properties set \r\n as the line separator:
...
4. Which means the reversed file only seems to hold 2 records, instead of 3:
Solution
The best solution would be for the source file to be formatted correctly and use the same line separator for both the header record and subsequent records, but this is not always possible to achieve.
This can be rectified in Convergence for DISemarchy Integrator :
- Launch the Flie Wizard on the file with this problem (right click on the metadata folder, select Actions>Launch File Wizard)
...
*Note: As you have removed the \r as a line separator, it will still be in the reversed file as a character at the end of the value in the last column (it may appear as a space, but the control character is still there). Therefore, you may want to trim the values in the last column in any mappings you create from this file, using a function like trim() or substring() depending on what your target is.
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Page Properties | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|