Replace Space & Dots with '_' symbol

[Sathish_Kumar_S]

result.xlsx (9.4 KB)

Data available in DT is available in attached excel

Requirement –

Trying to manipulate the values available in Key column to assign as file name for the file the bot is going to download.

1. Replace “Space” with “_” in the value available in “Key” Column

2. Replace "Dot (s) with “_” in the value available in “Key” Column ( Only if “Dot” available… Because sometimes the “Dot” will not be available in "Key column)

3. Store manipulated Key value to String variable

Note : Already stored downloaded file extension in str_extention variable

Example 1 :

Input text : PV 1.3.2

Expected output in str : PV_1_3_2.pdf

Example 2 :

Input text : KR 80034

Expected output :KR_80034.pdf

[Shiva_Nikhil]

@Sathish_Kumar_S

try this

Sequence.xaml (9.9 KB)

[Sathish_Kumar_S]

Sorry for the confusion @Shiva_Nikhil

We have this excel data in Datatable and using For Each Row in Data Table activity to reach “Key” column values

and need to store the manipulated values in string

[Shiva_Nikhil]

@Sathish_Kumar_S

Try this

Sequence.xaml (16.2 KB)

[ppr (Peter Preuss)]

we recommend to ensure that the Basics are quickly checked and maybe some skill-set plans are to setup

[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum