getting positon of value

ssharmila · Post by **ssharmila** » Mon Jun 15, 2009 5:39 am

can anyone tell me how to get positon of value in a list??

ex, A is an input having value like (1,2,3,4), i want to get the position of 2 in it...how can i implement this? Thanks in advance

Sreenivasulu · Post by **Sreenivasulu** » Mon Jun 15, 2009 5:57 am

Pl Search the documentation or search the forum before posting

Regards
Sreeni

ArndW · Post by **ArndW** » Mon Jun 15, 2009 6:18 am

If you have a string with the value of "1,2,3,4,5" then the function "FIELD(In.String,',',2) will return the 2nd field as delimited by commas.

chulett · Post by **chulett** » Mon Jun 15, 2009 6:42 am

Index() will return the position of a substring within a string, but it sounds like you want to Locate() an array element instead. Check the documentation for the difference.

ArndW · Post by **ArndW** » Mon Jun 15, 2009 7:09 am

Craig - I recall that the function LOCATE() doesn't work in server transforms, just the "LOCATE x IN y SETTING z" syntax.

chulett · Post by **chulett** » Mon Jun 15, 2009 7:26 am

Correct, you'd need to write a custom routine to leverage that. Plus convert all those commas to Field Marks or Value Marks or some kind of dang marks first.

ssharmila · Post by **ssharmila** » Tue Jun 16, 2009 12:28 am

chulett wrote:Correct, you'd need to write a custom routine to leverage that. Plus convert all those commas to Field Marks or Value Marks or some kind of dang marks first. ...

Thank you all...I will try to write routine for that