philipcaplan

Thanks. file:$filePath was all it needed. Now it works. Much appreciated.

Here is the entire file, all 328kb of it before zipping to 83kb..... PSEFER.fmp12.zip

I thought that maybe it is the filename that is causing the problem, so I tried using a different field in my table whose content was just PS501 but it didn't help. I got: "PS501.txt" could not be created on this disk etctetc. But if I changed $filePath to xxxfilePath in the Export Records script step, the file got created with filename xxxfilePath. Unfortunately, that's not QUITE what I need!!!! Perhaps I'll have to write the files that way by script, and then rename them by hand! A temporary solution, but not very useful! BTW the extra images are ones I tried to delete. "edit" seems to allow me to edit my message shortly after hitting "Submit Reply" but when the message reappears the deleted image is not deleted!!!!!

I have run your test script, and it works. I tried copying-and-pasting from your script into a new script in my FMPro as follows: but I still got a failed result. Any other thoughts?

Yes.

Thank you, comment. I used the "set variable" as follows, and created the following script: The script runs but gave the following error. The filename is valid (I checked by copying a file into OUTPUT and changing its name to match the value of the variable). Please can you advise what I have done wrong!! (Please ignore any image below here, saying ".tab". I have tried to delete it, but it keeps reappearing!!

I have a Script that uses "Export Records" to export a file to the following path: file:../../../../Desktop/OUTPUT/Untitled.tab How do I get 'Untitled' replaced by the contents of a field in my Table?

Thank you comment - I understand and agree with what you are saying. This **is** "an initial password", but you are correct that if my site is successful, I will need to have it programmed so that all passwords are stored as for example a hash of password/username-or-email. I do understand that. I have done a fair amount of reading on this matter. In fact, it is now such a well known technique, that I am amazed that there are still any databases of plaintext-passwords floating around in the world!

Hi Fitch. Sorry if I offended you. Bad choice of word. Please accept my apology. Thank you comment. The latest one seems to do the job I need, and as you say it is simple (as per Occam's Razor, I think). True randomness is not essential. I am using these calcs to generate a password to give to users of a website I am trying to create, with a format of word99word (ie, 2 "random" words separated by a 2digit number). What I am seeking is "close to uniqueness". With 2000 words the chances of the same password being generated twice I calculate at 1:256million - good enough I think. This is similar to the password that AOL gave me about 20 years ago, which I can still remember!! So many passwords since then!!! If I start getting users, I can pay a freelance programmer to reproduce the technique **plus** a check that the generated pword is not already in use, as well as other parts of the "signup" process which I am currently prototyping by pasting the results of an online hosted form into my FMPro database to extract name, email, etc, and then email them confirmation with the password to use. Thanks once again for all your help.

Fitch is correct. I wanted the random number to never contain the digits "0" or "1" because when they are displayed to a user of my website, they can (depending on the font used and other factors) be confused with the letters o or O or l or I (the last two were "l' as in lemon, and "I" as in India, thereby proving my point of wanting to avoid possible confusion!!). I tried using his formula above [from Let( to result)] and it seemed to work OK. I then tried the following (which was in an email sent from this thread to me in Fitch's name, although I don't see it on the site!!): Filter ( GetAsNumber ( Int ( Random * 10 ) & Int ( Random * 10 ) ) ; "23456789" ) and while it also seemed to work, after producing a number of good results (such as 23, 67, 94, etc) it then gave a blank result!! Presumably both random numbers generated on that occasion resulted in 01 or 10 or 11 -- and so the entire result was "filtered" out!! So, I am using the Let(...result) formula -- although it will probably be far more difficult for (porr little me) if I need to come back and try to understand it in the future!!! In fact, looking at it now, it looks as though it currently only generates numbers up to 29, and I would have to type into it all the other possible numbers to get up to 99. Fitch chickened out of doing that!!! And, since I now feel that 2 digits looks better (more regular) on my site than just one digit, perhaps what I really want is a number between 22 and 99 (excluding any that include "zero" or "one"). Of course, I can put all the numbers into the Let...result) formula to achieve that. Or is there a version of the "Filter" formula that would work to always guarantee two digits as a result (with no 0's or 1's)?

Thank you, comment. That worked perfectly!! Now, I'll be grateful if can you also help me with the following: to create a random number from 1 to 99 but excluding "zero" and "1" (ie, only using 2,3,4,5,6,7,8,9). Many thanks. Philip

I have two files called "signup.fmp12" and "2000-words.fmp12". I am using FMPro16 on MacOSX 10.13.3. "2000-words.fmp12" has ABOUT 1950 records with only 2 text fields: one called "serial_number" and the other called "word". Each contain unique values. I want to add a calculation field called "pword" to "signup.fmp12" which fetches one random word from "2000-words.fmp12" So each record in "signup.fmp12" will have one randomly-different word in the field "pword". (Strict randomness is not essential) I am unsure how to "connect" these 2 files so that this can be done. Could some kind person please give me some nice clear "idiot-proof" instructions on how to do this. and how to create my "pword" calculation field. (Note: the unique "serial_number" associated with each unique "word" in 2000-words.fmp12 may be of help in this calculation, or it may be quite un-needed!!)

Thanks comment. That doesn't quite work as I expected! Here's my calculation: Let ( [ lineStart = Position ( input ; "¶Your wording (up to" ; 1 ; 1 ) ; lineEnd = Position ( input ; ¶ ; lineStart + 1 ; 1 ) ; start = lineEnd + 1 ; end = "Image Choices" ] ; Middle ( input ; start ; (LineEnd - LineStart))) My 'input' includes the following text: Your wording (up to 500 letters/70 words) This is my wording of up to 70 words. On several lines. Optionally finishing with a return. Image Choices A small image (your Wording will run around it) The result I get is 2 lines only, truncated after the 4th char of the 2nd line: "This is my wording of up to 70 words. On s" when what I expected was all 3 lines: "This is my wording of up to 70 words. On several lines. Optionally finishing with a return." What have I done wrong??

Sorry that I was not clear. Assuming the following as part of 'input': Your wording .......other text........ up to 140 characters This is the 1st line of the customer's wording [return] And this is the 2nd line [return] And this the 3rd & final thing the customer typed [maybe a return] Upload an image what I need is a calculation field which extracts the following: the text starting with "This is....." and ending with "the customer typed" [plus return if there is one] In other words, the "start" of extraction is marked by a line beginning "Your wording" and the "end" is marked by a line beginning "Upload an image"

Hi. Could I ask for another version? At present, the "second one" extracts the text up the end of the line. What I need **also** is a version of that code which extracts all text (including any 'returns') from the beginning until the occurrence of specific text (such as "Image Choices")