Forum Discussion

idage's avatar
idage
Helper I
2 years ago
Solved

Cancel last characters

Thank you very much in advance for your help!!

My issue i that:

 

in column Level i have values like this:

 

Level
1.1.1.1.1.3.10
1.1.1.1.1.4
1.1.1.1.1.4.1
1.1.1.1.1.5
1.1.1.1.1.6
1.1.1.1.1.7
1.1.1.1.1.8
1.1.1.1.1.8.1
1.1.1.1.1.8.2
1.1.1.1.1.8.3

 

 

and i need to generate a new column without last number and comma:

Level
1.1.1.1.1.3
1.1.1.1.1
1.1.1.1.1.4
1.1.1.1.1
1.1.1.1.1
1.1.1.1.1
1.1.1.1.1
1.1.1.1.1.8
1.1.1.1.1.8
1.1.1.1.1.8
1.1.1.1.1.8

  • Hi,

    Extract text before last comma

    Text.BeforeDelimiter([Level], ".", {0, RelativePosition.FromEnd})

    Stéphane 

4 Replies

  • COULD YOU PLEASE HELP?? I tried many ways without results...

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Use Text.BeforeDelimiter, like this

     

    Table.AddColumn(PriorStepOrTableName, "NewColumnName", each Text.BeforeDelimiter([Level], ".", {0, RelativePosition.FromEnd}))

     

    --Nate

  • Hi,

    Extract text before last comma

    Text.BeforeDelimiter([Level], ".", {0, RelativePosition.FromEnd})

    Stéphane 

    • idage's avatar
      idage
      Helper I

      FANTASTC!!!!!Really Really thank you!