Help

Insert a space before a capital letter

Solved
Jump to Solution
232 2
cancel
Showing results for 
Search instead for 
Did you mean: 
JM1234
6 - Interface Innovator
6 - Interface Innovator

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 

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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"
  )
)

 

 

kuovonne_0-1713759905758.png

 


 

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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"
  )
)

 

 

kuovonne_0-1713759905758.png

 


 

JM1234
6 - Interface Innovator
6 - Interface Innovator

Thanks v much!