none
Replace all non-numeric values with null RRS feed

  • Question

  • How do I replace all non-numeric values in a data column with null?
    Tuesday, May 3, 2016 12:05 PM

Answers

  • Change the type of the column to either decimal or whole number. This will turn non-numeric values into errors. You can then replace errors with nulls.
    • Marked as answer by Nossrep M Tuesday, May 3, 2016 1:14 PM
    Tuesday, May 3, 2016 12:24 PM

All replies

  • Change the type of the column to either decimal or whole number. This will turn non-numeric values into errors. You can then replace errors with nulls.
    • Marked as answer by Nossrep M Tuesday, May 3, 2016 1:14 PM
    Tuesday, May 3, 2016 12:24 PM
  • Thanks!

    Simple solution that did the job perfectly!

    Tuesday, May 3, 2016 1:15 PM