We have a csv file from a 3rd party and they are using a | (pipe) as a delimiter.
To import the file we need to replace the pipe characters with commas. Would it be possible to change the file as part of the import process? Are there any events that would let us change the file before the import begins?
I've added the pipe to the list. I you can send me an email with your address [email protected]? I can send the an email with the update then you don't need to change the file before import.
Change a csv delimiter during the import
Hi
We have a csv file from a 3rd party and they are using a | (pipe) as a delimiter.
To import the file we need to replace the pipe characters with commas. Would it be possible to change the file as part of the import process? Are there any events that would let us change the file before the import begins?
Thanks
Dallas
Hi Dallas,
I've added the pipe to the list. I you can send me an email with your address [email protected]? I can send the an email with the update then you don't need to change the file before import.
Best,
Richard
Richard, I will send the email. Thank you for the quick response.
Dallas
is working on a reply...