I wanted to extract the data after the date and should not include the company , Ive tried using regex but does seem to solve it . The output for example should be “MARK LATIN” , but its hard to consider since the data is dynamic and we have to consider spaces.
“06/16/2020 MARK LATIN TOYOTA COMPANY XLS”
output : MARK LATIN
“06/16/2020 Jhon Vios Test COMPANY 101 XLS”
output : Jhon Vios