Extract only required values from website - Table extraction not working

Help Studio
,
1

Hi,
Trying to extract only the highlighted vales from website.

Table extraction is not extraction all the values or it is extracting field title as a another row insted of column name

An interface screenshot displaying program information, status, site details, and contacts for a submitted automotive project in the year 2026. (Captioned by AI)
An interface screenshot displaying program information, status, site details, and contacts for a submitted automotive project in the year 2026. (Captioned by AI)1211×653 67 KB

Here is the screenshot from Table extraction:

A table extraction interface in UiPath Studio displaying configurations for extracting data from a table with 6 columns and 3 rows. (Captioned by AI)
A table extraction interface in UiPath Studio displaying configurations for extracting data from a table with 6 columns and 3 rows. (Captioned by AI)906×736 43.9 KB

Expected output:

The image shows a spreadsheet with information about a local program for the 2025 model year, detailing submission milestones, program codes, status, and site numbers. (Captioned by AI)
The image shows a spreadsheet with information about a local program for the 2025 model year, detailing submission milestones, program codes, status, and site numbers. (Captioned by AI)1849×154 11.3 KB

expectedoutput.xlsx (10.5 KB)

2

Hi @Sathish_Kumar_S

Can you try with Get Text activity for each field

Regards,

1 Like
3

I need to perform this activity in multiple tabs and fields in this website.

Is there any regex command to extract the value before : and after and consider before : as title and after : as row value?

For Example :

A detailed form screenshot highlighting various fields and information with red-bordered labels, including program details, site information, submission status, and contact information. (Captioned by AI)
A detailed form screenshot highlighting various fields and information with red-bordered labels, including program details, site information, submission status, and contact information. (Captioned by AI)1223×653 88.3 KB

4

@Sathish_Kumar_S

You can use split function

Title = str.Split(“:”)(0)
Value = str.Split(“:”)(1)

Regards,

5

@Sathish_Kumar_S

here you need to get all the values from the application at that its better to get the data based on key and using get text activity, extract all values by using regex

lets assume for Site code

take one assing activity,

in To: strSiteCode(create a string variable)
in Value : System.Text.RegularExpressions.Regex.Match(yourgettextVar,“(?<=SiteCode:)(.\w+)”).tostring

this regex will give the value of Sitecode

like this you can implement for other fields as well, to practice on regex
https://regex101.com/ refer this site

If you found solution please mark this post as solution.

Happy Automation!!

6

From the screenshot, I dont think this is suitable for Table Extraction as there is no repetitive pattern

You might need to use Get Text activity wherever required

1 Like
7

I don’t have anything new to add, however I can expand on previous answers to hopefully clarify why this is not working.
This is not the case for Table Extraction. Table Extraction works best on tables (data contained in table element on websites), but can be used for other cases where there are multiple records of data on a single page. For example results on shopping sites, or list of webpages for search engines.
You’ve shown us a single page which holds data only for one record. The best approachew here would be:

  1. Use Get Text to get all marked field - one Get Text per one field
  2. Use Get Text to retrieve text from whole webpage and use Regex to retrieve values for each field

Try 1 and only go for 2 if 1 is too problematic to implement.

8

Hi @Sathish_Kumar_S

Use the Get Text activity for each field. If some of the fields having multiple values then use the Split function to split the values to get the multiple data.

Hope it helps!!