Lantica User Forum - Using ampersand sysbol in a retrieve spec

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Using ampersand sysbol in a retrieve spec

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Using ampersand sysbol in a retrieve spec (Read 597 times)

NHUser Full Member Offline Posts: 320 Location: Amherst, NH Joined: Aug 2^nd, 2010	Using ampersand sysbol in a retrieve spec May 1^st, 2017 at 6:47pm	Print Post
	I'm working on pulling supplier address information from one file to another as needed. Some of our suppliers have the ampersand symbol in their name, for example S&S Machine Co. If I search by S&S.. the record for this supplier will not appear, however if I search by ..machine, I get the file to appear. It's apparent that the ampersand is the problem. Is there some way to use this in the retrieve spec, or some way to trick Sesame into finding the file? I know I can rename the file to "S and S.." but I'm trying to avoid that. Thanks for your help!


	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2480 Joined: Aug 20^th, 2003	Re: Using ampersand sysbol in a retrieve spec Reply #1 - May 1^st, 2017 at 8:02pm	Print Post
	Hi Paul, The Ampersand is a special search character. More information on it's use can be found on page 268 of the Sesame 2 User Guide. To search for an ampersand character in the data you simply need to escape it at the retrieve spec so that Sesame knows you want the character and not what that character means to search. So to find "S&S Machine Co", you would search for "S\&S Machine Co". -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›