Im new to Crystal.
I have an excel file that i'm using as my datasource file.
In the excel file, there is a column I (Customer Search Term)
I want to create a Formula Field to view only the first word of column I.
For example, the below Customer Search Term, i want to extra only the first word "anysharp".
anysharp pro knife sharpener
But, there are first word or number begin with 20 or 3 in the Customer Search Term (column I), i want those too to be extracted like shown below
7 degree knife sharpener
I want to extract "7" only
Hope i have explain my problem above and thanks for your help.