Conditional Column to Extract Text before Delimeter

jslaws02 — Thu, 07 Mar 2024 17:53:00 GMT

I have a column in my table that defines how many delimeters to skip when extracting text before a delimeter from another column. If the delimeter skip column value is 2, I want to skip 2 of the delimeters. If it's 3, I want to skip 3 delimeters (those are the only 2 values in the delimeter skip column). What does the M language to create that conditional column look like? Something like "if [Project Code Site Level] = 2 then Text.BeforeDelimeter([Project Code], ".",2) else Text.BeforeDelimeter([Project Code], ".",2).

Re: Conditional Column to Extract Text before Delimeter

lbendlin — Thu, 07 Mar 2024 21:31:50 GMT

Text.BeforeDelimiter([Project Code], ".",[Project Code Site Level])

Re: Conditional Column to Extract Text before Delimeter

jslaws02 — Tue, 12 Mar 2024 12:38:38 GMT

Worked perfectly, thank you.

topic Re: Conditional Column to Extract Text before Delimeter in Desktop

Conditional Column to Extract Text before Delimeter

Re: Conditional Column to Extract Text before Delimeter

Re: Conditional Column to Extract Text before Delimeter