Advanced sort/filter

[pezman38]

I am using a handheld scanner to scan in barcodes. However the part numbers contain more data than I need. Is there a way to get ride of the extra data I scan in in Access.

Say I have part ABCD- 7G675 .. I only need 7g675 to be in the field. Is there a way to do this besides a find replace, that would take way to long.

 

[KenHigg]

Is there any consistent logic you could apply? Like you always need the 5 char's on the far right?

 

[pezman38]

I need to be able to change that logic as I go. Different parts have different lengths to them. One could say aaa- another could be a-. So if possible I would need if logic to decide what label the part has, and whatever code after that to pull out just the part.

 

[KenHigg]

You'll have to find some kind of logic to parse the strings out into usable pcs...