Search results for query: *

I'm using Crystal XI How do i remove characters from the beginning of a field when it's not always the same amount of characters being eliminated? I only want to display the characters after the last '>' sign. Input: Student ID->Name->Bob Student ID->Address->Arrowhead Student->City->Waterloo...

Thanks CoSpringsGuy - that worked perfectly.

I did some more testing on the data and if I replace the dash '-' with a blank the data exports to the CSV file correctly. So now my question is, what is the formula to replace the dash with a blank? Keeping in mind the dash isn't always in the same spot in the field. Sometimes it's the 2nd...

Here's a sample of how the data is displayed in my Crystal Report: 12-13 u17-23 12 - 3 22-24 Here's how the above data is displayed in the CSV file: 13-Dec u17-23 3-Dec 22-24

Thank you but I'm unable to change the source data. This field is not a NN-NN format it's an alpha/numerica field where anything could be entered. It's only when someone enters data that can be converted to a date that I'm having a problem. I was hoping someone could provide a formula that I...

I'm using Crystal XI. I have a field in a Crystal Report that displays correctly as: 01-02 When I export the Crystal Report to a CSV file the field is converting to a date format of mm/dd/yyyy and displays as: 2-Jan If the field value is 22-45, then it doesn't convert to a date format. It...