Hello! I'm a new member to the forum and I apologize if this question has been asked before - BUT -

Using Crystal Reports Professional IX

I have an Oracle ODBC database I'm trying to query with Crystal Reports. The particular field I need to extract data from is a string field containing several different pieces of information separated by 'pipes' ( '|' ). The front part of the field contains technician names, so it is always a different length. The back part of the field contains user-entered info, so it is always a different length as well. Because of these different lengths, I can't simply count characters and display the info I need - which is located in the MIDDLE of the string (date-time info). The info is imported from another database, so I can't simply find the desired info in another table.

Is there a way to take the whole string and FILTER the info by counting the number of PIPE ( '|' ) separators? the field contains 6 different types of data all separated by this character, and I'd love to be able to pull out the data between pipes number 3 and 4.

Can this be done?

GregSki


Edited by busy2mch1 - 13 Feb 2012 at 12:46am

of course if you wanted to access all the parts, you would 'split' them into an array of strings, and then you could display the parts that you want by accessing the members using the notation that rkrowland supplied...