# Changes and errors on toUpper and toLower functions **URL:** \ **Category:** Q&A\ **Tags:** error, calculations, dataset, Business-Intelligence-Engineer, formatting, quick-sight\ **Created:** [August 30, 2024, 8:25am UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508 "2024-08-30T08:25:22Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![rodrigolodi](https://avatars.discourse-cdn.com/v4/letter/r/51bf81/32.png) [@rodrigolodi](https://community.amazonquick.com/u/rodrigolodi)\ **Post date:** [August 30, 2024, 8:25am UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508/1 "2024-08-30T08:25:22Z")
Hi everyone, I seem to have a strange error on the simple functions to change the case from lower to upper. It looks like these functions have been modified and cannot be used while having a SPICE dataset, does anyone have the same issue?! 1 - "new’ function doesn’t exist on the documentation ([toUpper - Amazon QuickSight](https://docs.aws.amazon.com/fr_fr/quicksight/latest/user/toUpper-function.html)) 2- Function doesn’t seem to be allowed using SPICE as a calculated field on analysis ![Screenshot 2024-08-30 at 10.21.25](https://d1wl4jav5dp96l.cloudfront.net/original/3X/2/7/2750662bb47f4b76a95be56ec8c6b9f9e5e59d31.png) 3-function doesn’t seem to be allowed on data preparation phase does anyone have the same? ---
**Author:** ![rodrigolodi](https://avatars.discourse-cdn.com/v4/letter/r/51bf81/32.png) [@rodrigolodi](https://community.amazonquick.com/u/rodrigolodi)\ **Post date:** [August 30, 2024, 8:31am UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508/2 "2024-08-30T08:31:40Z")
3-function doesn’t seem to be allowed on data preparation phase ![Screenshot 2024-08-30 at 10.24.38](https://d1wl4jav5dp96l.cloudfront.net/original/3X/4/6/469ac5a109575ed72781ec6398f7aa3ce64cc029.png) ---
**Author:** ![Shahid\_Muhammad](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/shahid_muhammad/32/24673_2.png) [@Shahid\_Muhammad](https://community.amazonquick.com/u/Shahid_Muhammad)\ **Post date:** [August 30, 2024, 9:06am UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508/3 "2024-08-30T09:06:15Z")
Hi You can use these functions for direct query I believe. ---
**Author:** ![rodrigolodi](https://avatars.discourse-cdn.com/v4/letter/r/51bf81/32.png) [@rodrigolodi](https://community.amazonquick.com/u/rodrigolodi)\ **Post date:** [September 9, 2024, 9:25am UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508/4 "2024-09-09T09:25:53Z")
Indeed, but given the size of the dataset and how is built, it wouldn’t perform properly… ---
**Author:** ![Shahid\_Muhammad](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/shahid_muhammad/32/24673_2.png) [@Shahid\_Muhammad](https://community.amazonquick.com/u/Shahid_Muhammad)\ **Post date:** [September 9, 2024, 9:27am UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508/5 "2024-09-09T09:27:18Z")
Hi Yes, that’s the constraint. ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [September 23, 2024, 10:14pm UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508/6 "2024-09-23T22:14:20Z")
Hi @rodrigolodi, It’s been awhile since we last heard from you; checking in to see if you had any additional questions regarding your initial topic? If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic. Thank you! ---
**Author:** ![rodrigolodi](https://avatars.discourse-cdn.com/v4/letter/r/51bf81/32.png) [@rodrigolodi](https://community.amazonquick.com/u/rodrigolodi)\ **Post date:** [September 25, 2024, 7:39am UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508/7 "2024-09-25T07:39:54Z")
Hey Brett, Thanks but I don’t really have an answer here as documentation remains outdated (function is not even the same anymore), so I’m still unsure on why this has changed for SPICE data and what are the possibilities for a workaround. Let me know please if there’s anything you can share! Thanks, ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [September 26, 2024, 9:25pm UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508/8 "2024-09-26T21:25:50Z")
Hi @rodrigolodi, What does the string look like that you’re trying to change? Is it always one word (with a single character that needs to be capitalized or lowecased) or multiple word? Depending on what your string looks like, there could be a potential work around. But additionally, are you able to complete in SQL? That would definitely be the easiest option. ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [October 8, 2024, 7:59pm UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508/9 "2024-10-08T19:59:42Z")
Hi @rodrigolodi, It’s been awhile since we last heard from you; did you have any additional questions? If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic. Thank you! ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [October 14, 2024, 2:38pm UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508/10 "2024-10-14T14:38:22Z")
Hi @rodrigolodi, Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed. Thank you! ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [October 14, 2024, 2:38pm UTC](https://community.amazonquick.com/t/changes-and-errors-on-toupper-and-tolower-functions/34508/11 "2024-10-14T14:38:43Z")