While SPSS has many strengths, string manipulation is NOT one of them! Don’t get me wrong, you can manipulate strings however the syntax for doing so is very complex.
If you are still using an older version of SPSS, this macro shows how you can easily remove character(s) from a string both anywhere in the string or at a certain location. Newer versions have a Replace command which can be used to remove unwanted characters.
Video demonstrating SPSS macro to remove characters from strings
I don’t know who set up the default toolbars but they clearly don’t work much in the “real world”!
The vast majority of work I do in SPSS is writing syntax however, having a frequency button or a button that empty’s the output screen is a lifesaver! Unfortunately most people don’t take the time to customize their toolbars.
This shows how easy it is to add – delete buttons from the toolbars. While the video shows the process on version 13 of SPSS, the same process works on newer versions.
Video demonstrating how to Customize SPSS Toolbar buttons
You wouldn’t think that exporting contacts from an online CRM would be difficult however when I went to export ZOHO contacts, it sure went out of their way to! I also found trying to update them (via the web interface) time consuming and frustrating. I wrote an API call that automated the exporting of contacts from my account.
The below video documents how the API call automated my export ZOHOcontacts and then builds a hyperlink which allows me to easily link back to an individual record. API / Web services are similar to but different than web scraping in that the API call allows you to be very specific with your query and doesn’t return all the HTML content (which greatly increases the size of the payload)
Export ZOHO contacts
You might find this Kindle book interesting if you’re migrating your database to the cloud.