Formula to identify Encrypted User first/User Last Name

[rmorello]

Can anyone help with the formula to find encrypted User names?

Thanks in advanced.

 

[RoryA]

Welcome to the forum.

I have no idea what you mean by that - could you clarify (bearing in mind forum rule #6)?

 

[rmorello]

Welcome to the forum.

I have no idea what you mean by that - could you clarify (bearing in mind forum rule #6)?

Hi Rory,

I have a long list of users and I need to identify those which have an encrypted User first name and User last name.

Example : User First Name should read "John" User last name should read "Smith"
User first name shows as "yehnjm User Last name shows "gmyqswo
I need to idenfify those which have scrambled names

 

[RoryA]

Do you have a list of valid user names to compare to?

 

[rmorello]

I have a large file which contains users which are decrypted successfully.
In that same file I have several users where the conversion failed and I need to identify all of those which failed.
The file contains more than 400,000 lines, hence why I need a better way to identify those which failed to convert.

 

[felixstraube]

Do you know how they are encrypted/decrypted?

 

[rmorello]

Do you know how they are encrypted/decrypted?

We have a team who uses a conversion tool to decrypt.

 

[felixstraube]

I mean what encryption algorithm is used.
Anyway, you could use some AI to identify the names

 

[Peter_SSs]

You are not giving us any logic to determine whether a value is decrypted successfully or not.
For example, for the values shown in the image in post #5, which values have been decrypted successfully and which have not and how do we determine that?

 

[felixstraube]

Here is one option I could think of. Even though I used google sheets to accomplish it.
In google sheets you install this addon
AI in Sheets™ | Flowshot - Google Workspace Marketplace
then if you have your list of names like this in column A:

you use this formula and copy down:

=AI("is this a known name (please answer with yes or no)?:"&A2)

probably you need to replace the semicolons with comas for it to work for you.

Maybe there is an equivalent for excel, I don't know. But if you don't find another solution this might help you.

You could reduce the number of queries grouping some names together like this:

and the AI query something like this:

=AI("please tell me if this list (separated by ';') of words are known names or not in a sequence of yes and no with the same size as the input array:"&D2)

I don't think that would work with one query for you 400 thousand names but you could try in chunks of 100 maybe?