Hi coders,
This should be a simple question
This works
Left([EmailAddress],inStr([EmailAddress],"."))
when i add +1, it doesnt work
Left([EmailAddress],inStr([EmailAddress],".")+1)
when i add Count only, no error
Left([EmailAddress],Count(inStr([EmailAddress],".")))
But when i add +1 again, error
Left([EmailAddress],Count(inStr([EmailAddress],"."))+1)
I just need to add 1 to the value returned by inStr. Helppp
This post has been edited by NGV22: May 18 2020, 09:19 PM
inStr function but add "+1" to the value, inStr