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 local and formal parameter?
Difference between public and private projects and how to make private to public?
Can you run air sandbox run using pset ?
Output for sort and dedupsort with NULL key?
How you can run a graph infinitely in ab initio?
What information does a .dbc file extension provides to connect to the database?
How can I run the 2 gui merge files?
Can any body give me the clear explanation about how to separate header,trailer and body records in Ab Initio?
Do you know what a local lookup is?
What is the role of co-operating system in abinitio?
What is the significance of ‘mp run’ command ?
Explain PDL with an example?