How to extract data between 3 - 20 alpha numeric characters and 3
character strings like for exmple TRU below using regex
Data
"06/29/20 B QM 02004946 TEST HOME MORTGAGE TRU
03/10/20 B BC 2440720 BK OF TEST XPN
03/07/20 B QZ AZMSLDK42343 TEST COMP TRU
03/07/20 B QZ 123 MY TEST XL5
03/07/20 B QZ 00060298 CPORT RU TRU"
OUTPUT should be : TEST HOME MORTGAGE , BK OF TEST, TEST COMP , MY TES and CPORT RU .
Help would be much appreciated , thank you.
What I have so far
Main.xaml (6.5 KB)