by Variance InfoTech Pvt Ltd

The Find and Replace extension enables you to find a specific word and replace it with a different word all from the list view. Run the replace against one record or as many as you would like. No longer do you need to slowly go from record to record to make wholesale changes.

Free 30 day trial
Try it Now

User Guide

Steps For Using Find And Replace Features :

Step 1:

To open the Administration Page, Click on the Admin tab as shown in below screenshot.

1.png

Step 2:

Open Administration page & Click on the Find And Replace from the Other Section.

2.png

Step 3:

In the Find And Replace Configuration page, check Enable Find And Replace Checkbox(Click on OK button from Alert).

3.png

4.png

Step 4:

Open Listview of Accounts Module → check the checkbox to select the record (or Multiple Records) → click on BULK ACTION button → click on FIND AND REPLACE as shown in the below screenshot.

5.png

Step 5:

Popup window will be open → fill all the values as shown in the below screenshot. After filling all required fields, Click on the SAVE button.

If Search Type is “Normal” :

6.png

If Add Replace Method is Disable/Unchecked :

  • If Field Type is “TextField, Textarea or Phone” : If Select Find Method is “Match Exact Word” then it will find the exact word and replace it with the Replace With value in the selected record.

7.png

Step 6:

If the record contains the word mentioned in the “Find What” text box then it will be replaced with the value mentioned in the “Replace With” text box and shows an alert message as shown in the below screenshot. After that Click on OK Button.

8.png

Step 7:

See in the Accounts Module before Updating “Name”, It was saved as “Herry”.

9.png

Step 8:

After using the Find And Replace feature, “Name” value is updated to “Allen” as shown in the Listview of Accounts Module as shown in the below screenshot.

10.png

Step 9:

If you want to save your search then use the “Save as Template” feature. Check “Save as Template” Checkbox and you are able to see the “Name of the Template” textbox in which you can add the name of template which you want to give and click on the Save Button.

11.png

12.png

If you want to use Saved Template then Select Template from Dropdown and it’ll auto fill all the details of Selected Template as you shown in the screenshot below.

13.png

14.png

If You want to Delete a Saved Template then Click on Delete Icon as shown in the below screenshot.

15.png

16.png

Step 10:

If the record doesn’t contain the word mentioned in the Find textbox then alert message showing “No Record Found“ as shown in the below screenshot.

17.png

18.png

(Note: If you select Find Method as “Contains” then it will find the word in string which you have mentioned in the “Find What” and replace that particular word from string to update the record.)

19.png

Step 11:

If the record contains the word mentioned in the “Find What” text box then it will be replaced with the value contained in the “Replace With” text box and shows an alert message as shown in the below screenshot. After that Click on OK Button.

20.png

Step 12:

See in the Accounts Module before Updating “Office Phone”. It was saved as “+49 152 901820 and +49 30 901820 ”.

21.png

Step 13:

After using the Find And Replace feature, “Office Phone” value is updated to “+49 152 902022 and +49 30 902022 ” as shown in the Listview of Accounts Module as shown in the below screenshot.

22.png

  • If Field Type is “Date, Datetime or Datetime Combo” :

23.png

Step 14:

If the record contains the word mentioned in the “Find What” text box then it will be replaced with the value contained in the “Replace With” text box and shows an alert message as shown in the below screenshot. After that Click on OK Button.

24.png

Step 15:

See in the Accounts Module before Updating “Valid Until”. It was saved as “08/18/2020”.

25.png

Step 16:

After using the Find And Replace feature, “Valid Until” value is updated to “08/20/2020” as shown in the Listview of Accounts Module as shown in the below screenshot.

26.png

If Add Replace Method is Enabled/Checked :

Replace Method : Field Prefix

(Note: If you select Find Method as “Match Exact Word” then it will find the exact word and replace it with the Replace With value in the selected record)

27.png

Step 17:

If the record contains the word mentioned in the “Find What” text box then it will be replaced with the value mentioned in the “Replace With” text box and shows an alert message as shown in the below screenshot. After that Click on OK Button.

28.png

Step 18:

See in the Accounts Module before Updating “Name”, It was saved as “Smith”.

29.png

Step 19:

After using the Find And Replace feature, “Name” value is updated to “DenialSmith” as shown in the Listview of Accounts Module as shown in the below screenshot.

30.png

Step 20:

If you want to save your search then use the “Save as Template” feature. Check “Save as Template” Checkbox and you are able to see the “Name of the Template” textbox in which you can add the name of template which you want to give and click on the Save Button.

31.png

32.png

If you want to use Saved Template then Select Template from Dropdown and it’ll auto fill all the details of Selected Template as you shown in the screenshot below.

33.png

34.png

If You want to Delete a Saved Template then Click on Delete Icon as shown in the below screenshot.

35.png

36.png

Step 21:

If the record doesn’t contain the mentioned word in the Find textbox then alert message showing “No Record Found” as shown in the below screenshot.

37.png

38.png

(Note: If you select Find Method is “Contains” then it will find the word in the field value which you have mentioned in the “Find What” Textbox)

