extract special strings to a calculated column

[Anonymous]

Hi

Can any one help me in solving the below scenario

how to extract  promition ids ftom the below scenario in a calculated colimn

101

102

103prm1

104prm2

106

107prm

needs answer as

103prm1

104prm2

107prm

needs the answer in a calculated column

[Anonymous · Accepted solution]

@Anonymous Please try to create a calculated column as per below

Result = 
VAR isalphanumeric = IFERROR(VALUE(Test[Column]),0)
RETURN IF(isalphanumeric=0,Test[Column])

[Anonymous · Accepted solution]

@Anonymous Please try to create a calculated column as per below

Result = 
VAR isalphanumeric = IFERROR(VALUE(Test[Column]),0)
RETURN IF(isalphanumeric=0,Test[Column])

[Tahreem24 · Accepted solution]

Hi @Anonymous ,

You can create calculated column like below:

Output = if(SEARCH("prm",Table2[Values],1,0)>0,Table2[Values])

See the expected output in below screen shot:

Please give KUDOS for support and also mark it as a SOLUTION if it helps you!