E-mail Validation

[santhosh22s]

Hi,

Iam a fresher working in progress.

I have a task of validating e-mail id.

I know how to validate that.

But the problem is, the input is a *.csv file.

so i dont know how to input a file and make it read for each and every mail id and validate it.

Please guide me in resolving the problem.

Thanks in Advance,

Regards,

Santhosh.s

 

[TomBascom]

You need to lookup the INPUT FROM and IMPORT commands. Note that IMPORT uses space as the default delimiter but supports an option to specify a delimiter (such as comma).

 

[santhosh22s]

Thanks Yaar,
Let me Check it out.

Regards,
Santhosh.S

 

[santhosh22s]

Hai.
I have yet another doubt,

How to get the values of particular field alone frm a excel or cvs file,
for example if i want the username from a file,

The username may be in any column in that file.

Is ther any way to search for the fields by using any criteria.?

Thanks in Advance,

Santhosh.S

 

[TomBascom]

Presumably the person providing the file is able to tell you what fields are what.

Hopefully you have been provided with some sort of requirements document or specification to code from. That document should tell you how to determine the answer to that question.

There is certainly no magical way that Progress can look at a random CSV file and say "ah! *that* field is the username!".