Start a new topic

Dictionary Formula

Hello,

 

Is there a formula I can use to create a dictionary for -

If a column in my file has either numbers or letters then to give it a 'Yes' for a preference and if the column is blank to give it a 'No'.

 

Thanks

Steve


Hi Steve, try this post RegEx formula for finding any non-blank value:
http://stackoverflow.com/questions/7967075/regex-for-not-empty-and-not-whitespace

You can then add another dictionary match for (just leave it empty) and translate it to "No".

Hi Jeffrey,

 

Thank you for you reply but unfortunately that didn't seem to work.

 

I basically have a column in my file which consists of different telephone numbers as well as blank cells.

 

So anyone who has given me a number in that column will need a YES (to contact them) and the blank fields will need a NO (to not contact them).

 

Thanks

Hi Steve,

 

We'd need some more information to be able to help. Did you test the dictionary entries you set up to see if they worked with the data you are importing? What were the test results?

 

Jeff

Hi Jeff,

I managed to sort it now using (^$)|(\s+$)

Thank you very much with your time and assistance here

Steve
Login or Signup to post a comment