Source data stored in elements of array

[raghuvr33]

Hi,

I am having difficulty in getting data from ERP source where sales person is stored in elements of array. Upto four Sales persons are stored in one field slspsn with four elements slspsn[1] , slspsn[2] , slspsn[3] , slspsn[4] . Each of these elements have a different Slsperson data in them. Specifying slspsn[1] in the load statement and sql part of the load statement is throwing errors.

I would appreciate if somebody can guide me how to retrieve this kind of data into QV .

[Gysbert_Wassenaar]

What does the content of the field look like? Is it a text string? Or is it binary data?

[raghuvr33]

It is text data storing the initials of the sales person

[Gysbert_Wassenaar]

Can you post the complete text string value of one field value?

[Anonymous · Accepted solution]

See subfield() function, maybe this is what you need.

[raghuvr33]

That was it. Many thanks to both of you. Orginally while extracting the data from source erp, only the field name 'slspsn' was specified without any elements of the array. This retrieved all the data from the field delimited by ';'. I did a test and was able to successfuly get the sales persons name from individual elements by using the subfield function in QV.

Thanks again.