Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

jrRaid's Achievements


Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. I have it working now. Using 3 different custom functions and an additional data field with a script trigger. The trigger will take the value from the field and determine which CF to use. It seems to cover all the possible needed outcome. Tx
  2. Ok, thanks. Let me chew on that for a while. I think I have enough info to (maybe/hope so) find a solution by myself now. Like I said, this is completely new for me.
  3. Ok, from the beginning (if you don't mind, I never went that deep in calculation/logic) We need a return form of xx-xxx if we have 5 digits in the field text We filter the content of field text to only have the digits. We test if from the filtering the first character is a digit num1 = not IsEmpty ( Filter ( Left ( text ; 1 ) ; digits ) ) That will return a 1 for true or a 0 for false We test for the next character num2 = not IsEmpty ( Filter ( Middle ( text ; 2 ; 1 ) ; digits ) ) Returns a 1 or 0 Test the next: not IsEmpty ( Filter ( Middle ( text ; 3 ; 1 ) ; digits ) ) Returns a 1 or 0 Test the next: not IsEmpty ( Filter ( Middle ( text ; 4 ; 1 ) ; digits ) ) Returns 1 or 0 and, to have a return xx-xxx, where 5 digits are involved, we need to test also for the 5th not IsEmpty ( Filter ( Middle ( text ; 5 ; 1 ) ; digits ) ) Returns 1 or 0 At this point I understand that we test to see how many digits we have in the 'text'. What I don't 'see', yet. is how we know if the digits are grouped. We can have TA12 which will return TA-12 or 1234BA which will return 12-34-BA, which is correct, but I don't see where in your formula you accomplish that.
  4. I want/try to learn something here: Let ( [ digits = "0123456789" ; len = Length ( text ) ; num1 = not IsEmpty ( Filter ( Left ( text ; 1 ) ; digits ) ) ; num2 = not IsEmpty ( Filter ( Middle ( text ; 2 ; 1 ) ; digits ) ) Here you check for 1 or more than 2 digits... So, if I want to test first to see how many digits I have: num1 = not IsEmpty ( Filter ( Left ( text ; 1 ) ; digits ) ) ; num2 = not IsEmpty ( Filter ( Middle ( text ; 2 ; 1 ) ; digits ) ); num3 = not IsEmpty ( Filter ( Middle ( text ; 3 ; 2 ) ; digits )); num4 = not IsEmpty ( Filter ( Middle ( text ; 4 ; 3 ) ; digits )); num5 = not IsEmpty ( Filter ( Middle ( text ; 5 ; 4 ) ; digits )) To return the xx-xxx, I have to to take the Case() from num5 = 1 (test = true) and Left ( text ; 2 ) & Case ( len > 4 ; "-" & WeirdFormat ( Right ( text ; len - 3 ) ) ) and put that as first line in the result part of the Let(). Am I going somewhere or is it right into a wall?
  5. Comment, I'm sorry.. I presented the solution this morning and the power in charge wants to see a group of 5 digits as xx-xxx. I made already attempts myself, but I'm getting nowhere so far...yet. Are you willing to tell me what and where I have to change the syntax ? Thank you.
  6. odd numbers of digits in group of 2 x: x xxx: xx-x xy: x-y xxxy: xx-x-y yyyxxxxx: yyy-xx-xx-x
  7. As I said, the CF (http://www.briandunning.com/cf/395) will return the letters separated from the digits/numbers. ABCD-1234, where I need ABCD-12-34 or, when no letters as input data: 12-34
  8. It should separate the letters from the digits, regardless how many letters. xxxx should return xx-xx xxxx with any letter at whatever place xx-xx-letter, letter(s)-xx-xx etc.
  9. Hi all, I have a text field that can hold data in the form x and y, where x is digit and y letter. It can have several different combinations: yyyxxxx, xxxxyyy, xxyyyxx etc. I need a return in the form: when there only digits, like xxxx, xx-xx (a dash every 2 digits) when there is a combination, like yyyxxxx, yyy-xx-xx (letters, dash, 2 digits, dash, 2 digits) xxxxyyy, xx-xx-yyy xxyyyxx, xx-yyy-xx Any hint of possible formula ? I use already a cf to separate the letters from the digits, but can't have a return when there are only digits... TIA
  10. Duh... I had that step in the first file instead of in the second.... It's working now... Tx
  11. I have two files (not tables) with in the first file a GTRR to the second file. This is working, only, the related records are showing in the second file, where I want them as window on top of the first file. Which script step do I miss or have to use? Now I have to click on the 'Window' in the taskbar.... Tx
  12. Sure. One main table with general contact data. A related table for all the types of addresses, work, home etc A related table for all the telephone numbers, work,home...etc I show the info of those tables on the main layout and there I can sort them. The 'primary' address and telephone etc are the first row in each portaql. So, if the home address is in the first portal row, that will be the primary address and should be used in all other places where the address of that contact is used. When I change the order in the address portal, and another address becomes the first row, f.i. the work address, then that address should be used as primary address. Now it is always the first entered address. I need a way to flag the first record showed in the portal after sorting. On a specific information layout I (want to) show all the primaries, address, phone, mail address etc. As I said, now I always get the first entered data in the relate tables, because I don't know how to flag the records there as 'primary' after sorting the portals. I saw it done somewhere, but don't know how to do it. It is possible....
  13. Hi all, I'm looking for a way to dynamically flag which record is the first in a portal. I have a portal showing records from a related table. I can sort the record in the portal. Now I need to know which record is the first one after sorting, because I need that record showing up in an other portal. In that portal I need to show all the records flagged as 'first'. Any hint? TIA
  14. Now I get somewhere. Thanks for the info. Appreciate.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.