
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 20, 2024 02:13 PM
Hi I have a file name / string of text
e.g. 'ThisIsTheFileName'
I would like to insert a space before each capital letter. Is there a formula to do this?
Thanks
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 20, 2024 07:30 PM - edited ‎Apr 21, 2024 09:26 PM
Try something like this. I’m not on a computer so I cannot test it to be sure.
I got to a computer and tested it out. There was a typo in the regex function name (which I have fixed), but the logic (and the regex pattern itself) was good. By the way, I'm assuming that you do not want a space before the first capital letter.
TRIM(
REGEX_REPLACE(
{Name},
"([A-Z])",
" $1"
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 20, 2024 07:30 PM - edited ‎Apr 21, 2024 09:26 PM
Try something like this. I’m not on a computer so I cannot test it to be sure.
I got to a computer and tested it out. There was a typo in the regex function name (which I have fixed), but the logic (and the regex pattern itself) was good. By the way, I'm assuming that you do not want a space before the first capital letter.
TRIM(
REGEX_REPLACE(
{Name},
"([A-Z])",
" $1"
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 02, 2024 08:20 PM
Thanks v much!
