Quick Parse Text Issue!

[170290064]

i have some string values like in the following

“18 Ağustos2021”
“12 Ocak2020”
“24 Nisan2005”
.
.
.
.
.
It goes like this…

I want to correct them in a way like in the following (which means it has to be a space before the year);

“18 Ağustos 2021”
“12 Ocak 2020”
“24 Nisan 2005”
.
.
.
.
.

I do not want output like in the following

So tryna make it like that with a space

What should i do

[raja.arslankhan]

@170290064
Its one string or set of strings

[170290064]

There are more than hundreds…

So i ll make it with For Each in Data Table

[raja.arslankhan]

@170290064
Use assign activity

correctedValue = System.Text.RegularExpressions.Regex.Replace(originalValue, "(?<=[0-9])(?=[^\d\s])", " ")

[raja.arslankhan]

@170290064
Put assign activity inside for each loop and edit it through regex

[supermanPunch (Arpan)]

@170290064

So i ll make it with For Each in Data Table

Hi @170290064 ,

Considering that each String value to perform Space addition is One String and not A Single String containing all the data.

We can check with the below Expression :

System.Text.RegularExpressions.Regex.Replace(YourStrVar,"(.*)(\d{4}$)","$1 $2")

Visuals :

[170290064]

Nothing changed with this code

[170290064]

Thanks

Thanks @raja.arslankhan

[raja.arslankhan]

@170290064

outputString = System.Text.RegularExpressions.Regex.Replace(inputString, "(\d{4})", " $1")