Skip to Content Skip to Menu

If statement based on # of characters in field

12 years 3 months ago #204515 by marriage_minded_man
If statement based on # of characters in field was created by marriage_minded_man
I want to display something based on the number of digits in someones user ID.

Some users will have a user id with 3 digits and some with 4. I want to say, "If user ID is 3 digits long, display this" and "If user ID is 4 digits long, display this".

Is this possible?

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
12 years 3 months ago #204517 by nant
Replied by nant on topic Re: If statement based on # of characters in field

marriage_minded_man wrote: I want to display something based on the number of digits in someones user ID.

Some users will have a user id with 3 digits and some with 4. I want to say, "If user ID is 3 digits long, display this" and "If user ID is 4 digits long, display this".

Is this possible?


CB Query field to calculate the number of digits (SQL skills required).
Then Delimiter field using cb if substitutions.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum