Reading the last line in an Excel cell

[firas (Firas Abussaud)]

Hello All,

I am working on an automation and i have a question that seems to be easy but i could not figure out how to do it.

I have a table that has one cell with multiple lines and i need to extract only the last line. this cell changes everyday and the number of lines is not constant.

I am using StudioX

[Tapan_Behera1 (Tapan Behera)]

Hi @firas try with

datatablevar.asenumerable.last()

[firas (Firas Abussaud)]

Thank you for your prompt reply.

i tried it as below but it did not work; what is wrong in my work?

[Tapan_Behera1 (Tapan Behera)]

in what to write field just write

stirng.join(“”,LastRowValue)

[firas (Firas Abussaud)]

@Tapan_Behera1

stirng.join(“”,LastRowValue)

thank you again…

now i am getting this message

[Tapan_Behera1 (Tapan Behera)]

Could you send me the workflow…?

[firas (Firas Abussaud)]

Sure!
Here we go
TestingLastLine.zip (191.8 KB)

[Tapan_Behera1 (Tapan Behera)]

TestingLastLine.zip (62.4 KB)

Here I am using regex because of your sentences are in single cell. not in rows.

[firas (Firas Abussaud)]

wonderful!!

Thank you so much…this is what i wanted but how can i include even the first part of the line that shows the time?

20:00: Work was done

now it is only saving: Work was done

[Tapan_Behera1 (Tapan Behera)]

Okay try this:

TestingLastLine.zip (62.4 KB)

[firas (Firas Abussaud)]

Perfect!

thank you so much