Forum Discussion

modwonka's avatar
modwonka
Helper 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...
Need Help
  • 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
Most 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
Helper I
4 years ago

Hi Vijay_A_Verma,

just one last thing, in case you can help again with this 😉 

As you know, if the formula does not find BLUETEXT it puts "null". If it finds "BLUETEXT", it extracts a date from inside the parenthesis.

The issue is that I would like to compare this column with a new one with the same formula. Date vs date. And get the smaller one and select it. But with the null that formula is broken.... how can I fix it?