00:00Time is our turn with text data verification
00:04Of course, it does not have to be text data. It can also be digital data.
00:09But we will start by checking the number of letters, symbols, numbers and spaces that are included in a certain blank.
00:18Let me explain it to you in a slightly easier way.
00:20For example, if I have the entry for the full name, which is the three-part name
00:25If I leave it open, he can write my four-letter name or he can write my five-letter name.
00:30It is possible to write "listen to a lot of vehicles" or "Oh", so the subject will be very crowded and noisy.
00:35I can specify that the entry does not exceed 30 empty characters.
00:42Okay, so to do this, we start by using data validation.
00:48For example, on column H
00:50I will tell him to check the validity of the data
00:55Who will enter the times, what is allowed during the text?
01:00The length of the text can I tell him that it is equal to
01:03For example, ten is perfect
01:08He said to him, "Okay."
01:09I will write to him, for example, Sherine El Masry
01:15He wants to tell me what suits me because here Sherine has five letters
01:21There is a space after that and the Egyptian also has five letters
01:25Ok, I will tell him to try, I can remove the distance
01:28By the way, the distance is also calculated as if it were a letter or a symbol.
01:31Ok too
01:34Oh, here the Egyptian has six letters and here it has five, so there are definitely ten letters.
01:46When I removed some letters from it, it started to pronounce normally.
01:50Ok, very nice. I will start by changing my condition.
01:53I will tell him to leave it as long as the text shows two numbers
01:58Shown for example, ten and thirty
02:04Or leave it at twenty, that's enough
02:08I'll say okay
02:09Here is Sherine El Masry
02:13You will write normally
02:15Mohamed Ahmed Mahmoud
02:20She hasn't turned twenty yet
02:24Egyptian remains
02:27He starts sending me a message, so I start telling him what to say.
02:32Cancel the order
02:33Ok, so now we know how to use
02:37Data validation with text data
02:41Or the digital data that we want to specify a specific length for.
02:44Here we use it to determine the length of the letters, whether they are capital letters.
02:50The spaces symbols are also considered as an element of the elements that entered my cell.
02:55Okay, maybe the employee doesn't know that we have to enter a specific thing here in the entry
03:02Every now and then, a message pops up for him. He doesn't understand what the mistake is.
03:06Can I send him a message so he understands what he is supposed to do? Or of course it is possible?
03:12What should I do? Should I tell him to verify the accuracy of the data?
03:16But this time I tell him to enter the message, please enter
03:25For example, a name with a length or number of letters ranging from 10 to 20 letters is fine.
03:40And I will tell him, “OK,” and the employee will come. The criminal will stop the employee from entering the cell. Then I will tell him, “Please enter a name ranging in number from 10 to 20 letters.”
03:52Okay, very nice. Not only that, but when he does something wrong, a message will appear telling him what the mistake was. I make everything easy for the employee.
04:02I will go back to verify the data and tell him to verify the data
04:08Khalil, this time I am pointing out the wrong verse.
04:11For example, this field does not accept names with less than 10 characters or more than 20 characters.
04:30For example, I mean, can I put the message because I want it?
04:33He comes here and writes to me, for example, such and such.
04:36What's the matter?
04:40He will also tell him the same message here because what did you say?
04:44The topic remains easy and simple. I can specify the number of letters, numbers, and symbols that I want.
04:50Can I put an input message? Can I put an error message? I'll try it.
04:54What should I put in the message?
04:56What should I put in the message?
Comments