i want to check format of the data

mishra.hanu@yahoo.co.in

• July 21, 2008 00:00

• Answered

Follow

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

• 

  jurban

  • July 21, 2008 14:55

  0

  Comment actions Permalink

  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
• 

  mishra.hanu@yahoo.co.in

  • July 25, 2008 13:33

  0

  Comment actions Permalink

  Hi,
  
  can you please give me example that how to write a expression to remove speciall characters....
• 

  jurban

  • July 25, 2008 13:44

  0

  Comment actions Permalink

  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

Please sign in to leave a comment.