Parsing Text Strings

[indysm1]

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!

 

[KeithG]

use the left function

 

[indysm1]

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

 

[boblarson]

Welcome to Access World Forums. My first question about this would be Why? This really strikes of normalization issues and makes me wonder if you are designing something outside of the "Relational Database Management System (RDBMS)" realm; more of a spreadsheet mentality really.

More information would be good about what it is and why it is you are doing what you are doing.

 

[indysm1]

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...

 

[boblarson]

Then it will be possible to get your data into Access but you should design it so it is normalized and doesn't have repeating fields.

 

[indysm1]

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