topic Re: How to extract Date from Day format in Dashboards & Visualizations

How to extract Date from Day format

aditsss — Sat, 23 Jan 2021 12:48:13 GMT

Hi All,

I have one field Rundatetime which is in below format:

10/25/2020 3:57

10/16/2020 5:22

I just want to extract Date from it as below:

10/25/2020

10/16/2020

How can I do that. Can someone guide me

My current query is this:

| inputlookup mnr_rally_defects2.csv| table Rundatetime

How to extract Date from Day format

termcap — Sat, 23 Jan 2021 13:25:07 GMT

| inputlookup mnr_rally_defects2.csv| eval date_today=substr(Rundatetime ,1,11)

Re: How to extract Date from Day format

gcusello — Sat, 23 Jan 2021 17:45:25 GMT

Hi @aditsss,

you can use the solution of @termcap, that surely works, or the following regex:

| rex field=Rundatetime "^(?<date>[^ ]+)"

Ciao.

Giuseppe

Re: How to extract Date from Day format

aditsss — Sat, 23 Jan 2021 17:31:44 GMT

@gcusello

I am not getting all the dates correct :

1/8/2021 3:

1/9/2021 3:

10/16/2020

10/17/2020

10/20/2020

10/25/2020

10/27/2020

11/14/2020

11/17/2020

11/18/2020

12/2/2020 3

12/24/2020

12/30/2020

Getting some values like below.

Re: How to extract Date from Day format

gcusello — Sat, 23 Jan 2021 17:34:22 GMT

Hi @aditsss,

for this reason I hinted to use rex instead substr!

Try again with my rex hint.

Ciao.

Giuseppe

Re: How to extract Date from Day format

aditsss — Sat, 23 Jan 2021 17:40:02 GMT

@gcusello

I used like this:

| inputlookup mnr_rally_defects1.csv| rex field=rundatetime "?(?<date>[^ ]+)"| table date

getting below error:

Error in 'rex' command: Encountered the following error while compiling the regex '?(?<date>[^ ]+)': Regex: quantifier does not follow a repeatable item.

Re: How to extract Date from Day format

gcusello — Sat, 23 Jan 2021 17:46:34 GMT

Hi @aditsss,

sorry!

there was a typing error, please try this:

| rex field=Rundatetime "^(?<date>[^ ]+)"

Ciao.

Giuseppe