We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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