Hi. I am using the Parse CSV workflow tool. The header file from our source CSV has spaces in the column names, so it looks like this:
First Name,Last Name,Date Of Birth
When I copy the header line into the header field, it will run fine but it outputs the following as header columns:
First, Name, Last, Name, Date, Of, Birth
So it seems to be taking the space as a delimiter even though comma is selected. Any way around this? I cannot change the format of the incoming CSV as it is from a 3rd party.