Hi,
i am looking to extract some data from a cell in google sheet that contains multiple data, however i need to capture the data, manipulate it before entering the data elsewhere. please see below.
the main data i need to capture is the WR number, there will be times when there will be a space between the WR and number e.g. wr 5748365 but other times it will be wr5648493
can anyone help me with this?
Has anyone got any suggestions?
Hi @nick.v
How to manipulate data on Google Sheets?
You can use UiPath.Gsuite.Activities, that package allows you to perform a variety of actions on Google services, including Google sheets
How to get the WR number?
You can extract that value from the cell value using Regular expressions. Here is a webpage where you can build your owns https://regex101.com/
Regards,
Andres