Last post May 28, 2012 10:25 AM by Mudasir.Khan
May 14, 2012 12:14 PM|alsallam|LINK
I have one field that has a path with a backslash delimiter "\". I am trying to break it into separate (formula fields) in Crystal. Is there an easy way to do this? I am new to Crystal. Here is the field that I want to break down to several fields based
on the "\":
\Organizations\Bloomberg-HR\Board Of Directors-1\News/Media/Financial Prod/Data-2\Financial Products-23\Core Terminal-8734\Core Sales-27297\Core Sales Europe-2517\C-Sales LO London B/S & Scotld-2293\Buyside 2-7203
that one field above should populate several fields as below.
Organizations Bloomberg-HR Board Of Directors-1 News/Media/Financial Prod/Data-2 Financial Products-23........Buyside 2-7203
I do this in Excel using (text to column) with "\" as delimiter.
May 28, 2012 10:25 AM|Mudasir.Khan|LINK
you may do it in c# and then assign the datasource to report