Hoping someone can help. I've previously used the below script to re-order field values for charts I have to produce and it works fine. However, I now have a field value (Very Often) with a space and whilst the script will reorder the other values, it won't touch this one. I've tried single quotes, double quotes and brackets and none work. Any ideas?
load * Inline [
[Changes to work],
[Challenged by course],
[Prepared for sessions],
[Worked with other students],
[Explained course material],
[Asked another student],
[Prepared with other students],
[Talked about career],
[Worked with teaching staff]
DROP table tmploadorder;
Any help would be much appreciated.
Leading or trailing spaces? Different case? I find it useful to put values in a listbox with an expression like:
='>' & Memorising & '<'
to check for leading/trailing spaces.
Ok, new problem - I can't get the reorder to work with the [Prepared for session] field. I've tried without quotes, with single quotes, double quotes, square brackets and curly brackets with no luck.