Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 12 August 2021
  0 Replies
  1.6K Visits
0
Votes
Undo
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  
There are no replies made for this post yet.