Flat File with an Application

[Brittwisch]

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?

[OTrieger · Accepted solution]

@Brittwisch 

Text file comes in specific coding based on the language, check that you are using the correct coding when importing the data. Selecting the correct code should give you clean text.

[Manoj_k]

Hi @Brittwisch try \0 as a delimiter while opening the csv file instead of default "," , it will open up the csv whatever be the format