So i have a list of names that i know not a lot of people will not be selecting. I read somewhere that character names will 12 letters or less.
is there a website or a spreadsheet filter(open office is what i have but dont know how to use) that can find all the names that are 12 letters or less. I know i can count the letters but the list is quite long…few hundred at least.
Put each name into google docs, they give you a word counter. Just copy, paste, then see the numbers.
I dont know if it also works in open office, but in excel you can add a column next to the names and do ‘= LEN(A1)’ assuming the names are in column A, then drag it down by clicking the square in the bottom corner of the cell (or just double click it).
if i google doc i still have to do one word at a time…might as well just count them…unless that word count has a select a mass amount of names?
because i did that and it just tells me total of what i selected
See the post by Vitaly above. You can create a simple formula in the second column that gives you the length of the word in the first column. Then you can sort based on the count and cut everything longer than 12. You can probably find this process detailed explicitly in a tutorial on spreadsheet formula somewhere with a simple google search.
If you’re using a good operating system (e.g. UNIX or POSIX based) you don’t need any extra tools.
Make a file with your names, one name per line. I’ll assume the file is called “names”.
for i in $(cat names); do count=$(echo $i | wc -c); echo $i $count; done
it worked in open office…just had to figure out the forumla ‘= LEN(A1)’ minus the ’ and the space after the = sign…showed me exactly what i wanted to see