Duplicates Identified by Limited Matches

[mustufa2019]

I want to create a workflow that will match the first 8 characters (i can change the length of the  character matches)  of  of the "supplier Name" field and the "Supplier Status" field and will create a report showing these matches. Hence, if at least the first 8 characters of these two fields match, flag them. Should i use fuzzy matches for this? see below example input and output of data 

Input (Characters in bold match between the two fields so they will be flagged and in output example)

Supplier Short Name	Supplier Name	Supplier Additional Name	Supplier Status
WOSMITHNAS-001	WOSMITHNASHVILLECOMMUNITYMUSIC	WOSMITHNASHVILLE	A
WOSMITHNAS-001	WOSMITHNASHVILLECOMMUNITYMUSIC	SCHOOL	A
DON KENT T-001	DONKENTTREASURERRIVERSIDECOUNTY	TREASURER	A
DRAMA BOOS-001	DRAMA BOOSTERSCOTHURSTONMIDDLE	SCHOOL	A
DRAWBRIDGE-001	FULTONTAX	FULTONTAXCAPITAL	A
MAYOR'S FU-001	NEWYORK	NEWYORKCITY	A
MEDICAL DE-001	MEDICALDEVELOPMENTSPECIALISTS	CONSULTING	A
MEDICAL DE-001	MEDICAL DEVELOPMENT SPECIALISTS	CONSULTING	A

Output (showing the matches

Supplier Short Name

Supplier Name

Supplier Additional Name

Supplier Status

WOSMITHNAS-001

WOSMITHNASHVILLECOMMUNITYMUSIC

WOSMITHNASHVILLE

A

DRAWBRIDGE-001

FULTONTAX

FULTONTAXCAPITAL

A

DRAWBRIDGE-001

FULTONTAX

FULTONTAXCAPITAL

A

[DavidP · Accepted solution]

Why don't you use the LEFT() function, i.e.

if left([Supplier Name],8) = left([Supplier Additional Name],8) then 'A' else '' endif

[mustufa2019]

@david thank you, this worked