# Parsing CSV files where numbers may have thousand separators and a percentage symbol

**URL:** <https://discourse.julialang.org/t/parsing-csv-files-where-numbers-may-have-thousand-separators-and-a-percentage-symbol/30344>\
**Category:** General Usage\
**Tags:** csv\
**Created:** [October 26, 2019, 10:18pm UTC](https://discourse.julialang.org/t/parsing-csv-files-where-numbers-may-have-thousand-separators-and-a-percentage-symbol/30344 "2019-10-26T22:18:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![askvorts](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/askvorts/32/7120_2.png) [@askvorts](https://discourse.julialang.org/u/askvorts)\
**Post date:** [October 26, 2019, 10:18pm UTC](https://discourse.julialang.org/t/parsing-csv-files-where-numbers-may-have-thousand-separators-and-a-percentage-symbol/30344/1 "2019-10-26T22:18:16Z")

</div>

I am trying to load a csv file using `CSV.jl`. The file looks like the following

```julia
"Date, Vol, Change"
"Sep 30, 2019","6,688.30","-0.41%"
"Sep 27, 2019","6,716.10","0.58%"
"Sep 26, 2019","6,677.60","-0.49%"

```

Although I am able to parse the date using `DateFormat("u dd, yyyy")`, so far I have been unable to find a way to parse numbers with thousand separators (e.g. `parse.(Float64, Data[1,2])` errors) and percentage symbol.

Thank you for any help!

---

<div class="post-metadata">

**Author:** ![jling](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/jling/32/212909_2.png) [@jling](https://discourse.julialang.org/u/jling)\
**Post date:** [October 26, 2019, 11:15pm UTC](https://discourse.julialang.org/t/parsing-csv-files-where-numbers-may-have-thousand-separators-and-a-percentage-symbol/30344/2 "2019-10-26T23:15:10Z")

</div>

In julia separators are represented by `_`, e.g:

```julia
julia> 6_000.30
6000.3

```

but `parse` doesn’t seem to like it, so you can probably do this:

```julia
julia> parse(Float64, replace("6,688.30", ',' => ""))
6688.3

```