Moving data to another column formula help

[shingrac]

Hello! I wanted to move data from one column to another. I used the IFTHEN formula to do so, but I can't seem to quite get it right. 

The image below contains addresses. If an address does not start with a number like 440 Park Ave, I wanted to move that data to a field called "Vendor Notes." I tried using the IsInteger() as a part of the IFTHEN formula, but I was unsuccessful.

All help is appreciated! Thank you.

[T_Willins]

Hi @shingrac,

I used an IF/THEN formula to accomplish what you are trying to do.  Inside the REGEX_Match formula I isolated the first character of the Address field using a LEFT function, then determined if that character was a number ("\d").  If the formula was true (= -1) then the formula puts Null in the Vendor Notes field, otherwise it copies the data from the Address field.

[shingrac]

Thank you so much @t_willins! And what would I do if I wanted the address field to then be empty after moving that data to the vendor notes field?

[T_Willins · Accepted solution]

Hi @shingrac,

You can do this by adding another formula to update the Address field.  The first formula creates and updates the Vendor Notes field, and the second formula looks at the results of the first formula and updates the Address field accordingly.