Divide String ABCadMunicipalMarketBudget to ABCad Municipal Market Budget

[saachitalwar]

How can I transform a string like the aforementioned method

[BS_THE_ANALYST]

@saachitalwar please don't drip feed the test cases. It's not good for anyone's time. 

If you have a complete list of test cases, provide them. 

All the best,

BS

[saachitalwar]

test cases:

ABCad100%U.S.Budget - required - ABCad 100% U.S. Budget

ABCadU.S.MarketBudget - ABCad U.S. Market Budget

MainFundABC - Main Fund ABC

[OllieClarke]

HI @saachitalwar 

I think I've captured all your test cases. As @BS_THE_ANALYST said, if there are more then please provide a full list. RegEx works by spotting patterns, and if the data is incomplete, then it's very likely the patterns we've spotted aren't accurate.



Instead of writing one complicated RegEx, I've used multiple iterations of simpler ones.

Hope that helps,

Ollie

edit: Apologies, was a typo in my initial post. Updated now

[Raj]

@saachitalwar 
hope this helps.