Web Scraping, Partial match for DataTable column name

Help
1

Hi, I am querying a finance site for stock prices. Sometimes the column is named “Close” and sometimes it is named “Close*”. How do I access the column values in this case via partial match?

E.g. usually I would use ClosePrice = Convert.ToDouble(SiteRow(“Close”).ToString)

Need this to work even if “Close” is spelled “Close*”

2

Hi @DEATHFISH

If either “Close” or “Close*” has same index in SiteRow.
You can use SiteRow(indexnumber) to replace SiteRow(“Close”) to make it work even if “Close” is spelled “Close*”.

3

Hi @wusiyangjia , for versatility purposes I would like it to find by column name, thanks

4

Hi @DEATHFISH

The second method, when scraping data from web page,
do not immediately extract the whole table,
one by one indicate each column by similar filed,
then you can set a certain name for “Close” or “Close*” column whatever you want.

5

Hi @wusiyangjia for the purposes of this project I need to extract the full data table

6

Hi @DEATHFISH

The last way, loop check each column of data table,
And if ColumnName.StartsWith(“Close”) is true, then assign a certain name for future use like below.
SiteDt.Columns.Item(index).ColumnName = “Close”

7

Is there a method to do this via Regular Expressions or Lambda Expressions?