INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Explicit Find  (Read 563 times)

davemccorkle

  • Regular Member
  • World Citizen
  • ***
  • Posts: 214
  • nothing more to say...
Explicit Find
« on: March 30, 2022, 09:28:42 am »

How do I use the wizard to search for a comma in a name but not a comma with a space after it?  I want to explicitly search for "," but not with a leading or following space

Logged

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2618
Re: Explicit Find
« Reply #1 on: March 30, 2022, 10:41:04 am »

With Regex:
Code: [Select]
[=regex([name],\S/,\S,0)]=1
Without Regex:
Code: [Select]
[Name]="," -[Name]=" ," -[Name]=", "
Logged

davemccorkle

  • Regular Member
  • World Citizen
  • ***
  • Posts: 214
  • nothing more to say...
Re: Explicit Find
« Reply #2 on: March 30, 2022, 11:03:32 am »

you are a genius, thank you!
Logged

zybex

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 2618
Re: Explicit Find
« Reply #3 on: March 30, 2022, 11:10:01 am »

Quit slandering me, I've never worked at an Apple store!
Logged

davemccorkle

  • Regular Member
  • World Citizen
  • ***
  • Posts: 214
  • nothing more to say...
Re: Explicit Find
« Reply #4 on: March 30, 2022, 11:59:30 am »

lol
Logged
Pages: [1]   Go Up