Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Separating multiple data entries in field

Topic Labels: Automations Data Formulas Views
856 3
cancel
Showing results for 
Search instead for 
Did you mean: 
mrpeanutman
4 - Data Explorer
4 - Data Explorer

Screenshot 2024-02-26 164505.png

Hey,

I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!

3 Replies 3
Dan_Montoya
Community Manager
Community Manager

try converting the field to multi-select field.

Dan_Montoya
Community Manager
Community Manager

you may have to convert the ; to , first.  Remember, you can always "undo" if the conversion doesn't do what you wanted or restore a snapshot.

 

Try this:
1. Create a new formula field with this formula:

 

SUBSTITUTE(
  {Refresh},
  ';',
  ','
)

 

 2. It should now look like this:

Screenshot 2024-02-27 at 10.04.08 AM.png

3. Edit the new formula field and convert it to a multiple select field.  It should now look like this:

Screenshot 2024-02-27 at 10.04.40 AM.png