Separate the Records with Special Characters

How will you separate the records with special characters in a column. For example
If suppose the column contains
Name*
&Name
Na*me
$Name
Na$me
I need to separate these records alone.
  • Interview Candidate
  • 3
  • 5175

Showing Answers 1 - 3 of 3 Answers

Shrushti

  • Jul 15th, 2016
 

Source - transformer - target.
In transformer,
Namesp --- If alphanum(Name) then 1 else 0
Constraint --- Namesp=0

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions