peskywinnets
Registered User.
- Local time
- Today, 03:48
- Joined
- Feb 4, 2014
- Messages
- 576
For some bizarre reason Ebay has just started randomly adding to the the following text to StreetAddress2 field
(the following are just 3 random examples)..
Ebayj4jvksc
Ebayv4jmfz6
Ebayp4jjqv3
...it's always Ebay...followed by 7 random characters (therefore 11 characters in total)...when they are present, they are always at the end of the StreetAddress2 field (but sometimes they aren't there). So for example, for StreetAddress2 I get....
11 Station Road Ebayp4jjqv3
....I need just the 11 Station Road bit
So I'm looking for an elegant way to strip the 11 rogue characters out (when they appear) via a query ...top tips warmly received!
here's my starter...
iif(left(Right([StreetAddress2],11),4)="Ebay", do something here, [StreetAddress2])
(the following are just 3 random examples)..
Ebayj4jvksc
Ebayv4jmfz6
Ebayp4jjqv3
...it's always Ebay...followed by 7 random characters (therefore 11 characters in total)...when they are present, they are always at the end of the StreetAddress2 field (but sometimes they aren't there). So for example, for StreetAddress2 I get....
11 Station Road Ebayp4jjqv3
....I need just the 11 Station Road bit
So I'm looking for an elegant way to strip the 11 rogue characters out (when they appear) via a query ...top tips warmly received!
here's my starter...
iif(left(Right([StreetAddress2],11),4)="Ebay", do something here, [StreetAddress2])