Inserting/Deleting Spaces
I have 5 character data that comes in with 0, 1, and 2 spaces.
I need to convert this data like so:
X__QH I need X_QH (2 Spaces replaced with 1 Space)
GS_EB I need GS_EB (1 Space No Change)
GOUQT I need GOU_QT (No Space, after 3rd Character insert 1 Space)
Is there a way to accomplish this ?
Thank you in advance.
|