Hi experts, I’m trying to use the look-up activity to look up the company name in the excel file and return the banks which the company uses. However, it only returns the first bank that the robot is able to look up. For example, the company uses ICBC, BOC and Citibank. My process is only able to c…

Returning multiple value for lookup table

Gokul001 (Gokul Balaji) November 19, 2022, 7:59am 2

Can you share the sample text

You can try with Regex to extract the first string

System.Text.RegularExpressions.Regex.Match(YourString,"^\S*").Tostring

Regards
Gokul

Topic		Replies	Views
Multiple lookup values Help datatable , excel , studio	8	10347	September 19, 2019
For each excel row issue StudioX studiox , question	3	939	May 15, 2021
Lookup two data tables Activities excel	3	1788	May 21, 2022
Lookup multiple values or multiple columns and get the result from the third column Activities datatable , excel	3	4437	November 17, 2020
Look up data table only finds first match Activities uiautomation , activities , question	6	198	May 21, 2024