Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Daydream]

Need some help when the resident experts in all things regex return from vacation

I have some filenames with the following pattern

0348 - JohnDoe - SomePlaceInTheWorld - alphanum3r1c

I want to space out SomePlaceInTheWorld to Some Place In The World; before every capital letter I want a space inserted, for however many capital letters that group has (preferably not in front of the first letter - S here - but that's not imperative, I can replace double spaces).

Thanks for any ideas.

[fridden]

0348 - JohnDoe - SomePlaceInTheWorld - alphanum3r1c

Perhaps the following expression can be of use:

=if(Regex([Name],/#(\d+ - \w+? - )(\w+?)( - .*)#/),[R1]fixspacing([R2])[R3],[Name])

/fridden

[Daydream]

<facepalm> There is a FixSpacing function, eh...! Probably been there for a couple of years too.

Thanks for the heads-up, I can probably fix stuff now even without regex.