The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Extracting text from a Field

briankuhlmann
8 - Asteroid
‎08-27-2020 01:30 PM

I have attached a file with a small sample of the data. I need to extract just the letters from the data. Im having trouble because the number of characters is not uniform.

datasample.xlsx
Preview file
9 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor
‎08-27-2020 01:33 PM

Hi @briankuhlmann I mocked up a workflow let me know what you think?

Regex_Replace_27082020.yxmd
Reply
0 Likes
briankuhlmann
8 - Asteroid
‎08-27-2020 01:36 PM

works great, thank you!

Reply
Community Live
learn about the community summer cup
Labels
Top Solution Authors
View All