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:

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity 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