I want to validate the data format [Closed]

Report
Posts
3
Registration date
Monday November 28, 2016
Status
Member
Last seen
November 28, 2016
-
Posts
15104
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 12, 2021
-
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

2 replies

Posts
15104
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 12, 2021
4
Does this question replace your previous question? If yes, please close the previous one.
Posts
3
Registration date
Monday November 28, 2016
Status
Member
Last seen
November 28, 2016

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.
Posts
15104
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 12, 2021
4
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?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!