Pull Specific Data from a Column into another

Platform discussions Special workflows & use cases
, , , , ,
1

Hello,
I am wondering if this is possible.
We have to import a spreadsheet of orders every week. In that spread sheet is a column called “Products” and each product has a code associated with it. The way that woocommerce exports the data looks like this (CODE) Description of product. If a customer buys multiple products it does this in the same column. I am wondering if there is a way in another column to only pull the info in the paranthesis

2

Hi @aza.rose
You could create a formula (via the formula field) which would extract the data in between the parenthesis.

3

Hello @Harsh !

Removing the parenthesis with a formula like @Harsh said is an excellent idea!

For Excel you can use this formula :

=SUBSTITUTE(SUBSTITUTE(A1, "(", ""), ")", "")

Let me know if you need any additional help!

Best,
Giannis, Implementation Consultant at thespelas.com

4

Thank you- but the next question is in a separate column can I have it list all the items in parentheses? The main issue we are running into is that some people have multiple () in their order and we need to track that

5

That might be a little trickier, I will look into it and let you know.

6

@aza.rose
Yes, it is possible to extract the information within the parentheses from the “Products” column in the spreadsheet using Monday.com.

Assuming you have a column named “Products” with data like “(CODE) Description of product” or “(CODE1) Description1, (CODE2) Description2” and you want to extract the information within the parentheses (i.e., “CODE” or “CODE1, CODE2”), you can follow these steps:

  1. Create a new column (formula column), for example, “Extracted Code(s).”
  2. Customize the new column with these code : MID({Products}, FIND(“(”, {Products}) + 1, FIND(“)”, {Products}) - FIND(“(”, {Products}) - 1)

For further implementation details kindly connect us:
MSquare Support
Visit us here
Youtube Channel