SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only

  • 1.  Spssinc modify tables : regex not working

    Posted Mon March 14, 2022 05:45 PM

    I would like to highlight the totals and subtotals in my custom tables.

    So I'm using the following syntax :

    spssinc modify tables subtype = "Custom Table" select = "Total" regexp = yes dimension = rows level = 1 process = all /styles applyto = both textcolor = 0 119 187.

    But the only result I get is the following error message : "Invalid regular expression: (Total) error: cannot use LOCALE flag with a str pattern".

    I don't speak Python so I don't know how to fix this ?






    #SPSSStatistics
    #Support
    #SupportMigration


  • 2.  RE: Spssinc modify tables : regex not working

    Posted Thu March 17, 2022 01:33 PM

    I responded to this, but I have not seen a reply...

    The regex pattern looks okay to me. Can you paste the syntax and post it just to be sure?

    What version of Statistics are you using? Also, do you have the latest version of SPSSINC MODIFY TABLES as posted on the Extension Hub?

    Are you running Statistics in Unicode mode (which is the default)? Use SHOW LOCALE to find out if you are not sure.

    If you can send me the spv file and the syntax (jkpeckSupport Member), I can take a look.






    #SPSSStatistics
    #Support
    #SupportMigration


  • 3.  RE: Spssinc modify tables : regex not working

    Posted Thu March 17, 2022 02:34 PM

    Hi Jon.

    I'm using the 2.0.2 version of SPSSINC MODIFY TABLES.

    And I'm in fr_FR.windows-1252 (fr_FR) mode.

    But, I'm very confused because now this is working.

    I've spent one hour the other day trying to make it work, and did not change anything since.

    Anyway, thank you.






    #SPSSStatistics
    #Support
    #SupportMigration


  • 4.  RE: Spssinc modify tables : regex not working

    Posted Thu March 17, 2022 07:25 PM

    I tracked down that error message to one of the Python library modules, but I have no idea why it would have been triggered, since the function that uses that module does not have any locale calls in it. If you get it again, I would like to see the details.






    #SPSSStatistics
    #Support
    #SupportMigration


Related Content