String Manipulation
I have data imported from accounting software that I'm working with. What I
need is to have a column that diplays just the length of the part off the end
of the description. Lengths are in formats like 20-1/4, 4, 5-1/4. They are
always preceded by one or more spaces and are always at the end of the
description. Can anyone help? Following are two examples of descriptions
06530FB0325_SP MDP REC PCH 155 3-1/4
12810FB46_SP MDP LO STD PCH 155 46
Q5478MB/W075_DPBSP REC RAL6027 155 7-1/2
|