Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 ...
Interesting Links
Need Help
Tips and Tricks
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    hi Anonymous

     

    You can do this with a Conditional Column in Query Editor

     

     

    And if you have problem with Android and ANDROID (Case sensitive) (Following ImkeF suggestion)

     

    you can modify the M Code to:

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hello, I tried to do what you suggested and succeeded. Thank you so much for your help. Really appreciate it. :cathappy:

 

I just wanted to understand, what if there were Blank values in the column and I want to include that along with Android and IOS. Is there a way to do that too?

 

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Anonymous

 

You can add a new condition in the Conditional Column to IOS. ---> IOS And ELSE Condition  leave blank or enter "Other OS".

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thank you so much for sharing the information. I really appreciate it