Results 1 to 23 of 23

extract a string from variable text

Threaded View

  1. #1
    Registered User
    Join Date
    09-20-2010
    Location
    islamabad
    MS-Off Ver
    Excel 2019
    Posts
    97

    extract a string from variable text

    Dear Experts

    I would like to define a excel IS number (SEARCH) formaula to help me fetch a specified string from the variable alerts like this one

    T1133
    T1071.001

    From variable alerts rows like some time alerts are with _ some time the string start after a SPACE and some its under Brackets ()

    mitre_T1071.001 Communication with known Bad ip's
    mitre T1110.003 Multiple Users Attempting To Authenticate Using Explicit Credentials
    mitre_t1033_1 System User Discovery Net Commands/Alert
    Network Sniffing 2 (MITRE 1040) /Alert

    can you create a Search Is number formula that extract the T1133 as single number as well with dots from variable alerts name ?

    e.g. a formula that search MITRE with _ with () and with dots and copy the adjacent value in the next columns as T1133.001 or T1133
    =IF(ISNUMBER(SEARCH("MITRE"
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] extract text form text string( extract 5 charactors in front of all left parenthese)
    By happyexcel2021 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2021, 06:05 PM
  2. [SOLVED] Extract string from variable length string
    By JeffGrant in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2021, 03:47 AM
  3. [SOLVED] Extract a variable length number from within a text string
    By Kirk3737 in forum Excel General
    Replies: 2
    Last Post: 10-27-2020, 02:27 PM
  4. [SOLVED] How to extract a piece of a string variable, and assign to a new variable
    By jmccoughlin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2015, 11:50 PM
  5. [SOLVED] Extract data from variable text string into seperate columns
    By kinnywayne in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2014, 04:43 PM
  6. Extract Variable Length Text String
    By sshot1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-12-2012, 06:21 PM
  7. [SOLVED] EXTRACT TEXT FROM TEXT STRING:The names are of variable length
    By carricka in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-08-2005, 06:05 AM

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