I am trying to extract data for Event, Time, and Points from a college swimming database. I scraped the table just like normal and got the result I wanted except the scrape is yielding unwanted text
I don’t want the Event column to include the meet at which the event was swam (the second line). I tried to scrape the table differently so that it won’t include the meet name but it’s still yielding it even when i specifically drag the event name only.
Once the table is scraped its exported to a data table (duh) in the format I would like except the Event column has the unwanted text. I’m trying to remove that text. I’ve looked around at splitting the string by Environment.NewLine and whatever other advice is out there but it isn’t working.
I’m wondering if splitting a string inside a data table requires different syntax but all I could think to do was add a .ToString to the end.
What I’ve tried
Assign row(“Event”) = row(“Event”).ToString.Split(Environment.NewLine.ToArray, stringsplitoptions.RemoveEmptyEntries)
I’ve also tried the same thing, but with the vbCr delimiter in the NewLine’s place.
If you could help a rookie out I would really appreciate it