i want a Blank else in List.Accumulate( IF...

[ilcaa722]

= Table.AddColumn(#"Inserted Text Before Delimiter","FindReplace", 
each List.Accumulate(List.Numbers(0, Table.RowCount(replaceTable)), 
[Description],
(state, current) => 
if Text.Contains(Text.Lower(state) , replaceTable[contains]{current}) then replaceTable[replace]{current} else  "" ))

this doesnt work cause my else statement is saying "" blank... it works if I add a command with state or just "state"

but i dont want to return the state, i want to return a blank... how can i. thank you

[tackytechtom]

i @ilcaa722 ,

Does it work for you if you substitute the "" with null instead?

Let me know 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[ilcaa722]

I tried to end with Text.Length(state)*0 but other errors....

[ilcaa722]

does not work. error is:

cannot convert the value null to type logical

it seems 'state' must be part of the List.Accumulate 2 arguement and modifying it has limits