Hello,
I get an initial table as follow, the column `Marks` are stored in V_WString:
Name | Marks |
Mary | 10 |
Joe | U |
John | 42 |
Cherry | NA |
And I would like to do the transformation and add a new column which moves the `U` and `NA` only
The expected result would be:
Name | Marks | Marks_remark |
Mary | 10 | |
Joe | U | |
John | 42 | |
Cherry | NA |
Any ideas on how to do that are highly appreciated.
Thank you,
解決済! 解決策の投稿を見る。
Hi @edward_chow
One way of doing this...
Marks_Remark
IF contains([Marks],"U") OR contains([Marks],"NA")
THEN [Marks]
ELSE null()
ENDIF
Marks
IF contains([Marks],"U") OR contains([Marks],"NA")
THEN null()
ELSE [Marks]
ENDIF
Many thanks
Shanker V
Thanks for your answer. But may I ask another question?
I may not elaborate very explicitly. What if I want to use the regular expression match functions?
This is because the data may not only contains `U`, `NA`, there is a chance that the users input other words.
So the ultimate goal is to mtach the words that are not numbers and move them in another column.
Thanks!