### Author:  [@Yaniv\_Nuriel](https://discuss.elastic.co/u/Yaniv_Nuriel)
#### Post date: [April 17, 2020, 7:24pm UTC](https://discuss.elastic.co/t/convert-0-50-to-float-converts-it-to-0-00/228561/1 "2020-04-17T19:24:21Z")
Hey all,
Here are my load file:
```auto
Spend,Bbb
$0.55,100
$0.80,200
```
The conf.file is:
```auto
input {
file {
path => "/Users/yanivnuriel/logstash/data/ads/searchterms/us/one-line-15.txt"
start_position => "beginning"
sincedb_path => "NUL"
}
}
filter{
csv {
separator => ","
autogenerate_column_names => true
columns => ["Spend", "Bbb"]
}
mutate{
convert => ["Spend","float"]
}
}
output {
stdout { }
}
```
and the output is:
```auto
Yanivs-MBP:logstash yanivnuriel$ logstash -f test.conf
Sending Logstash logs to /usr/local/Cellar/logstash-full/7.6.2/libexec/logs which is now configured via log4j2.properties
[2020-04-17T21:57:33,742][WARN][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified
[2020-04-17T21:57:34,760][INFO][logstash.runner] Starting Logstash {"logstash.version"=>"7.6.2"}
[2020-04-17T21:57:45,914][INFO][org.reflections.Reflections] Reflections took 209 ms to scan 1 urls, producing 20 keys and 40 values
[2020-04-17T21:57:57,234][WARN][org.logstash.instrument.metrics.gauge.LazyDelegatingGauge][main] A gauge metric of an unknown type (org.jruby.RubyArray) has been created for key: cluster_uuids. This may result in invalid serialization. It is recommended to log an issue to the responsible developer/development team.
[2020-04-17T21:57:57,376][INFO][logstash.javapipeline][main] Starting pipeline {:pipeline_id=>"main", "pipeline.workers"=>4, "pipeline.batch.size"=>125, "pipeline.batch.delay"=>50, "pipeline.max_inflight"=>500, "pipeline.sources"=>["/Users/yanivnuriel/logstash/test.conf"], :thread=>"#"}
[2020-04-17T21:58:03,907][INFO][logstash.javapipeline][main] Pipeline started {"pipeline.id"=>"main"}
[2020-04-17T21:58:04,134][INFO][logstash.agent] Pipelines running {:count=>1, :running_pipelines=>[:main], :non_running_pipelines=>[]}
[2020-04-17T21:58:04,153][INFO][filewatch.observingtail][main] START, creating Discoverer, Watch with file and sincedb collections
[2020-04-17T21:58:06,089][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=>9600}
/usr/local/Cellar/logstash-full/7.6.2/libexec/vendor/bundle/jruby/2.5.0/gems/awesome_print-1.7.0/lib/awesome_print/formatters/base_formatter.rb:31: warning: constant ::Fixnum is deprecated
{
"host" => "Yanivs-MBP",
"Bbb" => "100",
"message" => "$0.55,100\r",
"@version" => "1",
"@timestamp" => 2020-04-17T18:58:07.550Z,
"path" => "/Users/yanivnuriel/logstash/data/ads/searchterms/us/one-line-15.txt",
"Spend" => 0.0
}
{
"host" => "Yanivs-MBP",
"Bbb" => "Bbb",
"message" => "Spend,Bbb\r",
"@version" => "1",
"@timestamp" => 2020-04-17T18:58:07.431Z,
"path" => "/Users/yanivnuriel/logstash/data/ads/searchterms/us/one-line-15.txt",
"Spend" => 0.0
}
{
"host" => "Yanivs-MBP",
"Bbb" => "200",
"message" => "$0.80,200\r",
"@version" => "1",
"@timestamp" => 2020-04-17T18:58:07.554Z,
"path" => "/Users/yanivnuriel/logstash/data/ads/searchterms/us/one-line-15.txt",
"Spend" => 0.0
```
As you can see the value in Spend is 0.0 instead of 0.55 and 0.8.
Thanks
Yaniv
---
### Author:  [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [April 17, 2020, 10:05pm UTC](https://discuss.elastic.co/t/convert-0-50-to-float-converts-it-to-0-00/228561/2 "2020-04-17T22:05:11Z")
Use mutate+gsub to remove the $ sign before the convert.
```
mutate { gsub => ["Spend", "\$", ""] }
```
---
### Author:  [@Yaniv\_Nuriel](https://discuss.elastic.co/u/Yaniv_Nuriel)
#### Post date: [April 17, 2020, 10:19pm UTC](https://discuss.elastic.co/t/convert-0-50-to-float-converts-it-to-0-00/228561/3 "2020-04-17T22:19:31Z")
Thanks Badger, but I get the same result for this line:
```auto
mutate{
gsub => ["Spend", "\$", ""]
convert => ["Spend","float"]
}
B.T.W. when I remove the $ from the load file it works fine, so indeed the $ causes the mass
```
---
### Author:  [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [April 17, 2020, 11:04pm UTC](https://discuss.elastic.co/t/convert-0-50-to-float-converts-it-to-0-00/228561/4 "2020-04-17T23:04:03Z")
A mutate filter performs operations in [a fixed order](https://www.elastic.co/guide/en/logstash/current/plugins-filters-mutate.html#plugins-filters-mutate-proc_order). convert executes before gsub, so when the gsub executes [Spend] is already equal to 0.0. Split that into two mutate filters.
---
### Author:  [@Yaniv\_Nuriel](https://discuss.elastic.co/u/Yaniv_Nuriel)
#### Post date: [April 18, 2020, 7:15am UTC](https://discuss.elastic.co/t/convert-0-50-to-float-converts-it-to-0-00/228561/5 "2020-04-18T07:15:22Z")
Understood!
You're the best
This is the fix
```auto
mutate{
gsub => ["Spend", "\$", ""]
}
mutate{
convert => ["Spend","float"]
}
```
Here is the output:
```auto
{
"@version" => "1",
"@timestamp" => 2020-04-18T07:13:14.133Z,
"message" => "$0.80,200\r",
"host" => "Yanivs-MBP",
"path" => "/Users/yanivnuriel/logstash/data/ads/searchterms/us/one-line-17.txt",
"Bbb" => "200",
"Spend" => 0.8
}
{
"@version" => "1",
"@timestamp" => 2020-04-18T07:13:14.131Z,
"message" => "$0.55,100\r",
"host" => "Yanivs-MBP",
"path" => "/Users/yanivnuriel/logstash/data/ads/searchterms/us/one-line-17.txt",
"Bbb" => "100",
"Spend" => 0.55
}
```
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 16, 2020, 7:15am UTC](https://discuss.elastic.co/t/convert-0-50-to-float-converts-it-to-0-00/228561/6 "2020-05-16T07:15:25Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.