Forum Discussion
Solved
Find, If its not a last record
I wanted to append delimiter | (pipe symbol) to differentiate each Maintenance Record, of a List, unless it’s not last record Also, specific Maintaince Records would be filtering out based upon if-e...
pls try this
=Text.BeforeDelimiter([Column1],"|",RelativePosition.FromEnd)pl try
=Text.Combine( List.RemoveLastN( Text.ToList([Column1]),1))
pls try this
[
a= Text.Replace([WorkLoadDetails],"SC1, ",""),
b = Splitter.SplitTextByAnyDelimiter({", "})(a),
c = Text.Combine(b,"|")
][c]