Instr 1

[gooseriver]

On my report I have a string value with a (test). I need to take the value between the "(" and ")" and store it into a stringvar..

How can I do this so that the value in stringvar var1 is test?

 

[gooseriver]

I tried the folowing and my resuly was left with a ). In this case I used replace function to replace ) with a space... Is there a better way to do this?

If Instr({table1.field1},'(') <> 0 Then
strReverse(Split(strReverse({table1.field1}),'(')[1])
Else
{table1.field1}

 

[jambu]

Try the following

stringvar sTest := "gturteteey(test)sdfytu";
stringvar sResult := "";

if instr(sTest,"(") > 0 and instr(sTest,"(") > 0 then
sResult := mid(sTest,instr(sTest,"(")+1,(instr(sTest,")")-instr(sTest,"("))-1)
else
sTest

 

[AndyMc]

I think there is a slight typo on second 'instr' test in the 'if' statement. Cool formula jambu.

stringvar sTest := "gturteteey(test)sdfytu";
stringvar sResult := "";

if instr(sTest,"(") > 0 and instr(sTest,")") > 0 then
sResult := mid(sTest,instr(sTest,"(")+1,(instr(sTest,")")-instr(sTest,"("))-1)
else
sTest

Andy

 

[jambu]

Well spotted andymc. Thanks.