39.png

Step 22:

If the record contains the word mentioned in the “Find What” text box then it will be replaced with the value mentioned in the “Replace With” text box and shows an alert message as shown in the below screenshot. After that Click on OK Button.

40.png

Step 23:

See in the Accounts Module before Updating “Name”, It was saved as “Herry”.

41.png

Step 24:

After using the Find And Replace feature, “Name” value is updated to “AllenHerry” as shown in the Listview of Accounts Module as shown in the below screenshot.

42.png

Replace Method : Field Suffix

43.png

Step 25:

If the record contains the word mentioned in the “Find What” text box then it will be replaced with the value mentioned in the “Replace With” text box and shows an alert message as shown in the below screenshot. After that Click on OK Button.

44.png

Step 26:

See in the Accounts Module before Updating “Name”. It was saved as “John”.

45.png

Step 27:

After using the Find And Replace feature, “Name” value is updated to “JohnPeter” as shown in the Listview of Accounts Module as shown in the below screenshot.

46.png

Replace Method : Concat Multiple Fields

47.png

Step 28:

If the record contains the word mentioned in the “Find What” text box then it will be replaced with the value mentioned in the “Replace With” text box and shows an alert message as shown in the below screenshot. After that Click on OK Button.

48.png

Step 29:

See in the Accounts Module before Updating “Billing City”. It was saved as “Denmark”.

49.png

Step 30:

After using the Find And Replace feature, “Billing City” value is updated to “DenmarkGermany” as shown in the Listview of Accounts Module as shown in the below screenshot.

50.png

Replace Method : Mathematical Operation

51.png

Step 31:

If the record contains the word mentioned in the “Find What” text box then it will be replaced with the value mentioned in the “Replace With” text box and shows an alert message as shown in the below screenshot. After that Click on OK Button.

52.png

Step 32:

See in the Quotes Module before Updating “Grand Total”. It was saved as “100”.

53.png

Step 33:

After using the Find And Replace feature, “Grand Total” value is updated to “180” as shown in the Listview of Quotes Module as shown in the below screenshot.

54.png

Replace Method : Date Operation

55.png

Step 34:

If the record contains the Date mentioned in the “Find What” text box then it will be replaced with the Date mentioned in the “Replace With” text box and shows an alert message as shown in the below screenshot. After that Click on OK Button.

56.png

Step 35:

See in the Quotes Module before Updating “Valid Until”. It was saved as “08/20/2020”.

57.png

Step 36:

After using the Find And Replace feature, “Valid Until” value is updated to “08/22/2020” as shown in the Listview of Quotes Module as shown in the below screenshot.

58.png

If Search Type is “Regular Expression” :

  • If Field Type is “Date, Datetime or Datetime Combo” :

    • Select Select Search Type as “Regular Expression”.
    • Add Regular Expression for finding particular Date in “Find What” Textbox.
    • Add Regular Expression for Replace particular Date in “Replace With” Textbox.
    • Add Regular Expression for Replace particular Date Value in “Replace Value” Textbox.
  • Regular Expression Example :

    • For Replace Day : Find What = /\d{4}-\d{2}-12/ Replace With = /(\d+)-(\d+)-(\d+)/ Replace Value = ${1}-${2}-20

    • For Replace Month : Find What = /\d{4}-07-\d{2}/ Replace With = /(\d+)-(\d+)-(\d+)/ Replace Value = ${1}-08-${3}

    • For Replace Year : Find What = /2019-\d{2}-\d{2}/ Replace With = /(\d+)-(\d+)-(\d+)/ Replace Value = 2020-${2}-${3}

59.png

Step 37:

If the record contains the mentioned Regular Expression for Date in the “Find What” text box then it will be replaced with the value contained in the “Replace Value” text box using “Replace With” Regular Expression and shows an alert message as shown in the below screenshot. After that Click on OK Button.

60.png

Step 38:

See in the Quotes Module before Updating “Valid Until”, It was saved as “08/22/2020”.

61.png

Step 39:

After using the Find And Replace feature, “Valid Until” value is updated to “08/14/2020” as shown in the Listview of Quotes Module as shown in the below screenshot.

62.png

  • If Field Type is “TextField, Textarea or Phone” :

    • Select Search Type as “Regular Expression”.
    • Add Regular Expression for finding particular Word in “Find What” Textbox.
    • Add Replace Value in “Replace With” Textbox.
  • Regular Expression Example : Find What = /Jhon/ Replace With = James

63.png

Step 40:

If the record contains the Word which is mentioned in the Regular Expression for the “Find What” text box then it will be replaced with the value contained in the “Replace Value” text box and shows an alert message as shown in the below screenshot. After that Click on OK Button.

64.png

Step 41:

See in the Quotes Module before Updating “Title”, It was saved as “Allen”.

65.png

Step 42:

After using the Find And Replace feature, “Title” value is updated to “Peter” as shown in the Listview of Quotes Module as shown in the below screenshot.

66.png

Saving Comment Saving Comment...