for example
“08/11/2020 MY TEST HELLO Mortgage Company TRU”
“08/11/2021 MY TEST HELLO2 Mortgage Company XRL”
OUTPUT : MY TEST HELLO2
Output should be “MY TEST HELLO” since its the string that all capital letters , TRU should be excluded
for example
“08/11/2020 MY TEST HELLO Mortgage Company TRU”
“08/11/2021 MY TEST HELLO2 Mortgage Company XRL”
OUTPUT : MY TEST HELLO2
Output should be “MY TEST HELLO” since its the string that all capital letters , TRU should be excluded
@Jelrey use [A-Z ]+
Nope it includes others , ive tried it
@Jelrey use like below and then trim your result
([A-Z0-9]+ )(?=[A-z])