I have a very large CSV file that contains our JE information from our system. Because there are some additional quotes in the explanation column, it throws off the CSV formatting. I have tried bringing in the file as a csv without delimitators and ignoring quotes, but it is still reading the weird formats upon input and making some additional rows out of the data.
I have fixed this by pulling in the file as a flat file, and then using regex formulas to circumvent the formatting issues. However, when I try to use this as an application, uploading a new file into the application it pulls it in as a csv. Is there anyway to have it read as a flat file in the application so others can use my workflow?
