1951c341-e12e-4bc9-a5fc-0f47d79273de.JPG

Novigo Solutions is an end-to-end IT Solutions provider, specialized in full cycle IT Services and platform solutions

SOFTWARE ENGINEER

e6653b86-6191-494c-b705-57f8d49ea57c.png

This Snippet requires the following five arguments:

  

1\. in\_FilePath (String): The Input Excel File Path. **Required**

2\. in\_SheetName (String): The Sheet Name that needs to be read. **Required**

3\. in\_NewColumnNames (String\[\]): The New Column Names that need to be replaced with the Old Column Names or Duplicate Names. **Optional**

4\. out\_OutputDatatable (Datatable): The Output Datatable after performing the operation. **Required**

5\. out\_DuplicateColumns (Dictionary(Of String,Int)): The Duplicate Column Name as the Key, the number of Dplicates as the Value. **Optional**

This Snippet provides the feature of reading an Excel file with duplicate headers and renaming it with user specified header names

54117f40-be35-4a23-881f-08f14d2c1e63.png

This Snippet requires five arguments to be supplied:

  

**1\. in\_ArrayOfElements (Object \[\]):** The Array of Values to find the element which has the maximum occurrence. **Required.**

**2\. in\_Value (Object):** The element whose number of occurrences needs to be found. **Optional.**

**3\. out\_MaxOccurredElement (Object):** The element which has the maximum occurrence. **Required.**

**4\. out\_ElementCount (Dictionary(String,Integer)):** Output Dictionary which has each element in the list as a Key, and its number of occurrences as its value. **Required.**

**5\. out\_ValueOccurrence (Integer):** The number of occurrences of the argument **in\_Value** in the list**. Optional.**

This activity is used to find the element which has the highest number of occurrences in a list of elements.

98ef97e9-d598-4711-816a-61ad17186a8c.png

This Snippet requires the following three arguments:

  

Input Arguments:

**1\. in\_SourceFolderPath (String):** The Input folder path where the files are present and need to be segregated into separate folders. **Required.**

**2\. in\_DestinationFolderPath (String):** The destination folder path where the files need to be segregated to different sub folders. **Required.**

**3\. in\_IsOperationCopy (Boolean):** Indicates the operation that needs to be performed. True for Copy operation and False for Move operation. By default the operation is Move. **Optional.**

This Snippet is used to divide/segregate different types of files of present in a folder into separate folders based on their type

This Snippet requires the following three arguments:

  

Input Arguments:

**1\. in\_InputDictionary (Dictionary(Of Object,Object)):** The input argument is the Dictionary which needs to be Converted into a HTML Form in String Format . **Required.**

**2\. in\_FormHeader (String):** This argument is used to provide a Heading to the Form. By Default it has the Heading as ‘FormData’. **Optional.**

  

Output Arguments:

**1\. out\_HtmlForm (String):** This is the output argument which provides the Dictionary key and values as String in HTML Form format. **Required.**

  

**Note :** 

The HTML Form format used is taken from www.w3Schools.com.

This Snippet converts a Dictionary Key Value Data into a HTML Form in a String Format

This Snippet requires the following six arguments:

  

Input Arguments:

  

**1.** **in\_FolderPath (String):** The Folder Path which contains the CSV files that need to be converted. **Optional.**

**2.** **in\_CsvFilePaths (String \[\]):** This Input argument can be used when the CSV files that need to be converted are in different locations. The Array of file paths can be provided. If the **in\_FolderPath** argument is provided then this argument is ignored. **Optional.**

**3.** **in\_SheetName (String):** The sheet name that needs to be provided for the converted output xlsx or xls file. **Optional.**

**4.** **in\_DeleteCsv (Boolean):** This argument specifies if the original CSV files need to be deleted or not. **Optiona**l.

**5.** **in\_Extension (String):** This argument specifies the file format needed. It can either be xlsx or xls. **Required.**

**6.** **in\_OutputFolderPath (String):** This argument specifies the folder path where the Converted Output xlsx or xls files needs to be created**. Required.**

  

Note:

The **in\_Extension** argument should be either xls or xlsx. If other extensions are provided, then the output file might be Invalid.

This Snippet is used to convert CSV files into Xlsx or Xls

**Automated Customer Complaint Ticket Generation** Process makes the employee's job of data entry into multiple CRM systems faster and has an improved quality.

  

The process helps to fetch the previous complaint details of the given customer ID.

  

The employee can input the details to solve the complaint as to what is the solution recommended and as to the time it takes to solve it.

  

The employees can also edit or update the changes made with confirmation messages, so as to confirm the change of data.

  

The Error Handling is also ensured when the user enters an irrelevant data that cannot be processed.

The Process takes input from the user and updates the data into an Excel sheet (database) and Google forms, and sends a confirmation mail to the user

This Snippet requires the following six arguments:

  

Input Arguments:

  

**1.** **in\_String (String):** The input string value that needs to be provided to perform the regex string replacement. **Required**

**2.** **in\_Pattern (String):** The Regex pattern that is used to match the required elements in the input string argument that needs to be replaced. **Required**

**3.** **in\_ReplacementString (String):** The replacement string that needs to be put in place of the pattern matched in the input String. By default the value is Empty String. **Optional**

**4.** **in\_OccurrencesToReplace (String):** This is a numeric value that should be in the form of a String indicating the number of occurrences of the matched regex pattern that needs to be replaced. By default it takes all the numbers of matched occurrences. **Optional**

**5.** **in\_RightToLeft (Boolean):** This is a boolean value indicating the direction of the replacement. By default the value is False**. Optional**

  

Output Arguments:

**1.** **out\_String (String):** The output string after the regex string replacement operation. **Required.**

This Snippet helps to replace a pattern in a string for a required number of times, or only the first occurrence or the last occurrence or all the occurrences needed

About me