# jrRaid

Members

103

• Gender
Not Telling

## Recent Profile Visitors

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

0

1. ## Return input in specific form

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. ## Return input in specific form

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. ## Return input in specific form

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. ## Return input in specific form

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. ## Return input in specific form

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. ## Return input in specific form

Great !!! Works like a train. Tx Comment
7. ## Return input in specific form

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
8. ## Return input in specific form

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
9. ## Return input in specific form

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.
10. ## Return input in specific form

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
11. ## Go to related record in file not working

Duh... I had that step in the first file instead of in the second.... It's working now... Tx
12. ## Go to related record in file not working

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