Same qvw file different result in 2 editions QV9 sr6 and sr7

[#1]

test:
load
      NAME, 
      SPDM
from user.qvd(qvd);
LOAD
NAME as USERID1, 
subfield(text(SPDM), '|') as AAA
resident test;

In sr6 everything is ok with b.jpg.  In sr6, qv cant show AAA field with a.jpg. The table test is also like b.jpg.  Because sr7 is the product eviroment I can't reinstall qv from the server.   I want to know is it a bug? or I something I can do to solve the problem.  It stop my progress in deploying qv to user's server. I need your help  thank you!

[disqr_rm]

Not sure how your data looks like, but try putting 1 in the subfield to select the first value before pipe:

subfield(text(SPDM), '|', 1) as AAA

If still doesn't work, please post your data file sample and application here.

[#3]

Hi,

I want to use these function to get each sub string.  if  SPDM='1111|33333|4444'  the function will return '1111'  and '2222' and '3333'. But the third parameter of subfield will only return the 1st string if subfield(text(SPDM), '|', 1).

Here are my files. And they are work in sr6 and run failure in sr7. Is it a BUG?

[disqr_rm]

Well, first of all you don't need the text() function. Since you have pipe in the field value, it cannot be number. If you want the return value to be text type, the function needs to be on top on subfield. So something like: text(subfield(SPDM, '|'))

Secondly, check you QVD contents. I do not see SPDM having string with a pipe delimiter - at least not in the one you attached.

[#5]

hi,

1st, yes, you are right. The text function is not nessesory.

2nd. In SPDM field, if there is no pipe delimiter, I want it return only the value. For example, if SPDM is '11111', the subfield returns '11111'. And if SPDM is '11111|22222' it will return '11111' and '22222'. So I don't think it is  the reason of getting 2 result in 2 QV editions.

I have no idea now on how to solve this problem.

[#6]

I have tested in QV10sr2, is OK. I think may be only QV9SR7 is not work....