Forum Discussion
New Column Create a new column with a given value from another column.
Hello, forgive my ignorance, but I have been struggling with the solution to this problem for a few days.
I have to create a new column "email" from the column "Phone 2" where there are values that do not interest me, I am only interested in those containing @ which are the mail.
I have tried creating a conditional column, but it does not accept Text functions, or at least it has not let me.
What solution do you see?
Hello,
my failure was conceptual, with your indication that it was what I had done, has caused me to review it, because it was already sure that it must be the right way ... and SURPRISE!!! I found my failure.
I had to change the tab, so that I could search for a column and not use Text.XXXXX functions that do NOT work.
2 Replies
Do you want to copy the value into a new column if it contains '@'?
If so, you can do that from the Add Column->Conditional Column . It's just a matter of filling in the dialog.
If -> column -> contains ->@ then column else null
Hello,
my failure was conceptual, with your indication that it was what I had done, has caused me to review it, because it was already sure that it must be the right way ... and SURPRISE!!! I found my failure.
I had to change the tab, so that I could search for a column and not use Text.XXXXX functions that do NOT work.
