Databases
StackOverflow2013
Postsdbo
POHow to do ANDing of conditions in a regular expression?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to do ANDing of conditions in a regular expression?
    primarykey
    data
    text
    <p>I want to match and modify part of a string if following conditions are true:</p> <p>I want to capture information regarding a project, like project duration, client, technologies used, etc..</p> <p>So, I want to select string starting with word "project" or string may start with other words like "details of project" or "project details" or "project #1". </p> <p>RegEx. should first look at word "project" and it should select the string only when few or all of the following words are found after word "project".</p> <pre> 1) client 2) duration 3) environment 4) technologies 5) role </pre> <p>I want to select a string if it matches at least 2 of the above words. Words can appear in any order and if the string contains ANY two or three of these words, then the string should get selected.</p> <p>I have sample text given below.</p> <hr> <blockquote> <p>Details of Projects : *Project #1: CVC – Customer Value Creation (Sep 2007 – till now) Time Warner Cable is the world's leading media and entertainment company, Time Warner Cable (TWC) makes coaxial quiver.</p> <p>Client : Time Warner Cable,US. ETL </p> <p>Tool : Informatica 7.1.4</p> <p>Database : Oracle 9i. </p> <p>Role : ETL Developer/Team Lead. </p> <p>O/S : UNIX.</p> <p>Responsibilities: Created Test Plan and Test Case Book. Peer reviewed team members > Mappings. Documented Mappings. Leading the Development Team. Sending Reports to onsite. Bug >fixing for Defects, Data and Performance related.</p> <p>Details of Project #2: MYER – Sales Analysis system (Nov 2005 – till now) Coles Myer is one of Australia's largest retailers with more than 2,000 > stores throughout Australia, </p> <p>Client : Coles Myer Retail, Australia. ETL Tool : Informatica 7.1.3 Database : Oracle 8i. Role : ETL Developer. O/S : UNIX. Responsibilities: Extraction, Transformation and Loading of the data using Informatica. Understanding the entire source system.<br> Created and Run Sessions and Workflows. Created Sort files using Syncsort Application.*</p> </blockquote> <p>Does anyone know how to achieve this using regular expressions? Any clues or regular expressions are welcome!</p> <p>Many thanks!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USShekhar
    1. USShekhar
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to do ANDing of conditions in a regular expression?
      1. USLocksfree
      1. VTFavorite
    2. VO
      singulars
      1. POHow to do ANDing of conditions in a regular expression?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COcan you rephrase? What words should match in your sample text ?
      singulars
      1. POHow to do ANDing of conditions in a regular expression?
      1. USJaskirat
    2. CO@Svante Words to be mached in sample text are : Project #1: CVC – Customer Value Creation (Sep 2007 – till now) Time Warner Warner Cable (TWC) makes coaxial quiver. Client : Time Warner Cable, US. ETL Tool : Informatica 7.1.4 Database : Oracle 9i. Role and Details of Project #2: MYER – Sales Analysis system (Nov 2005 – till now) Coles Myer is one of Australia's largest retailers with more than 2,000 stores throughout Australia, Client : Coles Myer Retail, Australia. ETL Tool : Informatica 7.1.3 Database : Oracle 8i. Role : I want to select project related information.
      singulars
      1. POHow to do ANDing of conditions in a regular expression?
      1. USShekhar
    3. CO@Svante I have chopped some text from sample text due to restrictions on number characters allowed in comment.
      singulars
      1. POHow to do ANDing of conditions in a regular expression?
      1. USShekhar
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload