# Ruby filter: Ruby exception occurred

**URL:** <https://discuss.elastic.co/t/ruby-filter-ruby-exception-occurred/128550>\
**Category:** Logstash\
**Created:** [April 18, 2018, 2:21pm UTC](https://discuss.elastic.co/t/ruby-filter-ruby-exception-occurred/128550 "2018-04-18T14:21:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![donovans](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@donovans](https://discuss.elastic.co/u/donovans)\
**Post date:** [April 18, 2018, 2:21pm UTC](https://discuss.elastic.co/t/ruby-filter-ruby-exception-occurred/128550/1 "2018-04-18T14:21:35Z")

</div>

Hello all

I am trying to use a ruby filter to insert the current time if the 'End ' field from the csv is blank

here is part of my filter :

```
  filter {
    if [projectid] == "sampledata" {
      csv {
      columns =>["Number","Category","Subcategory","Priority","Incident_state","Created","Resolved","Closed","Value","Resolving_Group","Start","End"]    
      }

ruby {
    code => "
	   if event.get('End') =~ /^\s*$/
	   event.set('End',event.get('@timestamp'))            
           end
	   "
    add_tag => ["calculated_End_time"]
  }

```

The error code i am receiveing is :

[ERROR] 2018-04-18 14:27:10.835 [Ruby-0-Thread-10@[main]\>worker1: /usr/share /logstash/logstash-core/lib/logstash/pipeline.rb:392] ruby - Ruby exception occurred: invalid date: ""

Any help will be appreciated and thank you in advance

---

<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:** [May 16, 2018, 2:21pm UTC](https://discuss.elastic.co/t/ruby-filter-ruby-exception-occurred/128550/2 "2018-05-16T14:21:47Z")

</div>

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