If statement based on # of characters in field

11 years 10 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 to join the conversation.

11 years 10 months ago #204517 by nant

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.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.246 seconds

Facebook Twitter LinkedIn