RezaKJoi's profile

691 Messages

 • 

9.2K Points

Monday, February 16th, 2026

No Status

0

Sheet file for creating a poll

In the Favorite Film Buff post, we ran into an issue with publishing the poll, so I decided to create this file and share it here in case it’s useful for you as well

-----

In this file, I implemented several features to ensure the text is properly formatted and organized. Specifically, we cleaned the input by removing any non-ASCII characters and unnecessary spaces at the beginning and end of each entry. Additionally, we set up automatic sorting mechanisms: one column organizes entries based on the year mentioned in the text, and another sorts entries alphabetically. These steps were designed to maintain consistency, accuracy, and ease of use for anyone entering or reviewing the data.

-----

In this Google Sheets file, the first three columns are designed specifically for review:

  • Column A – Original input text
  • Column B – Cleaned output showing removed non-ASCII characters and trimmed spaces
  • Column C – Flag ⚠ indicating any modifications

All other columns can also be edited or pasted into freely; the cleaning process still works automatically, but no flags are shown there.

Here are three sample words added to the file for demonstration:

Héllo 🌍 Wörld! fi re

In the screenshot, you can see how the first three columns highlight changes, while the rest of the file is automatically cleaned without alerts.

-----

The cleaning process also handles extra spaces in the text:

  • Any leading or trailing spaces in the input are automatically removed.
  • Spaces between words are preserved, so the original meaning and readability remain intact.
  • If a space removal affects a cell in the first three columns (A–C), it is also reflected in the Flag column (C), indicating that a modification occurred.
  • In other columns (D and beyond), extra spaces are removed automatically, but no flag is displayed.

For example, if the input is:

fi re 

  • Column B (Cleaned Output) will show:

fi re

  • Column C (Flag) will show: ⚠

-----

The year extraction feature automatically detects the last four digits in the input text as the production year and sorts the entries accordingly. This allows easy chronological organization even if the year is enclosed in parentheses, brackets, or added after some text.

Here are a few sample entries added to the file:

The Shawshank Redemption 1994

Inception (2010)

The Godfather [1972]

Interstellar 2014

Casablanca 1942 

In the screenshot, you can see that the sorting is applied based on the years detected in these entries.

-----

There is a column (column F) where text is entered, and the sheet automatically sorts the entries alphabetically and shows the sorted list in column G.  These samples are written in the column to demonstrate how the sorting works.

The Shawshank Redemption 1994

Inception (2010)

The Godfather [1972]

Interstellar 2014

Casablanca 1942

-----

"I’ve added the link to this file. You can leave comments on it if anything needs to be corrected or changed, and you can also make a copy of it if you’d like

https://docs.google.com/spreadsheets/d/1U0UUiK42G_hShEQM7f0l3oIsDxB3o39_D33dtNW-ud8/edit?usp=sharing

Oldest First
Selected Oldest First

Champion

 • 

16.2K Messages

 • 

349.1K Points

1 month ago

Although I know someone told you otherwise, the characters é and ö do not cause any problems in polls.

Some punctuation and non-Western characters cause errors. I don't have a full overview.

11.7K Messages

 • 

196.7K Points

@Peter_pbn​ 

ASCII is an old character encoding system from the 1960s. It includes only 128 characters: the letters A-Z, numbers 0-9, some punctuation, and a few control symbols. Anything outside this set - like accented letters such as é or ö - is not part of plain ASCII. Instead, these letters belong to extended character sets, like ISO-8859-1, or to Unicode, which can represent thousands of characters from languages all over the world.

Even though é and ö are based on the letters e and o, they include accent marks or diacritics that make them visually distinct. In Unicode, the same character can still be encoded in different ways. For example, é can exist as a single Unicode character or as a combination of the plain letter e plus an acute accent (e + ´). Both forms look the same on screen, but the computer treats them as different codes. ASCII, by contrast, only knows the plain e and cannot represent the accent. The same applies to ö, which can be a single character or a combination of o plus a diaeresis (o + ¨).

