Forum Discussion

WJ876400's avatar
WJ876400
Helper IV
6 years ago
Solved

Split numbers from longer text

Hi

 

How do i just take out the percentage from the list below in column 1. Thanks

 

 

 

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    WJ876400 ,

     

    Just modify the dax above:

    Column = 
VAR v_PercentPos = SEARCH( "%", 'Table'[Data], 1, 0 )
VAR _var = TRIM( RIGHT( LEFT( 'Table'[Data], v_PercentPos ), 3 ) )
RETURN
IF(_var = "00%", "100%", _var)

    Or another way is to use python script:

    # 'dataset' holds the input data for this script

import pandas as pd

dataset['Result'] = dataset['Data'].str.extract('\s(100%|(\d{1,2}(\.\d+)*)%)')[0]

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi WJ876400 ,

    Try this:

    Column = 
VAR v_PercentPos = SEARCH( "%", 'Table'[Field], 1, 0 )
RETURN
TRIM( RIGHT( LEFT( 'Table'[Field], v_PercentPos ), 4 ) )

    Thanks.

    Please accept this as a solution if it satisfies the requirement. Appreciate your Kudos. :)

    • WJ876400's avatar
      WJ876400
      Helper IV
      6 years ago

      Hi Anonymous 

       

      Thanks that worked apart from two rows i have ended up with an e and an m infront of the number

       

      • v-yuta-msft's avatar
        v-yuta-msft
        Community Support
        6 years ago

        WJ876400 ,

         

        Just modify the dax above:

        Column = 
VAR v_PercentPos = SEARCH( "%", 'Table'[Data], 1, 0 )
VAR _var = TRIM( RIGHT( LEFT( 'Table'[Data], v_PercentPos ), 3 ) )
RETURN
IF(_var = "00%", "100%", _var)

        Or another way is to use python script:

        # 'dataset' holds the input data for this script

import pandas as pd

dataset['Result'] = dataset['Data'].str.extract('\s(100%|(\d{1,2}(\.\d+)*)%)')[0]

         

         

        Community Support Team _ Jimmy Tao

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.