Trying to save the output of Regex into two seperate variable as created from one.
Im trying to capture a cell reference, split it using Regex and trying to save the output in two seperate variables
like H10 in H & 10
any help is appreciated
Trying to save the output of Regex into two seperate variable as created from one.
Im trying to capture a cell reference, split it using Regex and trying to save the output in two seperate variables
like H10 in H & 10
any help is appreciated
@KP6689 What was the problem that you have encountered while performing this ?
Also more details of what the Input text is and what is the Regex used could be more helpful
can you be more specific of what you are asking about?
Regex.xaml (7.4 KB)
for each activity is doing the task of splitting H10 into H & 10, i want to save them in two variables.
Regex.xaml (7.4 KB)
well actually i want to get the use these variables to parse the excel rows further once the target element is located
ref_output(0) = VarForH
ref_output(1) = VarFor10
Ref_Output(0).ToString
Good Sir, worked like a dream. Many thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.