Spliting and Saving the Regex Output

[KP6689 (KP)]

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

[supermanPunch (Arpan)]

@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

[Pradeep_Shiv]

can you be more specific of what you are asking about?

[KP6689 (KP)]

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.

[KP6689 (KP)]

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

[Pradeep_Shiv]

ref_output(0) = VarForH
ref_output(1) = VarFor10

[KP6689 (KP)]

@Pradeep_Shiv

ref_output(0)

what will be the variable type?

[Pradeep_Shiv]

Ref_Output(0).ToString

[KP6689 (KP)]

Good Sir, worked like a dream. Many thanks

[Pradeep_Shiv]

Cheers
@KP6689
Happy Learning!

[KP6689 (KP)]

a follow up question, when Im passing these valued into Read cell , it throws the folloging error

[supermanPunch (Arpan)]

@KP6689 What is the Output Variable Type of Read Cell?

[KP6689 (KP)]

Got it, converted to generic value