Automator Rename File

Here are some clarification questions:

1. Files are in a folder, and not in sub-folders of that folder? Yes, or no?
2. Filenames are always Last First.ext? If not, what other format, and how should it be renamed.
3. Are there formats where there are multiple spaces in the filename? Yes, or no?

I have an AppleScript that right now, renames as you originally requested. Want answeres to the preceding questions before I post it here.

Before:

After:

Got tired of waiting for an answer. The following AppleScript will prompt for a folder containing the files to rename. As written, it does not descend into sub-directories. Results shown in previous post.

Launch the Script Editor from Dock : Launchpad : Other. Copy/paste the following code into the Script Editor, click the compile (hammer) icon, and then click the Run button. You can save this script on your Desktop as .scpt, .scptd (script bundle), or .app — where it will run after a double-click on it.

use framework "Foundation"
use AppleScript version "2.4" -- requires Yosemite 10.10 or later
use scripting additions

property NSString : a reference to current application's NSString

set sfolder to (choose folder default location (path to desktop))

tell application "Finder"
	-- non-recursive, gets just files in the main folder location
	set fileLst to (every file of folder sfolder) as alias list
	
	if fileLst = {} then return
	
	repeat with afile in fileLst
		set afile's name to my upperCase(afile's name as text)
	end repeat
	set fileLst to {}
end tell
return

on upperCase(astr)
	-- split the passed name string into array elements, make the first element (last name) uppercase, and
	-- return reassembled filename string
	set mu_array to ((NSString's stringWithString:astr)'s componentsSeparatedByString:" ")'s mutableCopy()
	mu_array's replaceObjectAtIndex:0 withObject:((mu_array's firstObject())'s localizedUppercaseString())
	return (mu_array's componentsJoinedByString:" ") as text
end upperCase

Your best bet is to use "A better rename Finder 11.10" services app. You can find it at https://download-mac-apps.net/2020/01/a-better-finder-rename-11-10-2020-for-mac/

What OS version are you running Automator on?

I can't get it to work any more.