Log In
Register
Home
August 21, 2019
Offline
Hi Catalin Sir,
Previous you had shared with me on the List.Accumulate usage on List of deliminters, when I applied the same codes second time (Trim2) all became blank ?
For your advise please
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Documents", type text}}),
Trim1 = List.Accumulate(Table2, #"Changed Type", (TransformedTable, ReplacementItem) =>
Table.TransformColumns(TransformedTable, {{"Documents", each Text.BeforeDelimiter(_, ReplacementItem), type text}})),
Trim2 = List.Accumulate(Table3, Trim1, (TransformedTable, ReplacementItem) =>
Table.TransformColumns(TransformedTable, {{"Documents", each Text.AfterDelimiter(_, ReplacementItem), type text}}))
in
Trim2
November 8, 2013
Offline
In the second, that is using TextAfterDelimiter, use:
Text.AfterDelimiter(_, ReplacementItem,{0, RelativePosition.FromEnd})
August 21, 2019
Offline
Hi Catalin,
Is it because the other two do no have prefix attached to it so we need to specify {0, RelativePosition.FromEnd} ?
anyway it works and thank you so much !!
November 8, 2013
Offline
No, it's because first is using Text.BeforeDelimiter and the delimiter is at the end of the string,
and the second is using AfterDelimiter but the delimiter is at the beginning of the string.
1 Guest(s)
