Move the matched cell values to a new column

[edward_chow]

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,

[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 

This is a valid ask, it can be accommodated.

[ShankerV]

Hi @edward_chow 

One way of doing this.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @edward_chow 

Another way to achieve with the help of formula tool.

Many thanks

Shanker V