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.
Sample Data
“06/16/2020 MARK LATIN TOYOTA COMPANY XLS”
output : MARK LATIN
“06/16/2020 Jhon Vios Test COMPANY 101 XLS”
output : Jhon Vios
hi,
you can try to split the data by space and then,
for eg :- in above scenario
I hope it helps.
The problem is that the comany text is not always present for example on this one
“06/16/1920 JHON MARK ALIBABA TRU”
OUTPUT : JHON MARK
Check the attached workflow @Jelrey,
Regex_Extraction.xaml (6.2 KB)
Hope this may help you 
Sir , can we also consider 3 spaces like for example
06/16/2020 MARK LATIN JUNIOR TOYOTA COMPANY XLS
OUPUT WOULD BE : MARK LATIN JUNIOR
LIKE MAX SPACE IS 3 , cause right now when the input is
06/16/2020 MARK LATIN JUNIOR TOYOTA COMPANY XLS
the output is only : MARK LATIN
what I need is MARK LATIN JUNIOR
Check this below updated workflow, @Jelrey
Regex_Extraction.xaml (7.5 KB)
Sorry for the delay
You can remove the for each from the above workflow and Input string you can keep it as single string, after that keep if condition and last message box to display.
@Manish450 , btw sir last thing , how can we extract text that are only capslock on the string ?
for example
08/11/2020 MY TEST HELLO Mortgage Company TRU
Output should be “MY TEST HELLO” since its the string that all capital letters , TRU should be excluded
