Results 1 to 5 of 5

Thread: text functions

  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: text functions

    I have a string that looks like:
    9,10,2,1,11,12,8,3,7,4,6,5

    a formula should generate:
    09,10,02,01,11,12,08,03,07,04,06,05

    any ideas?

  2. #2
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203

    Re: text functions

    What is it your trying to do, convert a text string or run a calculation? Please provide some detail. Is your text strings coming from separate fields or records?

    Originally posted by mentor1
    I have a string that looks like:
    9,10,2,1,11,12,8,3,7,4,6,5

    a formula should generate:
    09,10,02,01,11,12,08,03,07,04,06,05

    any ideas?
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

  3. #3
    Join Date
    Feb 2004
    Posts
    1

    Smile Re: text functions

    Originally posted by mentor1
    I have a string that looks like:
    9,10,2,1,11,12,8,3,7,4,6,5

    a formula should generate:
    09,10,02,01,11,12,08,03,07,04,06,05

    any ideas?
    I think this will help you!

    Look at the attachement.
    Attached Files Attached Files

  4. #4
    Join Date
    Feb 2004
    Posts
    5

    Re: text functions

    Originally posted by RickKnight
    What is it your trying to do, convert a text string or run a calculation? Please provide some detail. Is your text strings coming from separate fields or records?
    Thank you Rick,
    I resolved the problem with AppleScript. Originally i wanted to generate a list of non repeating random numbers with filemaker. But I could not figure out how to do it, so i tried with AppleScript.

    If you look inside my little program - you can see all the details.
    (sorry it is in german)

    Maybe you find a way to do it without AppleScript?
    Would be good for Windows-Users.
    Attached Files Attached Files

  5. #5
    Join Date
    Feb 2004
    Posts
    5

    Re: text functions

    Originally posted by Bojan
    I think this will help you!

    Look at the attachement.
    Thank you Bojan,
    your calculations are useful. I will experiment with them.

    Originally i wanted to generate a list of non repeating random numbers with filemaker. But I could not figure out how to do it, so i tried with AppleScript.

    If you look inside my little program - you can see all the details.
    (sorry it is in german)

    Maybe you find a way to do it without AppleScript?
    Would be good for Windows-Users.


    --> Attachment location --> see Ricks answer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •