Delete to right of ampersand 1

[EBOUGHEY]

I would like to delete everything to the right of an '&'

ie: John & Sandra (Remove '& Sandra')

How would this be accomplished?

Thanks for any assistance.

 

[darrellblackhawk]

? left("John & Sandra",at("&","John & Sandra&quot-1)

Darrell

 

[EzLogic]

cStr = 'John & Sandra'
? SUBSTR(cStr,1,AT('&',cStr)-1)

Ali Koumaiha
TeknoSoft Inc
Farmington Hills, Michigan

 

[EzLogic]

Darrel, nice that he has 2 options.. a Left() or a Substr() to use..


Ali Koumaiha
TeknoSoft Inc
Farmington Hills, Michigan

 

[Dan Freeman]

Here's a third option:

StrExtract("John & Sandra","","&&quot

 

[EBOUGHEY]

This worked great. Thanks so much for answering so quickly.


REPLACE ALL t with left(first,at("&",first)-1)
replace all first with t for !empty(t)

 

[craigsboyd]

TecknoSDS,

nice that he has 2 options

...gender here is not always masculine, some of our best members are female. Elena didn't notice or take offense, but I thought I would mention it.

Slighthaze = NULL
_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​