How to find the last line in the text in cell

[Paulina]

Hi everyone,

In word document I have table like this:

The table was created by data scraping. I need to extract the last row from the text column, which is in this case: dddddddd

How could I do that? Any suggestions? Please help.

[william.coulson (Will Coulson)]

Hi @Paulina,

Try scaping the entire cell and then splitting the lines up and taking the last item. If they are split up by new lines, try:

StringVar.Split({system.environment.NewLine},StringSplitOptions.None).Last

How are you scraping the table/cells?

[Yoichi]

Hi,

Another solution, FYI :

System.Text.RegularExpressions.Regex.Match(cellData,".*$").Value

Regards,