How to separate (,)

[Kinetic_analytics]

Hello:

How can I separate the name

This input : JPMorgan Chase Bank, N.A., Mumbai

I want output separated with Comma (,) for instance, 

my desired output: 

JPMorgan Chase Bank, N.A.,                     Mumbai

Appreciate your help 

[IraWatt]

Hi @Kinetic_analytics 

Not sure I understand the question, your output is identical to your input besides some extra spaces 

[Kinetic_analytics]

I want the city name in the end separated.

[Luke_C · Accepted solution]

Hi @Kinetic_analytics 

Like @IraWatt said, you should provide more requirements. From what I can gather, you want to split out the value after the last comma into its own field. Something like the below should work. It would be good for you to provide more sample data when asking text parsing questions in order to get the best answer.

(.*),\s(.*)

[Kinetic_analytics]

Thank you. Appreciate your help on my learning process. :) 

[SPetrie]

If you are wanting to keep the comma, you can parse it with this regex

(.+)\s(.+)

otherwise this one would do it and remove the last comma

(.+),\s(.+)

[IraWatt]

Just for context this is how you would add extra spaces before the city name.