Split function

Question

Split function

lukaszpiech

SSCommitted

Points: 1538
More actions
November 22, 2017 at 8:50 am

#324590

Hello,
I need to pass a comma separated values to subreport. The string that is used to obtain input parameters is below
"02 Programming & Broadcasting expenses, 03 Selling expenses,04 General & Admin. Expenses, 05 Other operating income/(expenses), net"
It used to be done with help of Split function but now i have to deal with extra field "05 Other operating income/(expenses), net" that has comma within it so now Split function divides new string to "05 Other operating income/(expenses)" and "net".
Can you please help me to find solution to pass all 4 parameters?
I've tried to concatenate values like this
= "02 Programming & Broadcasting expenses" & "," & "03 Selling expenses" & "," & "04 General & Admin. Expenses" & "," & "05 Other operating income/(expenses), net"
but it doesn't work. I don't see any solution 🙁

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

lukaszpiech - Wednesday, November 22, 2017 8:50 AM
Hello,
I need to pass a comma separated values to subreport. The string that is used to obtain input parameters is below
"02 Programming & Broadcasting expenses, 03 Selling expenses,04 General & Admin. Expenses, 05 Other operating income/(expenses), net"
It used to be done with help of Split function but now i have to deal with extra field "05 Other operating income/(expenses), net" that has comma within it so now Split function divides new string to "05 Other operating income/(expenses)" and "net".
Can you please help me to find solution to pass all 4 parameters?
I've tried to concatenate values like this
= "02 Programming & Broadcasting expenses" & "," & "03 Selling expenses" & "," & "04 General & Admin. Expenses" & "," & "05 Other operating income/(expenses), net"
but it doesn't work. I don't see any solution 🙁

Best guess, change the delimiter between elements to something like a vertical bar (|).

lukaszpiech SSCommitted Points: 1538 More actions · Answer 2

So, it's that simple. Man i feel stupid 🙂
Thank you for quick reply!