Cancel last characters

[idage]

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

[slorin · Accepted solution]

Hi,

Extract text before last comma

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

Stéphane 

[idage]

FANTASTC!!!!!Really Really thank you!

[watkinnc]

Use Text.BeforeDelimiter, like this

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

--Nate

[idage]

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