How can I import a list that may contain "blank" data and have the field updated to be blank even if it already has text in it? | Community
Skip to main content
Danielle_Wong
Danielle_Wong
Community Manager
Oct 12, 2017 4:08 PM UTC
Solved

How can I import a list that may contain "blank" data and have the field updated to be blank even if it already has text in it?

For example, say I wanted to clear out some fields that were imported incorrectly for some of my contacts. Is there a way to clear that field out for these contacts? If so, how?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Loren_Posendek
Loren_PosendekAccepted solution
Level 4
Oct 12, 2017 4:25 PM UTC

Hi Danielle, you should be able to accomplish this by typing 'NULL' in the cell for values that you'd like to be blank. I'd test it to be sure, as some fields may have updates blocked upon import.

Another option is to pull a smart list using the email address filter. Copy and paste all email addresses from the list, then manually NULL out the fields.

View reply

2 replies

Loren_Posendek
Loren_PosendekAccepted solution
Level 4
Oct 12, 2017 4:25 PM UTC

Hi Danielle, you should be able to accomplish this by typing 'NULL' in the cell for values that you'd like to be blank. I'd test it to be sure, as some fields may have updates blocked upon import.

Another option is to pull a smart list using the email address filter. Copy and paste all email addresses from the list, then manually NULL out the fields.

Translate
Danielle_Wong
Danielle_WongAuthor
Community Manager
Oct 12, 2017 4:45 PM UTC

Hi Loren, this is super helpful. I will try this! thank you

Translate
Terms & ConditionsAccessibility statement

Loading footer...