Finding a non-blank row in a table

1

Hi All,

Please Help!

The below is a formula that will determine the correct expense account, based on the description in the bank account. There is a helper table, where the description is stored and mapped to an expense account. In the bank download file this formula then goes through the helper table, looking for the description.

image
image1298Ă—627 68.1 KB

I have two questions:

  1. The out put of the formula is a list, with maybe a found value, somewhere in the list. How do I select only the item that is non-blank. Every idea I come up with is based on foreach(), which will just give another list.
  2. I used containstext() with the idea that I can put a portion of the description in the helper file. However, Coda does an exact match. Therefor entering “Brighthouse” will not work, I need to have the full, exact description in the table column.

If needed, I will do an example when it is not Friday… :wink:

Thank you very much.
Piet

2

For 1 : Have you tried to add a .Filter(CurrentValue.IsNotBlank()) at the end of the ForEach() ? :blush:

Edit: .Filter(CurrentValue) might be sufficient to get rid of the blank values :thinking:

Filter(CurrentValue)
Filter(CurrentValue)1602Ă—720 48.4 KB

(Sorry, I’m currently AFK, so I’m kind of thinking out loud here :innocent: )

3

Brilliant!

And here is the rest of the 20 characters…

1 Like