We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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.

How do I select lines starting with specific number

Aamir651
6 - Meteoroid
‎10-23-2021 01:37 AM

How do I select lines starting with specific number from a data on workflow, say all numbers starting from "01", "02", "03"

Labels:
Reply
1 REPLY 1
atcodedog05
22 - Nova
22 - Nova
‎10-23-2021 02:50 AM

Hi @Aamir651 

 

Two ways you can do this

 

1st way: using startswith() function

atcodedog05_1-1634982593683.png

 

2nd way: using find and replace tool matching begins with 

atcodedog05_2-1634982636674.png

 

Hope this helps : )

0102.yxmd
Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All