Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

Hi!! 

 

Can you help me on this please 

 

kathbanc_1-1686646719904.png

 

6 REPLIES 6
ShankerV
17 - Castor

Hi @kathbanc 

 

One way of doing this.

 

ShankerV_0-1686647615852.png

 

Many thanks

Shanker V

 

ShankerV
17 - Castor

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

ShankerV
17 - Castor

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

kathbanc
8 - Asteroid

thank you @ShankerV!!

nagakavyasri
12 - Quasar

Another way:

Screenshot 2023-06-13 142920.png

kathbanc
8 - Asteroid

Thank you too @nagakavyasri

Labels
Top Solution Authors