What is regex (lookup)? When you should use it?
Answers were Sorted based on User's Feedback
Answer / rajat singh
In a regex lookup operation, each record in the lookup file must contain a regular expression in the format described in “Regular expressions in DML functions”. The regex key specifier of a regex lookup file identifies the record field to interpret as a regular expression.
A lookup function such as lookup (file_label , expression) tests the value of its second argument against the regular expression field in each record of the lookup file, until the function finds a match.
| Is This Answer Correct ? | 3 Yes | 0 No |
In INTERVAL LOOKUP we will be defining certain range of
values like 0 - 10 , 10 - 20. Similarly in regrex lookup we
will be defining values like 0|1|2|3
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / ramakrishna
lookup is also similar to join.. by using the following
syntax we will fetch the info from lookup
lookp("looupfilename",conidition).field want to fecth from
lookup
| Is This Answer Correct ? | 1 Yes | 8 No |
What is common among data validity and data integrity?
Hi friends, what are the new features in abinito3.0?
Mention what is a partition and what are the different types of partition components in abinitio?
Mention some ways for improving performance of a graph?
How can you connect eme to abinitio server?
What do you know about partition and also tell us about partition components in abinitio?
What is the importance of eme in abinitio?
What do you mean by data sorting?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
What is the purpose of having stored procedures in a database?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
How abinitio eme is segregated?