Results 1 to 1 of 1

Complext text manipiulation - a nesting problem??

Threaded View

  1. #1
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Complext text manipiulation - a nesting problem??

    I have datasets that identify which bacteria have been isolated from food These lists come in, typically, three forms: starting with the name of the bacteria, or with one of several fixed-text strings preceeding the name of the bacteria.

    For example:

    Suspicion of Listeria monocytogenes in cheese
    shigatoxin-producing Escherichia coli in cheese
    Salmonella typhimurium in cheese

    I can (using a separate equation to separately remove each potential leading string - UGH) get:

    Listeria monocytogenes in cheese
    Escherichia coli in cheese
    Salmonella typhimurium in cheese

    I can't nest this, however.

    Finally,

    I can isolate the name of the bacterium, as it always consists of two words, giving the desired result:

    Listeria monocytogenes
    Escherichia coli
    Salmonella typhimurium

    the way I do this ain't pretty, but it works.

    can you help me go from:


    Suspicion of Listeria monocytogenes in cheese
    shigatoxin-producing Escherichia coli in cheese
    Salmonella typhimurium in cheese

    to

    Listeria monocytogenes
    Escherichia coli
    Salmonella typhimurium

    without having to use VBA, in one equation. Example attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1