# Strings to numerics

**URL:** <https://discuss.elastic.co/t/strings-to-numerics/265090>\
**Category:** Elasticsearch\
**Created:** [February 22, 2021, 3:44pm UTC](https://discuss.elastic.co/t/strings-to-numerics/265090 "2021-02-22T15:44:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marc2](https://avatars.discourse-cdn.com/v4/letter/m/58956e/32.png) [@Marc2](https://discuss.elastic.co/u/Marc2)\
**Post date:** [February 22, 2021, 3:44pm UTC](https://discuss.elastic.co/t/strings-to-numerics/265090/1 "2021-02-22T15:44:20Z")

</div>

Hello community!

I am new at this and my problem is the following:

I am trying to use some .csv files to represent data in Kibana, and to do that i am using the code i found on this web: [Converting CSV to JSON in Filebeat](https://alexmarquardt.com/2020/03/17/converting-csv-to-json-in-filebeat/)

I think that method is quite useful, but when I try to use the data I can't do so beacause it appears as a string between double quotes. How can i modify the code to get numeric values instead?

My filebeat.yml looks like this:

```
    max_procs: 1 # This code will not work correctly on multiple threads
     
    filebeat.inputs:
    - type: log
      enabled: true
      close_eof: true
      paths:
        - C:\Users\Marc\Desktop\test.csv

      processors:
      - decode_csv_fields:
          fields:
            message: decoded_csv_arr
          separator: ","
          ignore_missing: false
          overwrite_keys: true
          trim_leading_space: false
          fail_on_error: true

      - script:
          lang: javascript
          id: convert_csv_into_json
          file: C:\Users\Marc\Desktop\convert_csv_to_json.js

      - drop_fields:
          fields: ["decoded_csv_arr"]

    output.elasticsearch:
      hosts: ["localhost:9200"]

      index: "csv_to_json-%{+YYYY.MM.dd}" 

    setup.ilm.enabled: false
    setup.template.enabled: false

```

And the .js file referred in the .yml is this:

```
// This function takes an array containing the field names, and another that
// contains field values, and returns a json dictionary that combines them.
function convert_csv_to_dict(csv_headers_row, csv_values_row) {
  var json_from_csv = csv_values_row.reduce(function(result, field, index) {
    result[csv_headers_row[index]] = field;
    return result;
  }, {})

  return json_from_csv;
}

// Define the JavaScript function that will be used to combine the 
// header row with subsequent rows in the CSV file
var headers_fn = (function() {
  var csv_headers_row = null; 

  // Use a JavaScript closure to store the header line (csv_headers_row), 
  // so that we can use the header values for all subsequent CSV entries. 
  return function(csv_arr) {

    var json_from_csv = null;

    if (!csv_headers_row) {
      // if this is the first row, store the headers
      csv_headers_row = csv_arr;
    } else {
      // combine the csv_headers_row with the values to get a dict
      json_from_csv = convert_csv_to_dict(csv_headers_row, csv_arr)
    }
    return json_from_csv;
  }

})();  

// This function is called for each "event" 
// (eg. called once for each line in the log file)
function process(event) {
    var csv_arr = event.Get("decoded_csv_arr");
    var json_from_csv = headers_fn(csv_arr);

    // If the current event was triggered to process the header row,
    // then the json_from_csv will be empty - it only returns a json dict
    // for subsequent rows. Cancel the event so that nothing
    // is sent to the output.
    if (!json_from_csv) {
      event.Cancel();
    }
    event.Put("json_from_csv", json_from_csv);
}

```

Thank you so much for your help!

---

<div class="post-metadata">

**Author:** ![Iker](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/iker/32/91708_2.png) [@Iker](https://discuss.elastic.co/u/Iker)\
**Post date:** [February 22, 2021, 4:46pm UTC](https://discuss.elastic.co/t/strings-to-numerics/265090/2 "2021-02-22T16:46:23Z")

</div>

I noticed in you filebeat configuration, that you have disabled the default template; so I'm assuming that you have a custom mapping, if you specify in the mapping the field as numeric, Elastic would convert it automatically for you; another option could be the brand new runtime fields. [Dynamically Created Runtime Fields - YouTube](https://www.youtube.com/watch?v=s6BNXA5o0rY)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 22, 2021, 4:46pm UTC](https://discuss.elastic.co/t/strings-to-numerics/265090/3 "2021-03-22T16:46:59Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.