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!
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
Free Trial

Alteryx Designer Desktop Discussions

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

Parse the first word out of a string

wonka1234
10 - Fireball
‎12-31-2022 09:45 AM

Hi,

 

I am having trouble parsing the first word out a string.

 

Ie 

 

Qualified - All fields - 11012021 - 11302021.zip
WPS Report (page 3) 11012021 - 11302021.zip

 

to become

 

Qualified
WPS
Labels:
Reply
3 REPLIES 3
Felipe_Ribeir0
16 - Nebula
‎12-31-2022 09:49 AM

Hi @wonka1234 

 

You can use the formula getword([Field1], 0) to get the first word

 

Felipe_Ribeir0_0-1672508969748.png

 

Parse the first word out of a string.yxmd
Reply
Emmanuel_G
13 - Pulsar
‎12-31-2022 11:33 AM

Hi @wonka1234 

 

Find in attachement another way to do that using regex expression.

 

Emmanuel_G_0-1672515192231.png

 

Parse the first word out of a string.yxmd
Reply
Felipe_Ribeir0
16 - Nebula
‎01-04-2023 12:03 PM

Hi @wonka1234 

 

It worked?

Reply
0 Likes
Find a local User Group
designer new user guide
Labels
Top Solution Authors
View All