Forum Discussion
Removing few characters from rows
I have a column that contains versions of phones. It contains the following rows:
ios 8.3 (0.03K)
IOS 9.3.1 (1.49 k)
IOS 10.1
Android 5.0.1
Android 1.4.2 (OK)
IOS 9.3.2 (OK)
I have about 1 Million rows of data. I want to remove everything except IOS or Android. Is there a way i can achieve it?
8 Replies
you can filter in the query editor
ie. drop down the column you want with the arrow key like ive done on product and click on text filters and select contains
dd
In the query-editor, add a step to your table:
Filter = Table.SelectRows(<NameOfThePreviousStep>, each Text.Contains([MyColumn], "IOS", Comparer.OrdinalIgnoreCase) or Text.Contains([MyColumn], "Android", Comparer.OrdinalIgnoreCase))
This is hand-edited code from the standard-filter from the table-header, as you probably want a case-insensitive match here?
Thank you so much for the help everyone. But in a column that has both Android and IOS following the versions. I just want to create a column that specifies, whether it is an Android or an IOS operating system.
So my results should something like this:
IOS
IOS
IOS
Android
Android
IOS
Instead of:
ios 8.3 (0.03K)
IOS 9.3.1 (1.49 k)
IOS 10.1
Android 5.0.1
Android 1.4.2 (OK)
IOS 9.3.2 (OK)
Is there a DAX query for that, or any other way to do it?
Anonymous
Hello, To understand your Question, What is the difference between my answer and the result expected?.
