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
Hi @aditsss,
for this reason I hinted to use rex instead substr!
Try again with my rex hint.
Ciao.
Giuseppe
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.
Hi @aditsss,
for this reason I hinted to use rex instead substr!
Try again with my rex hint.
Ciao.
Giuseppe
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.
Hi @aditsss,
sorry!
there was a typing error, please try this:
| rex field=Rundatetime "^(?<date>[^ ]+)"
Ciao.
Giuseppe
| inputlookup mnr_rally_defects2.csv| eval date_today=substr(Rundatetime ,1,11)