text logic

Question

Hi Team, 
 
 users: "username1; {username1; username2}" =>type text 
 
 how to get the output as 2 items 
 username1 
 {username1; username2}

Mathieu Drouin · Accepted Answer

Yes you can use the split function but not sure if that will help you do what you want to do. 
 docs.appian.com/.../fnc_text_split.html

Mike Schmitt · Answer

I would recommend against storing an array as a flat string like this. If you really need to, then I'd suggest you create a JSON string via a!toJson(), since the resulting JSON string will be able to be parsed back into an array later simply by using a!fromJson().

Mike Schmitt · Answer

Purvaja said: this text 
 Where is "this text" coming from in the first place? It looks like you're handling an Appian array which, when rendered for display, is given with a ";" separator - but to clarify against a common misunderstanding, arrays do NOT actually contain a ";", it's just there for display reasons. However if you're trying to parse an already-flattened string, then it'll take a bit more work.

Mike Schmitt · Answer

joinArray( ri!userList, "," )

Mike Schmitt · Answer

Purvaja said: can you suggest any alternative approach? 
 Is this literal string the only thing you will ever need to handle? Or are there potential variations? This is why I was asking what the source for this string is - if we don't know what cases you'll need to handle, it's nearly impossible to give a meaningful solution.

Mike Schmitt · Answer

Purvaja said: rule inputs that passes the current user list, 
 Can you provide some more detail on this? What format(s) are the rule input(s)? In what way is it/they assigned the "current user list"? What are you trying to achieve overall?

Mike Schmitt · Answer

Well the thing there is - a!pickerFieldUsers() will store an array of users - there should be no need to ever manually parse it via splitting a semicolon-delineated flat string.

Mike Schmitt · Answer

This rule is confusing together the separate elements of array data and flat text data in several different places and several different ways - until you understand the difference and code to this, the output you see will consistently be unexpected and confusing. I'm not even clear what you're trying to do.

text logic

Top Replies