Hi! I'm stuck
and need some help. I have a list of about 1600 entries, all merchant names and i need to place an * at the beginning and end of each entry, example *Arizona Central*. Each entry has a different amount of characters...would any one know if there is a way of how I can do this easily in Access or Excel?
One update query does this
Code:
UPDATE [Merchants] SET [MerchantName] = '*' + [MerchantName] + '*';
I would suggest you not do this and just add this in any reporting or output though. I don't know if you thought through all the impact of this, not least of which is that * in Access queries is a wildcard.
Was this answer helpful ?
Yes No
Quote:
| Originally Posted by medialint One update query does this
Code:
UPDATE [Merchants] SET [MerchantName] = '*' + [MerchantName] + '*';
I would suggest you not do this and just add this in any reporting or output though. I don't know if you thought through all the impact of this, not least of which is that * in Access queries is a wildcard. |
Yep, I understand that the * is a wildcard. The problem that I'm running into is that the list of merchants that I have needs to match to a field where it has the merchants name but it has other characters in it that I dont need. The system captures the merchant name, transaction date, transaction sequence number, and so on and so forth. so basically that field look something like this....GCP Arizona Casino 025143125 548775 020707 DB 5.
There's no way for me to divide up the field since the hundreds of merchant names are not in the same spaces or take up the same amount of spaces.
Was this answer helpful ?
Yes No
