Removing a date from a cell based on a condition

[Luk88kk]

Good morning,
I have a problem that I would like to clarify.
My task is to remove from Row A entry "#" and automatically delete date in row "B" and "C".
I do it by changing in Select Tool date type to V_WString and then use this two formulas:

if ([field_1] = "#")
then [field_2] = "" and [field_3] = ""
else [field_1]
endif

ReplaceChar([field_1], "#", "")

It's works but I wonder if there is a way to do it in a more simple way?

This is the table:

I would be grateful for any guidance

[mceleavey · Accepted solution]

Hi @Luk88kk ,

the trick here is to make it dynamic, so when you add more columns and rows it automatically applies the logic. I've done this by transposing the data into a single column and applying a multi row formula to the single column before cross-tabbing back:

Hope this helps,

M.

[Luk88kk]

I wouldn't have figured it out myself.

Thank you very much for your help.

Have a nice day!

[mceleavey]