title: Field and text delimiters within cells in csv files
body: <p>This is likely a very basic question that I could not, despite trying, find a satsifying answer to. Feel free to skip to the question at the end if you aren't interested in the background.</p>
  <p><strong>The task:</strong></p>
  <p>I wish to create an easy localisation solution for my unity projects. After some initial research I concluded it would be best to use a .csv file read by a streamreader, so that translators would only ever have to interact with the csv table, where information is neatly organized.</p>
  <p><strong>The main problem:</strong></p>
  <p>Due to the nature of the text, I need to account for linebreaks and special characters in the actual fields. As such I could not use the normal readLine() method.
  This I worked with by using Read() and checking if a linebreak is within a text delimiter bracket. But as I check for the text delimiter, I am afraid it might run into an un-escaped delimiter part of the normal in-cell text (since the normal text delimiter is quotation marks).</p>
  <p>So I switched the delimiter to §. But now every time I open the file I have to re-enter § as a text delimiter in OpenOfficeCalc, probably due to encoding differences. Which is annoying but not the end of the world.</p>
  <p><strong>My question:</strong></p>
  <p>How does OpenOffice (or similar software) usually tell in-cell commas/quotation marks apart from the ones used as delimiters? If I knew that, I could probably incorporate a similar approach in my reading of the file.</p>
  <p>I've tried to look at the files with NotePad++, revealing a difference in linebreaks (/r instead of /r/n) and obviously it's within a text delimiter bracket, but when it comes to how it seperates its delimiters from ones just entered in the text/field, I am drawing a blank.</p>
  <p>Translation file in OpenOffice Calc:</p>
  <p><a href="https://i.stack.imgur.com/F04IK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F04IK.png" alt="Csv in Openoffice" /></a></p>
  <p>Translation file in NotePad++, showing all characters:</p>
  <p><a href="https://i.stack.imgur.com/coeaR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/coeaR.png" alt="enter image description here" /></a></p>
  <p>I'd appreciate any insight or links on the topic.</p>