Get values out of a field

[Jokez]

Hello!

I wounder if there is a way to get out what diffrent kinds of values there are in a filed? If I have 4000 Records with either 1 or 2 in a field called "number" then I just whant to get a list with 1,2. A list with the different types of numbers entered..

Regards Jocke

[Sanjai]

You can create a value list based on your field. The value list shows unique values. Then you can parse the listitems in the value list to use the unique values.

[-Queue-]

Once you have your value list, create an unstored text calculation of

Substitute( ValueListItems( Get(FileName); "yourValueListName" ); ¶; ", " )

[Jokez]

Thanx!

It worked like a charm! U rock!

// Jocke

[Jokez]

When u have a field with the list containing 1,2,3 and so on... how do I get out the first value to a temp field and do something with that, then the next value and do something with that and so on? Anyone got any clues?

// Jocke

[Sanjai]

In version before 7, I have used one of the design function valuelistitems(dbname,valuelist). This would return you all the values. I believe you can write a script using a global variable:

setfield(gCount)=1

setfield(gValueListItem)=""

loop

gValueListItem = middleword((ValueListItems("dbname" ,"ValueListName" )),gCount,1)

Process field gValueListItem.

setfield(gCount) = gCount + 1

exit loop if(gCount > WordCount(ValueListItems("dbname" ,"ValueListName" ))

end loop

[Jokez]

I did a script like this:

SetVariable($no;Value:1)

Loop

Exit Loop If($no > WordCount(ValueListItems(Get(Filnamn); "Get_Languages" )))

SetField(tempcalc;MiddleWords((Image::Unique_Languages);$no;1)

SetVariable($no;Value:$no +1)

End Loop

Must say that ur sudgestion helped me ALOT! BIG thanx!!!

Regards Jocke

If Anyone whants to talk FM add me: [email protected]