Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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