Split string in reverse and replace with comma

Learn Academy Feedback
1

hello guys i have a 2 scenerios
1)
“PRINCETON, NJ 08540-6819”
this is string
i want this string look like “PRINCETON,NJ,08540-6819”
2)i have a another string
“SPIRIT LAKE, IA 51360”
i wanna have look like this “SPIRIT LAKE,IA,51360”
but the problem is when i use replace function
the ans i get is “SPIRIT,LAKE,IA,51360”(which is wrong)
pls help me

2

Hi @arjun27

You could use a regex to add the comma where it should be:

System.Text.RegularExpressions.Regex.Replace("SPIRIT LAKE, IA 51360","([A-Z]{2}) (\d+)","$1,$2")

This will change:
SPIRIT LAKE, IA 51360
into
SPIRIT LAKE, IA,51360

3

here i dont need to give space between spirit lake,IA

4

Hi @arjun27

Try…

  1. “PRINCETON, NJ 08540-6819”

ABC.Replace(" “,String.Empty) or ABC.Replace(” “,”")

Looks Like:
“PRINCETON,NJ,08540-6819”

Regards
Farhan

1 Like
5

Okay, let’s smartly remove all the spaces around the commas first:

System.Text.RegularExpressions.Regex.Replace("SPIRIT LAKE, IA 51360","\s*,\s*",",")

This will change
SPIRIT LAKE, IA 51360
into
SPIRIT LAKE,IA 51360

Now let’s add a comma where it should be:

System.Text.RegularExpressions.Regex.Replace("SPIRIT LAKE, IA 51360","([A-Z]{2}) (\d+)","$1,$2")

This will change:
SPIRIT LAKE,IA 51360
into
SPIRIT LAKE,IA,51360

1 Like
6

Fresh Excel.xlsx (23.3 KB)

Delivery_to(CityLocation).xaml (421.7 KB)

i have gave u my flow and excel sheet
u can filter according to length
u can find the ans in City_location column

8

Fresh Excel.xlsx (23.3 KB)

Delivery_to(CityLocation).xaml (421.7 KB)

i have gave u my flow and excel sheet
u can filter according to length
u can find the ans in City_location column

9

Deliver_CityLocation.xaml (37.3 KB)

Hi Arjun,
refer this it may help you.

1 Like
10

thanks
sanjay

ur workflow has solved my problem
Regards
Arjun