Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by nwallac1

  1. nwallac1

    Checking for spaces at beginning of string

    While using ltrim would be nice, it is not a possibility in this case. I am trying to eliminate those cells that begin with 5 or more spaces from my search. I chose 5 as a safe number that would distinguish the cells I want from the cells I do not want. thus, I am still having many problems.
  2. nwallac1

    Checking for spaces at beginning of string

    I am having a problem using the left function to check for spaces at the beginning of a string. using this code: If Left(ActiveCell, 5) = " " Then activecell.offset(1,0).activate I am trying to skip any string that begins with 5 spaces. The code above does not seem to work to accomplish...
  3. nwallac1

    Parsing irregular text strings

    Thanks Stevexff. unfortunatly I have not been able to try it out yet. I am using Excel (VBA) to try and parse this stuff and regexp does not seem to be functional for VBA. I read somewhere that there is a way to get regexp for VBA but, i have not figured out how. Does anyone have any advice?
  4. nwallac1

    Parsing irregular text strings

    I am unfamiliar with regex-based code, so this is all new. The fields I am interested in are name, the first number (after COM) and the third number. I have tried using com as a marker for position in the file, but I found that there are other words used besides COM and common. here are some...
  5. nwallac1

    Parsing irregular text strings

    Right, sorry about that. I am using Excel to try to do this. I have tried the " " delimiter, but problems arrise because fields are sometimes separated by a single " " if they are quite long. This leads a " " delimiter to mess up an entire entry because everything will be off by one entry.
  6. nwallac1

    Parsing irregular text strings

    I am trying to parse stock holdings for certain companies but I am running into trouble because they are not uniform in their form. The data has a general form but each company uses a slightly different style for the forms. These differences are hamstringing my efforts to effectively parse the...
See more

Part and Inventory Search

Back
Top