Extracting information from string and creating new variable

Question

I have a column with big character strings like this:

"[{'tipoTeste': 'RT-PCR', 'estadoTeste': 'Concluído',
'dataColetaTeste': {'__type': 'Date', 'iso': '2021-12-30T03:00:00.000Z'}, 
'resultadoTeste': 'Detectável', 'loteTeste': None, 
'fabricanteTeste': None, 'codigoTipoTeste': '1', 'codigoEstadoTeste': '3', 
'codigoResultadoTeste': '1', 'codigoFabricanteTeste': None}]"

And i want to create another variable called Date with the date information inside this huge string, in this case is 2021-12-30

Im not managing to grep this date information for all rows....

does your string contain \n ie linebreaks?

Onyambu
– Onyambu

2022-06-10 14:50:26 +00:00
Commented Jun 10, 2022 at 14:50 — Onyambu
– Onyambu, Commented Jun 10, 2022 at 14:50

user438383 · Accepted Answer · 2022-06-10 14:49:39Z

1

This would work:

library(stringr)
str_extract_all(str, "[0-9]{4}-[0-9]{2}-[0-9]{2}")

[[1]]
[1] "2021-12-30"

answered Jun 10, 2022 at 14:49

user438383

6,30710 gold badges32 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

akrun · Accepted Answer · 2022-06-10 15:27:11Z

1

We could use parse_date directly on the string

library(parsedate)
> as.Date(parse_date(str1))
[1] "2021-12-30"

data

str1 <- "[{'tipoTeste': 'RT-PCR', 'estadoTeste': 'Concluído',
'dataColetaTeste': {'__type': 'Date', 'iso': '2021-12-30T03:00:00.000Z'}, 
'resultadoTeste': 'Detectável', 'loteTeste': None, 
'fabricanteTeste': None, 'codigoTipoTeste': '1', 'codigoEstadoTeste': '3', 
'codigoResultadoTeste': '1', 'codigoFabricanteTeste': None}]"

answered Jun 10, 2022 at 15:27

akrun

891k38 gold badges590 silver badges700 bronze badges

Collectives™ on Stack Overflow

Extracting information from string and creating new variable

2 Answers 2

Comments

data

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

data

Comments

Your Answer

Sign up or log in

Post as a guest

Related