Solved - Reading part of a cell value

activities

#1

Hi All

Back again, help appreciated as always.

Is it possible to use the read cell function on excel, and then process the value that comes from that in order to check for a certain value?

To clarify in my example:

The date is read from an Excel cell (e.g. cell data would be 20082017 to represent 20/08/2017).
It is then output into a variable (InvoiceDate).

I want to know if it is possible to parse that variable at the month position (so 08 in the example) and see if it matches a value of another variable (previously set at an input dialogue asking what month it is e.g. 08 would of been entered in the box), and determine a match so that I can put a flow decision in to determine 2 separate processes.

Thank you in advance for any assistance.

Scott.


#2

Take a look in this example and see it helps. Let me know

Example.zip (8.2 KB)


#3

That’s exactly what I was looking for. Thank you Wellerson!

The only bit I changed was ToString.Substring(2, 6), as I needed to include the date and read from a starting index of 2 as I have no slashes.

Apart from that it was perfect, thanks!