Name Cleansing

Hello,

I have the below sample dataset for company names. My objective is to get rid of the 2/3/4 letter words from the names, except the first word AMD (it can't be removed). Second, I need to have only two words in the name column. For example, the 4th name AMD CENTER AT TYSONS CORNER would only have AMD CENTER. Please share your thoughts.

AMD
AMD AMDS CO DDC LA
AMD C O CDS PROJECTS
AMD CENTER AT TYSONS CORNER
AMD CO CD
AMD CO CDS
AMD CO CDS PROJECTS
AMD CO DDC LA
AMD CO DEPENDABLE CO
AMD INC
AMD CO DEPENDABLE DIST CENT
AMD CO DEPENDABLE DISTRI CTR
AMD INC CO CDS SHOP
AMD INCCO CDS

Datasets

Text Mining

Accepted answers

pedrodrfaria

Hi @spencer046

Please see attached for the workflow below as the solution:

Using the logic you mentioned. It leaves us with some fields only containing AMD.

You can use a filter and filter out these fields with only AMD.

Additionally, it should be asked, what is the logic to leave only 2 words? Would it be the first two words of the text? This was the logic I used.

Please mark it as a solution for your discussion post if this post answers your question.

Pedro.

Word Parsing.yxmd

All comments

mbarone

Have you tried the text-to-columns tool using a space as a delimiter? I'm not 100% clear on your requirements, but it seems that would be a good place to start.

pedrodrfaria

Hi @spencer046

Please see attached for the workflow below as the solution:

Using the logic you mentioned. It leaves us with some fields only containing AMD.

You can use a filter and filter out these fields with only AMD.

Additionally, it should be asked, what is the logic to leave only 2 words? Would it be the first two words of the text? This was the logic I used.

Please mark it as a solution for your discussion post if this post answers your question.

Pedro.

Word Parsing.yxmd

jalizmaldonado

Hi, I hope all is well.

I'm not very experienced yet but I believe you can add the formula tool and create a conditional statement that removed all language outside of AMD. Then use the Data Cleansing Tool to remove any whitespace. Then join any additional language through another Formula tool. If you have a a data set you can share, I can try to complete it on my end.

Best,

Jaliz Maldonado

jalizmaldonado

Conditional statements include "ToString" when combining and "Replace" when removing.

spencer046

@pedrodrfaria thanks a lot, this is exactly what I am looking for.

why the filter tool filters out the sole AMD names?

The reason for keeping two words is to maintain simplified version of names in a comparatively larger dataset.

spencer046

@pedrodrfaria for the next phase, I have another issue. The solution works only for a particular beginning AMD. Now I have the below dataset:

AMD CO DIST CENTER

Bi Tech Industries

CZ INDUSTRIES

D I S COMPANY LTD

A AND B HOMES CO

I still want to get rid of the 2/3/4 letter words from the names, leaving the first part of the names out of the filter/formula. For example, D I S COMPANY LTD would need to become D I S COMPANY, and A AND B HOMES CO need to become A AND B HOMES.