In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to extract the first letter from Text?

phoebe_90
8 - Asteroid

For example

The initials of TextText
PP2311HJKL
RR2301OBY0
ZZ2309NW0
1 REPLY 1
ed_hayter
12 - Quasar

With a formula tool you could use LEFT([Text], 1) to get the first character. It does not care whether it is a letter or symbol or number though.

Labels
Top Solution Authors