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.

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

Martin Dráb 239,093 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
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]; }

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Martin Dráb 239,093 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

FilterCode is an array field, not a container.

Was this reply helpful? Yes No
Karuna Dogra on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,093 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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; }

Was this reply helpful? Yes No
Karuna Dogra on at

Like (0)

Report
Copy link

Link copied!

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

regards

Karuna

Was this reply helpful? Yes No