How to generate new strings randomly out of one string

Help Robot
,
1

Hi guys,

Let’s say I have the following string :

‘‘His name is john, he lives in Canada and he loves soccer’’

I want john, canada and soccer to be interchangeable using 3 lists of nouns (name, country, sport) available inside an excel sheet in order to generate one new random string and store it inside a variable, how can I achieve that in Uipath ?

Many thanks

Kaiji

2

Hi @kaiji_San

U want to split the word and write the words in an excel sheet

Use regex expression to get the individual values and use build datatable and use add data row activity

Thanks
Ashwin S

3

Hi @kaiji_San

Check the attached xaml file. Instead of Build Data Table You can use Read Range to read the excel file.

String.xaml (8.2 KB)