parse alphanumeric

  1. G

    RegEx to extract a number from a text string, based on its position in the string.

    I use a fairly simple vba routine to extract data from a table contained in an Outlook email body. The result is an array which contains 1 entry with 7 columns for each email. Here is a sample of one entry in the array: arrList(1,1) = "Sent: Monday, August 28, 2017 10:07:28 AM (UTC-06:00)...
  2. D

    Parse AlphaNumeric String

    Objective: To create a list of numbers based a cell which are present in an alpha-numeric string Issues: "-" shows up at times without the context of numbers (i.e. MS-DRG) Issues: I am not interested in float numbers (i.e. 37.63-37.66) 'Example data in cells (row 1 = A1, row 2 =A2, row 3 =...
  3. N

    Separate letters and numbers in different variations

    I have a list of over 15,000 alphanumeric figures (column A) that I need to parse out as follows (columns B-E) seperating letters from numbers in sequence:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <TABLE style="BORDER-BOTTOM: medium none...
  4. S

    VBA needed? Separating Text and Numbers from a string into Columns

    Hi All, I need to write a series of formulas (or VBA preferably) to take a single string (column A) and break it into separate columns (B-F). The columns should split the text each time the characters change from text to numeric and vice versa. An example of my data in column A w/ output in...
  5. E

    Parsing A Code Back into Useable information

    I have a code 0ddmyLxx where after the leading 0 is the day, month, year, location;xx is a machine number. The Location is constant as "S". The year is simple by added the number to 2000, and the months of the year by convention are: 1,2,3,4,5,6,7,9, X, N,D where X is Oct, N is Nov and D is Dec...

Some videos you may like

This Week's Hot Topics