How to import data from email on R

[adpm]

Hello,

I usually receive emails as follows: https://imgur.com/zPfssWV

When I import it, it appears like this

And I want it to look this way: https://imgur.com/8QEC8cU . How can I get it?

[andresrcs]

You could use tidyr::separate(), if you need more specific help, please provide a proper REPRoducible EXample (reprex) illustrating your issue.

[phiggins]

the separate function in the tidyr package is essential.
You may also need to use some regex (regular expressions) to define the separators. The RVerbalExpressions package is often helpful for this.

Create Regular Expressions Easily