Jump to content

MuddyW

New Members
  • Posts

    1
  • Joined

  • Last visited

MuddyW's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hello Regexperts, I have pulled a regex from the internet to seperate words that start with capital letters. The regex is here TEXTJOIN(" ",,REGEXEXTRACT(R158,REGEXREPLACE(R158,"([A-Z][a-z]+)","($1)"))) When I have this: HummelfilmTamtam FilmThe Imaginarium Films The Regex works and returns this: Hummelfilm Tamtam Film The Imaginarium Films But when I have this Nordisk Film ProductionNadcon FilmZweites Deutsches Fernsehen (ZDF) or this Zentropa International SwedenCanal+Ciné+ The Regex breaks. It looks like the presence of non alphanumeric characters is causing the problem. Can anyone please help me out and rewrite the Regex so that it works with non alphanumeric characters too?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.