Previous Topic Next Topic

I want to validate the data format

Closed
yuva69 Posts 3 Registration date Monday November 28, 2016 Status Member Last seen November 28, 2016 - Nov 28, 2016 at 01:44 PM
yg_be Posts 23346 Registration date Sunday June 8, 2008 Status Contributor Last seen November 24, 2024 - 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
Related:

2 responses

Answer 1 / 2
yg_be Posts 23346 Registration date Sunday June 8, 2008 Status Contributor Last seen November 24, 2024 5
Nov 28, 2016 at 01:57 PM
Does this question replace your previous question? If yes, please close the previous one.
0
yuva69 Posts 3 Registration date Monday November 28, 2016 Status Member Last seen November 28, 2016
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.
0
Answer 2 / 2
yg_be Posts 23346 Registration date Sunday June 8, 2008 Status Contributor Last seen November 24, 2024 5
Nov 29, 2016 at 10:33 AM
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?
0

Similar discussions

Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
Excel format
D -
sheryljohnson -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses