Grok pattern to format a special date and scientific notation number


I'm looking for two special patterns to convert a date with a special format and to convert a number with scientific notation.

For the date, I've got this format yyyyMMdd_hh:mm:ss (ex: 20181204_10:50:07)

For the scientific notation, here's what I've got and what I want :

  • 2.474731e+01 => 24.74731
  • 2.211762e+00 => 2.211762
  • 9.629999e-01 => 0.9629999

Thanks for your help

You may need to split the input into multiple fields and then use a ruby filter to manually multiple field A by field B.

1 Like

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