Regular expression for variable cell

Help Something Else
1

image
image1256×249 6.78 KB

Hello everyone
How can i get the index of “08-juill”.
I know that i have to use index of but the problem is the cell value can change so i have to put it as a regular expression.

2

Hi,
You can used BalaReva Easy Excel activity to find the index of string in excel.

Find - Find the text inside the sheet. It will return the cell info as a array string and row indexes.

3

For example here:
I have to look for the position of “18-Jul” for each line
So I want to loop through each line to see where “18-Jul” is.
I thought of using lookup range whereas lookup range needs to have a determined string whereas I need a regular expression

image
image1249×268 7.31 KB