How to Store Variables in string then later evaluate

[RobMac]

I dont know the correct terminology for this so maybe not finding it in my searches.

I am trying to build a query based on settings I put in the first line of a tab delimited file. Then based on these settings and terms I want to run through the rest of the lines to actually run the queries.

So basically my question is how can I store a set of text and variable names in a string variable then later "use it" and have the variables inline be evaluated and replaced with their values. I know how to do everything besides creating a string with variables that will later evaluate to replace variables with values.

Example:

If my top row from my input file was:

( 1 and ( 2 or 3 or 4 ) .

I would want to create a variables that says: "( $instring[1] and ( $instring[2] or $instring[3] or $instring[4] )"

(Obviously if this line was different I would want to create a different arangement of variables for the query string).

Then when these values are read in from later lines:

Fruit apple pear peach

Vegetable carrot tomato squash

Should turn into:

( Fruit and ( apple or pear or peach )

( Vegetable and ( carrot or tomato or squash )

Thanks as always for any help.

-Rob

[SadBunny]

How about...

$sMyString = "( " & $instring[1] & " and ( " & $instring[2] & " or " & $instring[3] & " or " & $instring[4]) "

Edited February 8, 2008 by SadBunny

[Zedna]

Eval()

Dim $a_b = 12
$s = Eval("a" & "_" & "b"); $s is set to 12

Edited February 8, 2008 by Zedna

[RobMac]

Thanks I guess I should have trusted my choice of "evaluate" as the term describing what I wanted to do and searched on that.

[Zedna]

Thanks I guess I should have trusted my choice of "evaluate" as the term describing what I wanted to do and searched on that.

You are welcome in AutoIt's world :-)

Answers for 99% of all questions are in AutoIt helpfile

trust me I know what I'm talking about because I read it :-))

Edited February 8, 2008 by Zedna