DEV Community

rslt19
rslt19

Posted on

Parsing unstructured text without code?

Hi there,

I have a table of unstructured text in the form of brand names. Some cells are clean and others are mushed together (see below).

Is there a simple way for me to parse this text without code (not a current skill)? The end result I need is a count of mentions per brand.

LuluLemon
Nike, Adidas, Champion, Puma, Outdoor Voices, Gaiam, Fila, Fabletics, Under Armor
"Outdoor voices
Alo
Lu lu lemon
Nike
Adidas
Athleta
SDSU
Girlfriend collective
Puma

Discussion (3)

Collapse
tovare profile image
tovare

Seems like you could get one brand for each line by replacing the comma with a newline. Then maybe remove the " and any other symbols you see. A number of tools will allow you to count occurrences of each brand for example sort | uniq -c

Collapse
shiftyp profile image
Ryan Lynch (he/him)

I don't know of a platform that would allow you to do this without code in a flexible way. I googled "unique word counter online" and found some promising links that look to do a similar task to what you are describing. You might try manually adapting the input or output to one of these to get a result you like. Best of luck! πŸ”°

Collapse
mateuszjarzyna profile image
Mateusz Jarzyna

It’s look like csv file, which can be opened by the excel