Skip to content
Community Forums
Product Categories
Ideas Exchange
Community Gallery
Social Groups
Sign In
Community Forums
Community Forums
Home
›
Chris_Kent
›
Discussions
Chris_Kent
Member
Overview
Overview
Roles
Member
Badges
1
About Me
About Me
Analytics
4
Posts
15
Visits
2
Points
Apr 19, 2024
Join Date
Oct 24, 2024
Last Active
Reactions
No reactions yet.
Activity
Posts
1
Comments
3
Discussions
Filtering strings that contain letters
I want to filter out strings that contain letters in my ETL. e.g. Serial 112233 445566PN In the ETL Add Formula Column Name: IsInt CASE WHEN serialLIKE ('%[A-Z]%') THEN 0 ELSE 1 END EDIT CASE WHEN SER…
Answered ✓
Filters
Magic ETL
Formulas
Started by
Chris_Kent
Most recent by
Chris_Kent
Magic ETL
360
Apr 22, 2024
0
5
Activity
Posts
1
Comments
3
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In
Badges