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!!!...

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