Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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.

PARSING OF STRING

kathbanc
8 - Asteroid
‎06-13-2023 01:58 AM

Hi!! 

 

Can you help me on this please 

 

kathbanc_1-1686646719904.png

 

Reply
0 Likes
6 REPLIES 6
ShankerV
17 - Castor
‎06-13-2023 02:13 AM

Hi @kathbanc 

 

One way of doing this.

 

ShankerV_0-1686647615852.png

 

Many thanks

Shanker V

 

Reply
0 Likes
ShankerV
17 - Castor
‎06-13-2023 02:15 AM

Hi @kathbanc 

 

Step 1: Input

 

ShankerV_0-1686647666476.png

 

 

Step 2:

 

ShankerV_1-1686647682439.png

ShankerV_2-1686647691235.png

 

Step 3:

 

ShankerV_3-1686647713335.png

 

ShankerV_4-1686647723157.png

 

"pedestrian."+[2]

 

Many thanks

Shanker V

Reply
0 Likes
ShankerV
17 - Castor
‎06-13-2023 02:18 AM

Hi @kathbanc 

 

Adding the data cleansing tool, will help to get the below result.

 

ShankerV_0-1686647876528.png

 

ShankerV_1-1686647892556.png

 

Many thanks

Shanker V

Reply
kathbanc
8 - Asteroid
‎06-13-2023 05:21 AM

thank you @ShankerV!!

Reply
nagakavyasri
12 - Quasar
‎06-13-2023 11:30 AM

Another way:

Screenshot 2023-06-13 142920.png

New Workflow12.yxmd
Reply
kathbanc
8 - Asteroid
‎06-13-2023 08:10 PM

Thank you too @nagakavyasri! 

Reply
0 Likes
Christmas in July Blog
designer new user guide
Labels
Top Solution Authors
View All