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....
  • slorin's avatar
    2 years ago

    Hi,

    Extract text before last comma

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

    Stéphane