I am trying to extract the file of accounts which starts with xx-
What does the query look like. I tried by export operation choosing account object and chose the Name field in the query and Name in the where clause and equals to in operation and XX- in the value. i
In the dataloader you can see the condition on top so add the condition such that name starts with xx so it extracts all the names which begins with xx
One option is of Data Loader as suggested by Venu.
But if you don't have more than 10000 records with that name then you can use this script in system logs :
Thanks
Ankit Arora
Blog | Facebook | Blog Page
All Answers
Extract all the Accounts thats start with xx with data loader and replace it with xxA and upload it back
One option is of Data Loader as suggested by Venu.
But if you don't have more than 10000 records with that name then you can use this script in system logs :
Thanks
Ankit Arora
Blog | Facebook | Blog Page
Thanks.
I am trying to extract the file of accounts which starts with xx-
What does the query look like. I tried by export operation choosing account object and chose the Name field in the query and Name in the where clause and equals to in operation and XX- in the value. i
Pls help
I will try that way and let u know Ankit.
Thx
In the dataloader you can see the condition on top so add the condition such that name starts with xx so it extracts all the names which begins with xx
Ankit
Where should i write this script ? on object or where? I want to do this in production fyi.
I am new to this.
Pls let me know.
You can access the System Log by clicking in upper right dropdown if your an admin.
Click your Name -> System Log.
This will open a popup which allows you to execute anonymous apex ("The Script" provided by Ankit).
Wonderful...Thx a ton.. It worked