I want to check format of the data

CloverDX Platform
1

Hi,

I have requiremnt that ,i am validating a csv file.i want to validate the format data of the records in the CSV file.i want to check that data should not have any special characters and the double quotes inbetwwen the string data etc.

Kindly reply if you HAVE ANY IDEA…

Thanks and Regards,
Hanuman Mishra

2

Hi,
use can use Reformat or ExtFilter with an expression in the Clover Transformation Language (http://wiki.clovergui.net/doku.php?id=t … ang_syntax). The language has methods which can check the input data.

Jaro

3

Hi,

can you please give me example that how to write a expression to remove speciall characters…

4

Hi,
you can use the replace() function to remove any characters. Example:

$OutputName := replace($InputName, ’ [!@$]', ‘’);

The example would replace all occurences of the “!”, “@”, “$” characters in the input field called “InputName” with an empty string, thus removing them. The output is stored in the output field called “OutputName”.

Jaro