Forum Discussion
Solved
Help splitting/extracting column by character transition based on condition from another column
Hi all, I need your guidance on how to split/extract a column by character transition if a condition is true. I have a table with two columns: Hostname Username Machine01 Usernam...
Hi,
try this in a new column in power query:
if [Hostname] = "Cloud Machine" then Text.Remove(
[Username],
{
Character.FromNumber(32)..Character.FromNumber(47),
Character.FromNumber(58)..Character.FromNumber(255)
}
)
else [Username]If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
DOLEARY85
Resident Rockstar
Resident RockstarHi,
try this in a new column in power query:
if [Hostname] = "Cloud Machine" then Text.Remove(
[Username],
{
Character.FromNumber(32)..Character.FromNumber(47),
Character.FromNumber(58)..Character.FromNumber(255)
}
)
else [Username]
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
