Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

not STARTSWITH

Status
Not open for further replies.
mart10

mart10

MIS
Nov 2, 2007
394
GB
I am using CR 10

Can someone give me the syntaxt for a field NOT starting with. I have at the moment a formula

{PartyDetails_External.SWIFT}startswith "BARC"

I want to have another formula to exclude all data starting with BARC ie NOT startswith


thanks
 
Sort by date Sort by votes
not({PartyDetails_External.SWIFT} startswith "BARC")

-LB
 
Upvote 0 Downvote
doh! that simple, I was looking around for function

thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Tichaona
  • Locked
  • Question
Row numbering formula not working
Replies
4
Views
324
lbass
lbass
Cpreston
  • Locked
  • Question
Remaining Text does not appear problem 2
Replies
10
Views
352
Cpreston
Cpreston
jlr123
  • Locked
  • Question
Boolean Formula = True/False Not Intended Value
Replies
3
Views
214
jlr123
jlr123
Cpreston
  • Locked
  • Question
Field not displaying in one line
Replies
1
Views
130
Cpreston
Cpreston
TMasterK
  • Locked
  • Question
Showing Duplicates but starting with the second character not the first (string)
Replies
1
Views
120
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top