none
How to extract column text using Regular expression RRS feed

  • Question

  • Hello All,

    My intermediate file creates following text from Excel:

    |1 SwID_0001 |2 The operating system. |3 Common |4  software |5

    |1 SwID_0002 |2 The networking system.  |3 specific |4  hardware |5

    |1 SwID_0003 |2 The Train system.  |3 Common |4  software |5

    Here 1, 2, 3, 4 and 5 are corresponding to the coloumn numbers in Excel file.

    Now i wanted to write a regular expression (outside excel, ex. Rhapsody) to extract the text from different coloumns.

    For example I wanted to extract the text from coloumn 2, the output would look like:
    "

    The Operating system.

    The networking system.

    The Train system. 

    "

    Can some one help on this please.


    Wednesday, May 16, 2018 8:32 AM

All replies