Problems with a word game and tables

JoVe

I'm busy with a dutch word game.
I have imported the words to a table, but how can you check if a word is in the table.
The words are below each.

JoVe

Because GS does not have a search table feature yet, with out checking each cell 1 at a time you can not.

you could do it with out tables like i did here

http://gshelper.com/600000-word-checker-free-demo/

cheers

That's a lot of work with circa 150.000 words........
Thanks for your help!

JoVe

@tshirtbooth Is there a fast way for adding the "!" ?

simo103

@JoVe ... in Excel I created a column before and after the words. I put the ! in the top row and then clicked the bottom corner and it copies down all the rows. Then you can use the excel function to combine the columns.

JoVe

@simo103
How can I fix it? If I combine there's a space between ! and the word.

JoVe

@simo103 Maybe can I mail you the file!

RThurman

@JoVe -- You don't need to have "!!" as your item delimiters. You can use spaces or anything else.

In fact, you can have all the words strung together without any spaces or anything and the 'contains' test will still work.

For example, if you had a text attribute called "MyStringOfLetters" that contained the letters,"nopainnogain" you could create a rule that said:
When Attribute: (MyStringOfLetters) contains: pain
--Display Text: "Yes it is there!"
Otherwise
--Display Text: "Sorry, try again."

The actor would display the text "Yes it is there!"

The test would also work for any string of of successive letters like:
no
pain
gain
nop
nopa
nopain
.
.
.
noga
nogain
in
n
etc...

JoVe

@RThurman I understand what you mean, but jn my game you must make so much words as you can using random chosen letters. If I use this and you type one letter that is in "nopainnogain" is it correct. This must be wrong.

simo103

@JoVe if you would Like I will try to fix it for you ... support @ funkymunkygames .com without the spaces

JoVe

@JoVe if you would Like I will try to fix it for you ... support @ funkymunkygames .com without the spaces

I mailed you.

RThurman

@RThurman I understand what you mean, but jn my game you must make so much words as you can using random chosen letters. If I use this and you type one letter that is in "nopainnogain" is it correct. This must be wrong.

I see I was not clear. (Probably because I went into too much detail on a side note.)

The point is you can use anything for your item delimiters. You seemed it indicate that excel was adding in a space for some reason. My intent was to explain that you can use anything for an item delimiter (or nothing at all). If you want to change the the contains rule to search for "! myword!" (with a space in there), it is OK. You just change the rule. You can use spaces or anything else.

JoVe

@RThurman How do I add spaces in the rule? As I use the space there happens nothing.

JoVe

@RThurman I tried many things but I can't add spaces!

Sparkyidr

@RThurman I tried many things but I can't add spaces!

On a Mac.. hold alt and press the spacebar

JoVe

@Sparkyidr I use this rule for checking:
Touch and then-
Attribute Self.W1 contains "!".. game.Invoer .."!"
In Self.W1 stands the tekst for testing ! ar ! and in game.Invoer stands ar.
But it doesn't work!

JoVe

Is there no possibility in Excel for removing the spaces?

JoVe

Because GS does not have a search table feature yet, with out checking each cell 1 at a time you can not.

you could do it with out tables like i did here

http://gshelper.com/600000-word-checker-free-demo/

cheers

I mailed GameSalad about search function.

simo103

@JoVe .... I couldn't open the file you sent me in Excel as it was an OpenOffice (.ods) format. Is that what you are using? Does that program allow export to .xls so I can help you?
If not export to .csv and send that or if you have managed to get the "!" added to your words but still need the spaces removed ... I believe you should be able to open the .csv with a text editor and then find and replace spaces with nothing .. hope that helps!

JoVe

Thanks @simo103, it worked with all 165.000 words.

simo103

@JoVe ... glad it's working .. good luck with the rest of the App.