Report

I want to validate the data format

Ask a question yuva69 3Posts Monday November 28, 2016Registration date November 28, 2016 Last seen - Last answered on Nov 29, 2016 at 10:33 AM
Hi
I need to verify/validate the data in a column, it should be "AAAA-16-0001" format. If the data is not in the specified format, i need to have a column which prints boolean FALSE? Please help.

Regards

Yuva
See more 
Helpful
+0
moins plus
Does this question replace your previous question? If yes, please close the previous one.
yuva69 3Posts Monday November 28, 2016Registration date November 28, 2016 Last seen - Nov 28, 2016 at 11:43 PM
No, it is not a replacement for previous one. The previous requirement is validate format from another worksheet. Can you please suggest a solution.

Thanks.
Reply
Add comment
Helpful
+0
moins plus
Not clear to me what you mean by "AAAA-16-0001" format.
Could you provide a few samples of data matching that format, and of data not matching that format?
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!