BerSerK6996
29th November 2007 00:28 UTC

String manipulation and loop problem
Hi,

I run a query on a mysql server and I get this return value :

Tables_from_database (~tmp%)
~tmpclp481551
~tmpclp481552

I managed to clean this a bit to get :

~tmpclp481551
~tmpclp481552

Those two strings are mysql tables that I need to "DROP" but I can't figure how to make some kind of loop to do it. I already know how to run my drop query, I mostly need help to work with the string and loop.

I bet it's simple but I just couldn't find anything in the manual, examples or Google.

Any help is much appreciated!
Thanks;)

kichik
29th November 2007 17:13 UTC

WordFind should the trick. It allows you to split strings.

BerSerK6996
29th November 2007 18:19 UTC

Thanks solved, I managed to avoid the loop by formatting my string like

drop tables `table1`,`table2`

I used nsPerl to make all my string manipulation since I know more Perl than NSIS.

Thanks!