Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Clean column from delimiter

I have a column with City, number, Country.  Some of the rows only have number, Country and some have Country.   I would like to clean it so it is only showing the Countries.  See picture:     ...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I would add a column:

Table.AddColumn(LastStep, "Cleaned", each if Text.Contains([SYSTEM_LOCATION], ",") then Text.AfterDelimiter([SYSTEM_LOCATION, ",", {1, RelativePosition.FromStart}) else [SYSTEM_LOCATION])