Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4644 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I need to import a file that has a field in which the individual words in a name have been combined into one word (i.e. SmithRooftopBuilding). I need a calculation that would separate the words at each capital letter so that it would read "Smith Rooftop Building". I assume the easiest way to do this would be to write a calculation that inserts a space before each 2nd capital letter in a text string. However, I'm having a hard time doing it.

Any help would be appreciated.

Posted


Trim (

Substitute (

  Tips::Raw ;

       [ "A" ; " A" ] ; [ "B" ; " B" ] ; [ "C" ; " C" ] ; [ "D" ; " D" ] ; [ "E" ; " E" ] ; [ "F" ; " F" ] ; [ "G" ; " G" ] ;

       [ "H" ; " H"] ; [ "I" ; " I" ] ; [ "J" ; " J" ] ; [ "K" ; " K" ] ; [ "L" ; " L" ] ; [ "M" ; " M" ] ; [ "N" ; " N" ] ;

       [ "O" ; " O" ] ; [ "P" ; " P" ] ; [ "Q" ; " Q" ] ; [ "R" ; " R" ] ; [ "S" ; " S" ] ; [ "T" ; " T" ] ; [ "U" ; " U" ] ;

       [ "V" ; " V" ] ; [ "W" ; " W" ] ; [ "X" ; " X" ]; [ "Y" ; " Y" ] ; [ "Z" ; " Z" ]

    )

)

This topic is 4644 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.