I have been trying to load a simple file which uses a 'broken pipe' delimiter (¦). This is the first time I've come across this type of delimiter and have had problems with it from the start. The main issue is the introduction of an extra character in the data, which I can only assume has been added as part of the encoding process?
The sample qvw and data file is attached. The file itself is being sent from a third party so I'm not able to change the delimiter or file at this stage.
Is there any way to load this data without gaining the extra character in the data?
Thank you both for the solutions, they both work. However, I'm going to go with the purge method. Replacing the delimiter per row is fine on the test file but the main data file is quite large and this will increase the loading time.