Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am having an issue with my syntax and was wondering if someone could help me. I only want the first 13 positions. What am I doing wrong? Thanks
if(len(Address2_Telephone1) >= 12,
(Mid(Replace(Replace(Replace(Address2_Telephone1,' ',''),Chr(10),' '),Chr(13),' '),1,13))) as New_Address2_Telephone1,
And this is exactely what I get:
New_Address2_Telephone1 |
---|
(330)876-5412 |
I calculated including ( ) -.
So, i think it would be 13..but not sure..
Sorry I just didn't notice the ()-. You are right.