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))
the easy way is to add a new sun and write
=Text.Range([Column1],0,Text.Length([Column1])-1)
This is very interesting solution, however, it replaces delimiter pipe between all the WorkLoadDetails. I just need to remove extra which gets added after last record.
it replaces only the last character
but you just need to add a new column
pls try this
=Text.BeforeDelimiter([Column1],"|",RelativePosition.FromEnd)