We are creating a pipe delimited CSV file but are running into an issue when text contains a column. When the CSV is opened in Excel we expect all of the data to populate in column A. When a field contains a comma, the text after comma is returned in column B. This prevents the user from being able to break up the file based on the delimiter.
Is there anyway to make the plugin ignore the comma so that all of the data is only split by the pipe? Thanks!
Discussion posts and replies are publicly visible