/* 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
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: