0
Undo
Votes
The site for which my data was pulled has upgraded and now names of individuals who purchase new plans have a space in between their name (last , first), while older individuals with plans are your typical (last, name). The only problem is that if a previous version person purchases a new plan, then old plan will show the old way and then new plans show the new way, and when subtotaling they are recognized as two different people. How do I create a column to clean this space out so they can all be the same so subtotal can recognize them?
PolicyholderPolicy NumberLine of Business Post-Tax Amount Pre-tax Amount Coverage TypeStatusLast , First12345678STD $ 31.20 $ - INDNewLast , First Total $ 31.20 $ - Last, First13254646CANCER $ - $ 16.75IND Last, First65688315ACC $ - $ 12.22IND Last, First Total $ - $ 28.97
PolicyholderPolicy NumberLine of Business Post-Tax Amount Pre-tax Amount Coverage TypeStatusLast , First12345678STD $ 31.20 $ - INDNewLast , First Total $ 31.20 $ - Last, First13254646CANCER $ - $ 16.75IND Last, First65688315ACC $ - $ 12.22IND Last, First Total $ - $ 28.97
There are no replies made for this post yet.