.NET Programming With Me

Crystal Reports: Separating number and string from a string

/* Formula for CrystalReports */

The output from the dataset is as:
Output: 1.2.5.0.1*Computer


Now, i need to do is separate number from the string using the '*'
String:
MID({journal_view.ac_name}, INSTR({journal_view.ac_name},"*")+1) // Outputs : Computer

Number:
LEFT({journal_view.ac_name}, INSTR({journal_view.ac_name},"*")-1) // Outputs : 1.2.5.0.1

No comments: