How to provide a regular expression in look up data table

Hi All,

I have a situation where I need to get the ticket number from excel, the column index of the ticket number may vary at times, but the column name remains static, so I thought of using the lookup data table so that I can get the ticket number from that column since the ticket number will be varying what data can be provided in the LookUpValue property.
FYI: there will be only one ticket number per excel

Hello @Megha_D_Gowda :wave:

In the Lookup Value property, use Regex.Matches() like Regex.Matches([A-z]*)

Cheers!