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 by yg_be
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
Leave a 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?
Leave a 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!