Extract first text appearing

[shilpashree.mohanty]

Suppose one of my column contains below data,
ACH UID R00
DESCRIPTIVE TEXT DIREC, LLC VENDOR PMT 5
DESCRIPTIVE TEXT COMPANY NAME: DIREC, LLC

my query is as,

• use the Payor Mapping Table to search Trax Column M (“REMITTANCE_INFORMATION”) for the first word after the first instance of “DESCRIPTIVE TEXT ”. This value is the payee name. Then the corresponding “Medea Upload Name” should be populated in the Medea Upload file Column H using the lockbox mapping table.
  • The wording “DESCRIPTIVE TEXT” appears several times the cell, however, the payor name is found only after the first “DESCRIPTIVE TEXT.”

It means, the above bold is Column M, and once i found the first word after the first instance of “DESCRIPTIVE TEXT", i need to search that word in another sheet’s columnB and fetch the column A value from it

[Anil_G (Anil Gorthi)]

@shilpashree.mohanty

you can use this in match text activity or in match regex option

(?<=DESCRIPTIVE TEXT +)\w+

cheers