Forum Discussion

modwonka's avatar
modwonka
Icon for Helper I rankHelper I
4 years ago
Solved

M if text contains, if not empty

Hi,   I'm trying to improve one formula i did in M, to extract a date between brackets but i don't know how to advance. If anyone could help me, i would really appreciate it.   This is the formul...
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    in was missing

    let l=List.Transform( Text.Split([#"Tags (created on)"]," "), each Text.Remove(_,{"(",")",","})),
    i=List.PositionOf(l, "BLUETEXT")
    in if i>=0 then l{i+1} & " " & l{i+2} else null

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

I think should work for you in last line

if i>=0 then l{i+1} & " " & l{i+2} else null

 

  • modwonka's avatar
    modwonka
    Icon for Helper I rankHelper I
    4 years ago

    Thanks for your answer Vijay_A_Verma!

     

    I tried the solution with your code:

     

    let l=List.Transform( Text.Split([#"Tags (created on)"]," "), each Text.Remove(_,{"(",")",","})),
    i=List.PositionOf(l, "BLUETEXT"),
    if i>=0 then l{i+1} & " " & l{i+2} else null

     

    There's one error: "Token identifier expected". In the "if". Is this ok?

    • Vijay_A_Verma's avatar
      Vijay_A_Verma
      Icon for Most Valuable Professional rankMost Valuable Professional
      4 years ago

      in was missing

      let l=List.Transform( Text.Split([#"Tags (created on)"]," "), each Text.Remove(_,{"(",")",","})),
      i=List.PositionOf(l, "BLUETEXT")
      in if i>=0 then l{i+1} & " " & l{i+2} else null

      • modwonka's avatar
        modwonka
        Icon for Helper I rankHelper I
        4 years ago

        Thank you so much! That worked 😉