1
$\begingroup$

I am using tibco spotfire and I have columns with data like this "0001V", "0002V", "0003N". I know data with the 'N' at the end is not valid so I need to delete the numbers which have that. I think I should use "limit data using expression" but I don't know how to write the expression. So it should be something like "if X ends in 'N' delete X"... Could you help me please?

Thanks!

$\endgroup$

closed as off-topic by Toros91, Stephen Rauch, Benji Albert, Icyblade, Spacedman May 11 '18 at 11:04

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This question does not appear to be about data science, within the scope defined in the help center." – Toros91, Stephen Rauch, Benji Albert, Icyblade, Spacedman
If this question can be reworded to fit the rules in the help center, please edit the question.