Hello. I have a table called sms_monitoring and has a [email Contect].
I want to extract the 1st 12 number of the said column.
i have tried this formula
LEFT(INDEX(SPLIT([Email Content], “+”), 2), 12)
but the problem is it still generate text which is not a phone number that i need.
Please try below
Please make the VC as number type and please remove the following setting in the VC
Alternatively if it is a phone number and you want it to make it callable or textable, you can do so by assigning it as a “Phone” type column with “Callable”. “Textable” settings on.
What the column is showing in detail view?
Yes sir.
I requested to know what the column is showing in the detail view. Could you share a screenshot?
I think a better approach would be to use EXTRACTPHONENUMBERS() function. Dunno if it works for Philippines numbers, but you could give it a shot. Just make sure to set the VC type to “Phone” so it works properly.
EXTRACTPHONENUMBERS([Email Content])
Please refer to the documentation: