How to split the given text from a website

Help Studio
, , , ,
1

Hello,
In a project I am doing, I need to pull the text of a name. When I use “get text” activity, for example it provides this: “2/20/2022 2:05:11 PM5 seconds agoLong Keys Bike Club” All I want is “Long Keys Bike Club”. How would I split the string to only provide this name?

2

Hey @RPALearner_17 ! Try this!

image
image1920×1022 81 KB 

System.Text.RegularExpressions.Regex.Match( "2/20/2022 2:05:11 PM5 seconds agoLong Keys Bike Club","(?<=ago)[\s\S]*").ToString

image
image1920×1018 77.7 KB

Hope it helps!

3

That worked thank you!! I have another question, so it refreshes and will be a new date, time, duration of post, and property name. How could I possibly split that?

4

Great!!! Regardless of date, time, duration of post, and property name this regex will always get what is after the String “ago”. If you always have that rule, you’ll get it.

5

So i tried again today, with my sequence and it says “unrecognized escape sequence”
image

to add more context, I pull from the site using “Get Text” I set the text to be variable propname. To use the “propname” of whichever property name appears, how would I utilize that in the code?

6

I guess you are using a C# project instead VB project

7

am I able to switch over to VB easily?

8

Only for Studio Pro version

Use the following steps to convert your project from “C#” to “VB.Net ”

  • Open the “project.json” file in your preferred code editor (I used Notepad++)
  • Scroll down until you find “expressionLanguage”: “CSharp”,
  • Change “expressionLanguage”: “CSharp”, to “expressionLanguage”: “VisualBasic”,
  • Re-launch your project and continue with VisualBasic Legacy

Reference: Convert C# to VB.NET - #2 by andrew_Rogers

If you don’t have the PRO version of Studio, create a new project.

9

It works! thank you!!

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.