Partial text match and display between columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2833922%22%20slang%3D%22en-US%22%3EPartial%20text%20match%20and%20display%20between%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2833922%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20find%20partial%20text%20matches%20and%20display%20them%20in%20a%20new%20column%3F%20If%20%22column%22%20was%20an%20entry%20in%20the%20first%20column%20and%20%22alumni%22%20was%20an%20entry%20in%20the%20second%2C%20the%20partial%20match%20would%20be%20%22lumn%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20find%20partial%20matches%20in%20one%20column%2C%20and%20exact%20matches%20in%20one.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2833922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2834479%22%20slang%3D%22en-US%22%3ERe%3A%20Partial%20text%20match%20and%20display%20between%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2834479%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1182005%22%20target%3D%22_blank%22%3E%40trelgor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suspect%20that%20what%20you're%20asking%20may%20well%20be%20possible%20via%20some%20elaborate%20VBA%20routine--and%20I'd%20not%20be%20the%20person%20to%20write%20that--but%20whoever%20might%20would%20surely%20need%20to%20see%20more%20definition%20of%20what%20you're%20seeking%20first.%20Exact%20matches%20(whole%20field%20with%20whole%20field)%20are%20easy.%20%3CEM%3EIt's%20the%20partial%20matches%20that%20need%20some%20clarification%3C%2FEM%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EFor%20starters%2C%20%3CU%3E%3CSTRONG%3Ewhat%20minimum%20or%20maximum%20length%20of%20character%20strings%20would%20qualify%3F%3C%2FSTRONG%3E%3C%2FU%3E%20You're%20surely%20looking%20for%20at%20least%20two%20characters%2C%20since%20shorter%20strings%20would%20hardly%20be%20meaningful.%20But%20I'd%20think%20even%20longer%20than%20two.%20So%20what%20would%20be%20a%20useful%20minimum%3F%20What%20would%20be%20a%20realistic%20maximum%3F%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EWhat%20will%20be%20the%20nature%20of%20the%20fields%20being%20compared%3F%3C%2FSTRONG%3E%20Full%20sentences%3F%20Single%20words%3F%20Phrases%3F%3C%2FLI%3E%3CLI%3EAnd%20if%20I%20can%20ask%20this%20without%20sounding%20impertinent%3A%20%3CU%3E%3CSTRONG%3Ewhat%20is%20the%20actual%20bigger%20purpose%20served%3F%3C%2FSTRONG%3E%3C%2FU%3E%20What's%20the%20context%20or%20purpose%20to%20which%20the%20successful%20completion%20of%20this%20task%20will%20contribute%3F%20%26nbsp%3BIt's%20an%20important%20question%20because%20there%20might%20conceivably%20be%20a%20different%20way%20to%20accomplish%20that%20larger%20task%2C%20so%20it%20would%20be%20helpful%20to%20know%20that%20bigger%20picture.%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Is there a way to find partial text matches and display them in a new column? If "column" was an entry in the first column and "alumni" was an entry in the second, the partial match would be "lumn".

 

I would like to find partial matches in one column, and exact matches in one. 

1 Reply

@trelgor 

 

I suspect that what you're asking may well be possible via some elaborate VBA routine--and I'd not be the person to write that--but whoever might would surely need to see more definition of what you're seeking first. Exact matches (whole field with whole field) are easy. It's the partial matches that need some clarification.

 

  1. For starters, what minimum or maximum length of character strings would qualify? You're surely looking for at least two characters, since shorter strings would hardly be meaningful. But I'd think even longer than two. So what would be a useful minimum? What would be a realistic maximum?
  2. What will be the nature of the fields being compared? Full sentences? Single words? Phrases?
  3. And if I can ask this without sounding impertinent: what is the actual bigger purpose served? What's the context or purpose to which the successful completion of this task will contribute?  It's an important question because there might conceivably be a different way to accomplish that larger task, so it would be helpful to know that bigger picture.