Hi All, Appreciate if someone could help me with situation; this seems to be to be simple but I'm breaking a sweat. Column 1 is what I have and column 2 is what I require; it always starts with text 'BudCod' and end with 4 digits total length is 10 and it can appear any part of the string Column 1 Column 2 2020-08-ALP-venodr-BudCod1234-B241 BudCod1234 levelInfoBudCod1121, All- included BudCod1121 Service vendor BudCod1217, all BudCod1217 Supplier, excluding BudCod1351 BudCod1351 BudCod1782 vendorlevelinfo BudCod1782 levelInfoBudCod1020Allincluded BudCod1020 BudCod13200120200812467595 BudCod1320

Finding a substring within a string

PJ2020

Hi All,

Appreciate if someone could help me with situation; this seems to be to be simple but I'm breaking a sweat.

Column 1 is what I have and column 2 is what I require; it always starts with text 'BudCod' and end with 4 digits total length is 10 and it can appear any part of the string

Column 1	Column 2
2020-08-ALP-venodr-BudCod1234-B241	BudCod1234
levelInfoBudCod1121, All- included	BudCod1121
Service vendor BudCod1217, all	BudCod1217
Supplier, excluding BudCod1351	BudCod1351
BudCod1782 vendorlevelinfo	BudCod1782
levelInfoBudCod1020Allincluded	BudCod1020
BudCod13200120200812467595	BudCod1320