A simple way to understand this is to think of a picture saved in two different formats, like JPEG and PNG. The image looks identical, but the files are different. Similarly, characters like é may look like a modified e, but they are encoded differently in the computer. Plain ASCII cannot represent these accented letters, while Unicode can store them in multiple ways. That is why accented letters usually work fine in polls, while some other punctuation or non-Western characters can sometimes cause errors.

The forum seems to take it. In that text up there is unicode as well as ASCII, but it wouldn't work for polls, which was no problem, in earlier times. I used Unicode before in polls. It worked fine. Now not.

P.S.: Just in countries where é and ö are normal keys on the keyboard, it seems to automatically take the ASCII-characters for. I guess so, because é and ö also wörk at my keyboard and the polls well.

(edited)

691 Messages

 • 

9.2K Points

@Peter_pbn​ That's why I put an autocorrect and flag to make it clear, and so that if someone doesn't want to change it, I'll probably update the file to edit it in a different way that's appropriate for the site.

11.7K Messages

 • 

196.7K Points

1 month ago

@RezaKJoi:

 That seems to be a touch challenge to change the characters word by word, or can it be automatized with that Google-function? I put the whole block into chatgpt and let it correct.

(edited)

691 Messages

 • 

9.2K Points

@Breumaster​ I think it could be done by writing a script, but what command do you give to Chat GPT to make those changes? I need a format or a command or something like ASCII so that the changes are done automatically and all at once.

11.7K Messages

 • 

196.7K Points

@RezaKJoi​ 

I make it like that: 

  1. I write this line: Please test only for ASCII compliance (please don’t pay attention to “Added,” the dates, or title-lines like “1. Robert Duvall”, only the actual texts):
  2. I copy and paste all options under it and let it go

P.S.: Please note: You can put the text under it by press Shift and Enter together. So you avoid a premature input of the order without the options copied under it.

(edited)

11.7K Messages

 • 

196.7K Points

@RezaKJoi​ 

Indeed I wanted to show you by copy and paste it in the posting above to visualize it and make it understandable, but the dumb forum always crops my texts, so it comes in one block, which really doesn't look understandable at all, afterwards. I set the mouse-pointer closely left to the first option, do a left click, hold it and pull down the marking to the last option. Then I do a right click on the marked options and copy them and paste them under the command-line I gave chat-gpt. You can also tell chatgpt in the commanding line to instantly correct the options when it finds any non-ASCII-characters. 

The sad thing is that this all wouldn't be needed, if the wesite would take also other than ASCII-codes with extensions, which are from the 1960s. I don't know why they have made it like that. I can only guess. Security, maybe? I don't know if the allowance of other codes may contain backdoors for attackers. My knowledge is far too less for saying why this happens. Maybe it has other reasons I even wouldn't understand. ;)

(edited)

691 Messages

 • 

9.2K Points

@BreumasterThanks for your explanation. So you also use ASCII

691 Messages

 • 

9.2K Points

@Breumaster​ Thank you for the complete information you provided. Sometimes things get complicated and don't need to be. I'm a bit short on time, but I'd like to design that file sheet in a way that will eliminate the hassle once and for all.

Champion

 • 

8.6K Messages

 • 

206.7K Points

1 month ago

Wow, thank you, Reza. I haven't yet had an opportunity to read it (you just posted it 25 minutes ago) and I'm not too technically savvy anyway but it looks like you put your observations to good use and it was really nice of you to share it. I've certainly run into those sorts of errors so I look forward to looking it over as soon as I have the chance. 

691 Messages

 • 

9.2K Points

@rubyfruit76​ Thank you for your comment, I hope you find it useful after reading the text, but I published that post earlier but it was private and later it was opened twice, I plan to gradually make this file much more efficient, so that I can copy it from the original site, read specific data, etc. to make it easier to create a poll.