i want to replace 5 blank space to single space, 6 blank space to single space and 9 blank space to single space in the same string
can replace activity do it.
Hi @ashishmani,
Please try with Regex. Hope you have stored the string into a String Variable.
Now, try the below -
Regex.Replace(Your_String_Variable,“\s+”," ")
Hope it will help you.
Thanks & Regards,
Apurba
1 Like
the best way for this is using regex. For you case try this:
system.Text.RegularExpressions.Regex.Replace(your_string,“\s{5}”," “) and
system.Text.RegularExpressions.Regex.Replace(your_string,”\s{6}“,” ")
\s represent any space character
How use it?
Put a assign activity →
your_string = system.Text.RegularExpressions.Regex.Replace(your_string,“\s{5}”," ")
Just remember that you should first do the 9 space, then the 6 space, then the 5 space replace in that order 
1 Like
hi @ ashishmani,
or use replace in norlam
Like
to 5
YourString = YourString.Reaplce(" “,” “) ← 5 Times Space
to 6
YourString = YourString.Reaplce(” “,” “) ← 6 Times Space
to
YourString = YourString.Reaplce(” “,” ") ← 9 Times Space
this AND condition is not working here
there is no AND condition there, just do the replace 3 times one after the other…
my string type is "System.string[ .]
Please look at this: Main.xaml (5.0 KB)
In your screenshot seems like … your code having extra " and . remove last two digit in your code &
system.Text.RegularExpressions.Regex.Replace(your_string,“\s{5,9}”," ")
more than one Space use below code
system.Text.RegularExpressions.Regex.Replace(your_string,“\s{2,}”," ")
1 Like
1 Like
Please provide your input string or xaml.
Use a for each then…
still getting error
1 Like
use like you have in expression editor and lines.toString,"\s…
1 Like