Recent content by indysm1

  1. I

    Parsing Text Strings

    Yep, I was just hoping to be able to do it in access...less manual that way. thanks!
  2. I

    Parsing Text Strings

    Yeah, I agree. Unfortunately, I have to many records for an excel spreadsheet. I can use excel, but then I have to segment my record population and run my data scrubbing multiple times...
  3. I

    Parsing Text Strings

    The field also has other characters with different string lengths so left won't work...i.e.(INABS 2006-A 1B1 mtge)
  4. I

    Parsing Text Strings

    I'm trying to parse text strings by certain spaces and characters within the string. For Example, if my text string is RAST 2006-A1 B1 mtge, how can I 1) create a new field with just the RAST 2006-A1, 2) Create a field with just the RAST 2006-A1 B1? I appreciate any help I can get. Thanks!
Back
Top Bottom