Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi,
Extract text before last comma
Text.BeforeDelimiter([Level], ".", {0, RelativePosition.FromEnd})
Stéphane
Hi,
Extract text before last comma
Text.BeforeDelimiter([Level], ".", {0, RelativePosition.FromEnd})
Stéphane
FANTASTC!!!!!Really Really thank you!
Use Text.BeforeDelimiter, like this
Table.AddColumn(PriorStepOrTableName, "NewColumnName", each Text.BeforeDelimiter([Level], ".", {0, RelativePosition.FromEnd}))
--Nate
COULD YOU PLEASE HELP?? I tried many ways without results...