Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
7 subscribers
Views
1967 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Function: getprocessnotes(processId) returns a list. If i take one value from li
ambrishs
over 11 years ago
Function: getprocessnotes(processId) returns a list. If i take one value from list and apply split on char(32) on that, it always show array length as 2. 1st element being asdadsa ambrish.srivastava 2013-03-28 and 2nd being 21:29. 1st consists of commentpart userpart dateyearpart, second only minutesecond. Ideally it should have returned array of length 4 after splitting. Now there is no way to get user/Author for notes. Any suggestions!!!...
OriginalPostID-62374
OriginalPostID-62374
Discussion posts and replies are publicly visible
0
Siva
Certified Lead Developer
over 11 years ago
Hi Ambrish, you can use char(10) instead of char(32) to split the data.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ambrishs
over 11 years ago
Thanks it works.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ambrishs
over 11 years ago
I have another issue around the same area. User can enter comment in Add Notes task link. splitting by char(10) works good, but in case user writes a line and hits enter and add another line in same note, it fails. Is there any way i can replace new line with space or something. I tried substitute(text, "\
"," ") but it didnt work.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Siva
Certified Lead Developer
over 11 years ago
Try this one substitute(text,char(10),char(32))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ambrishs
over 11 years ago
Thanks, I reallised that char(10) is also a new line char ascii code. i got it using char(10), by using reverse array since now 1st element would be date and second would be user and rest would be comments. Thanks again
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel