0

Extract text from linked table

How do I extract and splice the record WEVBrandUID_0273 in the field WEV_Brand_UID in the table 'EVNews' from linked table 'EV Strategy' ? Thanks

Screen Shot 2020-04-05 at 12.35.40 PM

5 replies

null
    • Terry_Prokopchuk
    • 3 yrs ago
    • Reported - view

    Cant you just use the 'Show as' function in options to extract the text you want?

    • wynand
    • 3 yrs ago
    • Reported - view

    Not sure how that will work. The source is a linked table, so all the fields are in one string. It would be interestng to see your proposal, can you give an example? thanks

    • Terry_Prokopchuk
    • 3 yrs ago
    • Reported - view

    1. So when i select a linked option via the search field, the full string of information is copied into the cell as shown....Screenshot 2020-04-06 at 17.11.32

    2. however if i click on the field options and click 'more options' and click on the 'show as' field.....

    Screenshot 2020-04-06 at 17.08.25

    3. then when in the editor i simply select the fields that i want to be displayed, in this instance a contacts 'First Name' and 'Suranme' spaced with " ".

    Screenshot 2020-04-06 at 17.09.11

     

    it then only displays the infromation required from that string of infromation....

     

    Screenshot 2020-04-06 at 17.09.36

     

    Hope you can make sense of this?

    • wynand
    • 3 yrs ago
    • Reported - view

    Awesome thanks that was a big help.

    • Terry_Prokopchuk
    • 3 yrs ago
    • Reported - view

    Glad to help, where I can and happy that you've found a solution :)

Content aside

  • 3 yrs agoLast active
  • 5Replies
  • 901Views