LEN Function in FDM(Fast Datamasker)

[umesh pandey]

Hi All,

I have a requirement to calculate length of Phone Num Column in Database as they can be 7 or 10 digit No. While trying to apply LEN Function I am getting error where clause: LEN(PHONE_NUM) = 10 is invalid. is LEN Function not compatible with FDM or any syntax error here.

Thanks for the help in advance.

[Billy Keefer]

This works for me.  Can you provide an example.
regards

[umesh pandey]

Attached is screenshot with Function, Job Details and error I am receiving.

Attachment(s)

AreaCD_ErrorLog.docx   555 KB 1 version

[Abderrahmane Zahrir]

oracle: LENGTH

https://www.w3resource.com/oracle/character-functions/oracle-length-function.php 

sql server: LEN

http://www.sqlservertutorial.net/sql-server-string-functions/sql-server-len-function/  

Regards, Dahman 

[umesh pandey]

My Database was Oracle and Length Function worked. So for Oracle DB its Length while for SQL its LEN