Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Making Specific Letters Uppercase and Adding Characters to Specific Positions

RD
5 - Atom
Spoiler
 

Question1: I would like to make some letters "uppercase letters".

 

For example the cell may read: 

Title: random is great

Title: Random is bad

Title: easy is great

 

I was thinking how do I make the letter following a column either upper case or lower case to make it consistent across all my cells.

Using: Uppercase(Left([Title], 8)) + Substring([Title], 8, Length([Title]))--> I get TITLE: Random is great which is almost what I am looking for.

 

I would prefer it to be: Title: Random is great where the whole word title does not get capitalized and only make the 8th element uppercase.

 

Question 2: Similarly, how can I add the column right after Title on the 6th position?

 

Title Random is bad --> Title: Random is bad

 

Thanks!

 

 

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

@RD

 

Below, I am converting column 1 to uppercase and column 8 to uppercase.

 

uppercase(substring([Text],0,1)) +
substring([Text],1,6) +
uppercase(substring([Text],7,1)) +
substring([Text],8)

You can convert tiTlE to Tilte: (case inSEnsItIVE) with:

 

REGEX_Replace([TEXT],"title ",'Title: ',1)

Hopefully, this helps you.

 

Mark

 

 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels
Top Solution Authors