Trim Field in Reports

Summary

Separating a field that has a hyphen

Content

Hi there,

I have a field in the Requisition page that has the following data format "100.200.300 - C - S20 - $100,000 and I was wondering if I can trim it so in the report it would so in separate columns (i.e)

Column 1: 100.200.300

Column 2: C

Column 3: S20

Column 4: 100,000

 

Thanks,

Dugi