Move the matched cell values to a new column

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,

Workflow

Tips and Tricks

Expression

Accepted answers

ShankerV

Hi @edward_chow

Another way to achieve with the help of formula tool.

Many thanks

Shanker V

Formual Move the matched cell values to a new column.yxmd

All comments

ShankerV

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

edward_chow

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!

ShankerV

Hi @edward_chow

One way of doing this.

Many thanks

Shanker V

Move the matched cell values to a new column.yxmd

ShankerV

Hi @edward_chow

Another way to achieve with the help of formula tool.

Many thanks

Shanker V

Formual Move the matched cell values to a new column.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703