# Csv files

**URL:** <https://forum.dynamobim.com/t/csv-files/44955>\
**Category:** DesignScript\
**Tags:** dynamo, csv\
**Created:** [December 31, 2019, 9:55am UTC](https://forum.dynamobim.com/t/csv-files/44955 "2019-12-31T09:55:40Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daniel.Gijsbers](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/daniel.gijsbers/32/57696_2.png) [@Daniel.Gijsbers](https://forum.dynamobim.com/u/Daniel.Gijsbers)\
**Post date:** [December 31, 2019, 9:55am UTC](https://forum.dynamobim.com/t/csv-files/44955/1 "2019-12-31T09:55:40Z")

</div>

Often when I export stuff to csv files I have to ‘fix’ the strings a bit. If people have used comma’s in their text than this tends to mess up the data structure. (all depending on on your regional list separators)  
Also Hard Returns / Carriage Returns can cause havoc.

Most likely there are some other characters that can cause havoc but these are the culprits I have run in so far.

Therefore I thought I’ll share this one with you.

```
//Replace Comma's with points
ReplaceCommas = String.Replace(input, ",", ".");
//Remove hard enters
ReplaceCarriageReturns = String.Replace(ReplaceCommas, "\r", ".");
//Remove new lines
ReplaceNewLines = String.Replace(ReplaceCarriageReturns, "\n", ".");
```
