Forum Discussion
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
- idageHelper I
COULD YOU PLEASE HELP?? I tried many ways without results...
- AnonymousNot applicable
Use Text.BeforeDelimiter, like this
Table.AddColumn(PriorStepOrTableName, "NewColumnName", each Text.BeforeDelimiter([Level], ".", {0, RelativePosition.FromEnd}))
--Nate
- slorinSuper User
Hi,
Extract text before last comma
Text.BeforeDelimiter([Level], ".", {0, RelativePosition.FromEnd})Stéphane
- idageHelper I
FANTASTC!!!!!Really Really thank you!