Replacing text in string with wildcard

Help
1

Hello,

I’m attempting to:

  1. ‘Add Wildcard Sequence’ - Replace part of the text in a string with a wildcard

Untitled

  1. ‘Match in FAME Sequence’ - Then use this string to match against another data table

The data table joining works fine but the wildcard replacement doesn’t appear to be working.

FAME Validation.xaml (32.9 KB)

2

@jon1302

FAME Validation.xaml (39.4 KB)

as i dont have input excel files so i made some changes based on assumptions please run the code and let me know.

3

Thank you, i’ve run my data through though one of the columns (SupplierTitle2) in the output ‘test’ excel is displaying duplicate values. Attaching the data:
Input:
Invoice Data.xlsx (712.9 KB)
CosOver5Employees_UKEir.xlsx (30.0 KB)

Current Output:
Test.xlsx (29.5 KB)