locked
How to parse one field into multiple fields using delimiter RRS feed

  • Question

  • User1138619898 posted

    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.
    thanks
    Al

    Monday, May 14, 2012 12:14 PM

All replies

  • User-661350001 posted

    you may do it in c# and then assign the datasource to report

    Monday, May 28, 2012 10:25 AM