Monday, June 13, 2011

REGEX_MATCH() -- Example..

Source is a Flat File.  The Name Columns Contain Non-Alphabetic Character at any Position Like
  (0-9) (!@........so on) . We need to separate the data.

Names
Anudeep
Rajes4h
Pravee@n
Ra5mesh
Kuldeep
$reddy
Maya_

Target should be loaded as..

Target1                 Target2    
Anudeep                   Rajes4h
Kuldeep                     Pravee@n
                                    Ra5mesh
                                     $reddy  

Solution
Use the Informatica data comparision function REGEX_MATCH( ) to achieve this..
> Use Filter Condition as  REG_MATCH(Names,'^[a-zA-Z]+$')


-- Ram


8 comments:

  1. Informatica Online Training | Informatica Online Training in India Hyderabad | Best Informatica Online Training
    Informatica Online Training I have taken this course from Attain Technologies. Thay covered all the real time scenarios and their training way was very good approach is very much understandable
    Contact them on given contact number is +91 9052820000, +1 2092073642, Email:contact@attainonlinetraining.com
    Web: http://attainonlinetraining.com/it-informatica-online-training.html

    ReplyDelete
  2. It was so nice article and useful to Informatica learners. we also provide Informatica Course online training our Cubtraining is leader in providing Software Training

    ReplyDelete
  3. It was so nice article.I was really satisified by seeing this article and we are also giving informatica online training.The Informatica online training is one of the best Software Courses online training institute in USA.

    ReplyDelete
  4. Thanks for giving Good Example.
    Fantastic article, Viral. Very well written, clear and concise. One of the best links explaining one to many and hierarchy Informatica. Thanks a lot.It is uaefull to me and my training Ithubonlinetraining center.

    ReplyDelete
  5. This is very good information for knowing the informatica basic knowledage and usefull for your online class . informaticaonlinetraining

    ReplyDelete
  6. Kindly let me know the meaning of using ^ and $ sign in the abobe condition?

    ReplyDelete
  7. Kindly let me know the meaning of using ^ and $ sign in the abobe condition?

    ReplyDelete
  8. ^ marks the start and $ marks the end

    ReplyDelete