PARSING OF STRING

[kathbanc]

Hi!! 

Can you help me on this please 

[ShankerV]

Hi @kathbanc 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @kathbanc 

Step 1: Input

Step 2:

Step 3:

"pedestrian."+[2]

Many thanks

Shanker V

[ShankerV]

Hi @kathbanc 

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

Many thanks

Shanker V

[kathbanc]

thank you @ShankerV!!

[nagakavyasri]

Another way:

[kathbanc]

Thank you too @nagakavyasri!