Forum Discussion

mtran21's avatar
mtran21
New Contributor III
5 years ago

Convert UTC date to date

How do you convert this date “2020-09-01T00:00:00.000” to this “20200901”?
  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    9 months ago
    Copy LinkReport

    Not sure if JSONPath itself natively support case-insensitive comparison or regex matching directly(considering that it only returns single value). 

    • Don's avatar
      Don
      New Contributor II
      9 months ago
      Copy LinkReport

      Case insensitivity in native JSONpath is based on the engine.  The example from the first message in the thread :

      [?(@.email =~/yomomma@notreal.com/i )]

[?(/yomomma@notreal.com/i.test(@.email))]

      are from two of the libraries  supported in jsonquerytoole.com (dchester and Goessner).

      I have no idea which one Snaplogic is using, but I'm guessing neither of those as those examples don't work.