Remove space after comma

[Rohi2023 (Roseline Joy)]

I feel that this should be a relatively easy thing to do, but I am stumped. I have a date formatted as e.g. “29 Apr, 2024”. I need to remove the space after “,” to make it “29 Apr,2024”. How do I do this? TIA!

[ppr (Peter Preuss)]

@Rohi2023

29 Apr, 2024”

we can use the string replace method:

Assign Activity:
strCleansed =
YourStringVar.Replace(", ",",")

Or can use a regex

[Rohi2023 (Roseline Joy)]

I tried this but the space is still there. Regex confuses me

[Rohi2023 (Roseline Joy)]

My workaround was to split the string, then concatenate (with trim).

[ppr (Peter Preuss)]

@Rohi2023

I tried this but the space is still there

have a look here:

done with:

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

@Rohi2023

Regex confuses me

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

@Rohi2023

workaround was to split the string,

not recommended, as we can handle more simple as shown above

[Rohi2023 (Roseline Joy)]

Thank you so much for your help. I’m not sure why the replace function isn’t given me the same result. I however, found another solution using the Modify Date activity and providing my own custom format. This way I didn’t need to manipulate the string at all.

Thanks again. I have bookmarked the regex cheatsheet!

[ppr (Peter Preuss)]

perfect so the topic can be closed by marking the solving post

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has found…