Vignesh Kannan Posted May 29, 2020 Share Posted May 29, 2020 1ST DOUBT: the row data in a column is like AB000/24/32 i need to extract data only when data is having AB000 OR AB000/AB001 IF DATA IS LIKE AB000/AC000 IT SHOULD FALL UNDER THE FALSE CONDITION (DATA TYPE IS STRING) Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted May 29, 2020 Share Posted May 29, 2020 First you'll want to split this column opening the Data Panel and clicking on 'Split Column' using the "/" as the split characters. Then add a new calculated column with an expression like: case when ([value (Split 1)]="AB000") and ([value (Split 2)]="AB001") then "True" when ([value (Split 1)]="AB000") and (left([value (Split 2)],1)"A") then "True" else "False" end Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now