One Column - Alpha Numeric and Integer Values - Need to move alpha numeric data to separate column.

[Anonymous]

Hi,

I need this for a report out of an integrated system. Please assist. I need to separate these alphanumeric values from the values that have only integers.

Any assistance is greatly appreciated.

Thank you,

Nick Patel

[Zubair_Muhammad]

@Anonymous 

Try this Custom Column from Query Editor

=if (try Number.From([ColumnName]) otherwise "NickPatel")="NickPatel" then [ColumnName] else null

[Anonymous]

I need to automate the entire column extraction. not just single values. the names of them vary unfortunatly 😞

[Zubair_Muhammad]

@Anonymous 

It works with me

Did you try it as a new custom column?

See the pick below

[Anonymous · Accepted solution]

This is what I am getting. Once I roll it down it gives me all of the column data.... Any Ideas?

Thank you,

Nick Patel