Quark Forums

 Hello,

I want an external table with the action "Get text from URL" and read the field data in separate text boxes display.
I have a test table (testfile.tab) from my database with the following fields are exported, and loaded on the server: "name1, name2, name3"

With this script should be "name1" in TextBox1, "name2" in TextBox2 and "name3 in TextBox3 may be displayed:
Action1:
Text Object: "TextBox1" URL: "http://www.domain.com/testfile.tab" Starting "Last Read item" Read Until: "Special Character" Character "," Placement: "Replace All"
Action2:
Text Object: "TextBox2" URL: "http://www.domain.com/testfile.tab" Starting "Last Read item" Read Until: "Special Character" Character "," Placement: "Replace All"
Action3:
Text Object: "TextBox3" URL: "http://www.domain.com/testfile.tab" Starting "Last Read item" Read Until: "Special Character" Character "," Placement: "Replace All"

Works great, but this script is very "creative" because in the text boxes after each term is a different name and always a different combination:
TextBox1 = "name2", TextBox2 = "Name1, TextBox3 =" name1 ", TextBox1 =" name3 ", ...

I have almost all the parameter variations tested and it does not get to grips with.
What am I doing wrong, or is there a better method?

Thanks for your help

Hi Mani,

Does your testfile.tab differentiate between two fields and a new line. Can you please try to seperate fields of same line with tab and separate two lines with special character, say ",".

If you do so, Action for text box3 would remain same and you need to modify actions for Text box1 and Text Box 2 for Read Until: Tab.

Kindly try above suggestion and let me know if it works. Also it would be great if you can send your .tab file so that we can achieve the desired result.

Thanks