Extracting partial data from a field to another field

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Extracting partial data from a field to another field

Viewing 1 reply thread
  • Author
    Posts
  • May 12, 2023 at 8:58 AM #49408

    Wil Hershberger
    Participant

    I would like to extract all the data after a fixed text string in one field and put that data in a different field.
    The source text is in a field called “Media Notes” the fixed text string is “Recordist original file name:” and the field to place this data into is called “Source File(s)”
    The amount of text after the fixed text is variable from one record to another.
    How would I do this?
    Thank you,

    May 13, 2023 at 7:43 PM #49413

    Brendan
    Keymaster

    Hi Wil,

    You can do this sort of thing with a Script.

    Are you able to write JavaScript?

    https://www.tapforms.com/help-mac/5.3/en/topic/scripts

    You would need to use the JavaScript substring() function to extract out the text you want:

    https://www.w3schools.com/jsref/jsref_substring.asp

    And the indexOf() function to locate the string you want to split the text from.

    Not sure how adept at JavaScript you are, but it’s definitely possible to do what you want.

    Thanks,

    Brendan

  • Author
    Posts
Viewing 1 reply thread

You must be logged in to reply to this topic.