Converting array to str and storing in a field

(1) Share

Report

Posted on by Karuna Dogra

Hi Team,

I have created a custom entity for whsinventtable and created a virtual field called strfilterCode. In postload method, I want to store filtercode array field value to this virtual field. How can I convert array to str and store in this virtual field? Please help.

All responses (6)

Answers (2)

Karuna Dogra on at

Like (0)

Report

Converting array to str and storing in a field

That worked. Thanks a lot Martin (The Genius). This thread can be closed.

regards

Karuna
Verified answer

Martin Dráb 233,013 Most Valuable Professional on at

Like (1)

Report
Converting array to str and storing in a field

It's trivial - you just need a condition to skip adding the separator if the filter code value is empty. For instance:
for (int i = 1; i <= dimOf(whsInventTable.FilterCode); i++) { str filterCode = whsInventTable.FilterCode[i]; if (filterCode && this.StrFilterCode) { this.StrFilterCode += ','; } this.StrFilterCode += filterCode; }
Karuna Dogra on at

Like (0)

Report

Converting array to str and storing in a field

Thank you so much Martin, that works. Also, I have been trying to mark that check box does this question your answer but its just keep buffering.

Can you please also guide, how I can avoid extra comma in the string field StrFilterCode in case out of 5 indexes (Filter code 1, Filter code 2, Filter code 3....) only one index has value? It is storing the value like this Item1,,,,

Please guide.

Thank you
Martin Dráb 233,013 Most Valuable Professional on at

Like (1)

Report

Converting array to str and storing in a field

FilterCode is an array field, not a container.
Suggested answer

Bharani Preetham Pe... 3,624 Moderator on at

Like (0)

Report

Converting array to str and storing in a field

Are you saying you have a container value to be stored in a string field? If yes, then you can make use of standard con2str() and pass any delimiters if you need.
Verified answer

Martin Dráb 233,013 Most Valuable Professional on at

Like (2)

Report
Converting array to str and storing in a field

Do you want values separated by a delimiter?

You could use something like this:

for (int i = 1; i <= dimOf(whsInventTable.FilterCode); i++) { if (this.StrFilterCode) { this.StrFilterCode += ','; } this.StrFilterCode += whsInventTable.FilterCode[i]; }