Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

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

Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

4 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Anonymous 

     

    Try this Custom Column from Query Editor

     

    =if (try Number.From([ColumnName]) otherwise "NickPatel")="NickPatel" then [ColumnName] else null
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        7 years ago

        Anonymous 

         

        It works with me

         

        Did you try it as a new custom column?

        See the pick below