+ Start a Discussion
Rich13Rich13 

Contains in Data Loader

Hi,

 

How to use Contains in Data Loader. I would like to export Task records with text field "Subject" contains "ABC" . But Data loader filter doesn't have the Contains operator as it is in the SFDC reports.

 

Please help.

 

Thank you

Subhani PSubhani P

Hi,

 

We don't have that option for Tasks to use the contains option to extract the records through dataloader. But you can create a formula field(Text type) by giving in the list. After that when you're using the Data loader, use the custom field for extracting data into CSV file.

 

 

If this post is helpful please throw Kudos.If this post solves your problem kindly mark it as solution.

Thanks,
Subhani,
Salesforce Certified Developer,
www.mydbsync.com.

vbsvbs
@Rich13 - Data loader uses SOQL queries to export the data. Why not use the LIKE operator in your export SOQL and add a filter:
Subject LIKE '%ABC%'
nbknbk

Hello,

 

Can you use LIKE operator to retreive the details.

select id,name from objectname where name like '%ABC%'

 

Thanks,

Krishna

Ashish_SFDCAshish_SFDC

Hi Vbs, 

 

It does not show up in the Operator field you can type contains and the value in the value box ( say click on add button), you will see the query and that will also give you your result.

 

Regards,

Ashish 

Nicolas VUILLAMY 14Nicolas VUILLAMY 14
You can now use SFDX Data Loader plugin to do that, by defining a list of words in a JSON file :)
Tutorial here : https://nicolas.vuillamy.fr/how-to-detect-bad-words-in-salesforce-records-using-sfdx-data-loader-and-sfdx-hardis-171db40a9bac