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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
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 !!
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
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)
