Discussions

Expand all | Collapse all

How to Remove trailing numbers from user fields Before Export

  • 1.  How to Remove trailing numbers from user fields Before Export

    Posted 06-01-2017 01:23


  • 2.  RE: How to Remove trailing numbers from user fields Before Export

    Posted 06-01-2017 01:27
    For so,e operational reasons, we have had to export a list of projects where we also have all resources identified.  Once exported all user names have some alpha/numeric characters as part of the listing: E.g. Martin Emery <59711232.k98w> 

    Without having to create formula fields, is there a possibility that I could export the user with just names?
       


  • 3.  RE: How to Remove trailing numbers from user fields Before Export

    Posted 06-01-2017 01:47
    The alternative could be to deal with the removal in Excel, but it would take a formula in excel to remove the trailing characters.

    Presumably you are aware that you can have a formula field in QuickBase to convert the User field to a clean name

    UserToName([Project Manager])

    But you said "without using formuals".

    It is also possible that your User fields are actually selected from a table of users and their clean name may be there.  You could choose to export their Name instead of their Userid.


  • 4.  RE: How to Remove trailing numbers from user fields Before Export

    Posted 06-01-2017 01:59
    Thanks a lot, as always.