Questions tagged [validation]

Validation is the process of checking a parameter against a specification to ensure compliance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
11 views

Google Form validation from a Google Sheet for Inventory [migrated]

I'm trying to make an inventory system and am struggling with using a google form to check out inventory. I would like the form to validate that the products being removed from inventory are actually ...
Lucasheythere's user avatar
0 votes
0 answers
66 views

Copy range of row using two dropdown list as start time and end time in Excel

I have list of data that fetched from SQL at defined time range: At that image I also already make dropdown list named Start time and End time. The question is: how can I make a macro that the output ...
Romy Prazhad's user avatar
0 votes
2 answers
722 views

Bind 9 DNSSEC not returning SERVFAIL when it should

So I just installed bind 9.11.36 on Almalinux 9.1 and it is not validating DNSSEC as expected. Looking up www.dnssec-failed.org should fail validation. The results are missing the ad flag as ...
user2293165's user avatar
0 votes
0 answers
338 views

wsl kali sudo locked after update

I'm running kali on wsl2. I had just run an upgrade (sudo apt upgrade), which included the line: Updating /root/.profile to current default. The update process ended with an error code: /usr/bin/...
Phenomniverse's user avatar
1 vote
0 answers
165 views

Full Verification & Validation of Image-Based Backups [closed]

Intro and some terminology Hello to the community of “Super User”! As the title implies, my question is about the process of full (complete) verification & validation of image-based backups. But ...
Informationsmachine's user avatar
0 votes
1 answer
741 views

SharePoint Date Validation Help Needed

I'm struggling with adding validation to a Date Column in a SharePoint list. I have looked up several sources and even trying the most basic validation of "=[Date Used]> TODAY()" as in ...
Barry's user avatar
  • 11
0 votes
1 answer
3k views

How to deal with special characters in an Excel vlookup in order to display properly?

I have cells with validation values set to a list of some Wingdings characters, and these cells use the Wingdings font: If I use the combo validation by hand to set a value, it works perfectly. But ...
lalebarde's user avatar
  • 725
1 vote
2 answers
6k views

Excel formula to test if 15 or 16 digit number is a valid credit card and return true / false (Luhn's algorithm)

I found a very nice clear spreadsheet below that is able to test any-length numbers for passing Luhn's algorithm. However, I would like a 'mega-formula' to have this entire calculation in a single ...
CeePlusPlus's user avatar
0 votes
1 answer
257 views

Mandatory column based on the value of another column

I have an excel sheet which has following columns - A,B,C,D,E If column A is filled, then column D and E are mandatory. Similarly, vice versa , if column D is filled then columm A and E are mandatory ...
Anonymous's user avatar
0 votes
1 answer
41 views

Prevent User to fill in a specified value into a cell before another cell is filled

Since I am not that well versed in Excel I have stumbled upon the following Problem: I have the two cells: A1 and B1 I want A1 not to be able to be filled with the value "1" before B2 is ...
Felix's user avatar
  • 1
0 votes
1 answer
605 views

Check Cells - If Cell 2 have contains Specific different text then stop from saving

I'm new to vba and have been figuring things as I need them. Any help or clue would be greatly apperiated! I have a new requirement for my macro. I have a Macro that will copy a ws, create a file name,...
Melissa C's user avatar
0 votes
1 answer
1k views

Write the output of xmllint to a log file, how?

With xmllint I check all XML files in the folder and if xmllint finds an invalid XML file there is an output. My question: how can I write this output to a log file? I found this command on the ...
webuser57's user avatar
2 votes
0 answers
622 views

OEM Windows 7 product key missing 1 letter, how can I fill in the blank?

I have a Lenovo ThinkCentre machine I'm trying to refurbish for a friend. I'd like to install the version of Windows it came with, but the Microsoft OEM key sticker is missing one letter near the very ...
Jeff's user avatar
  • 21
0 votes
1 answer
58 views

Aptitude validate installed package against deb/repo

I am bouncing back from disk corruption caused by power failure. All configs and non-repository files are backed up, and I have a list of installed packages, so I can start fresh this time but I am ...
memtha's user avatar
  • 181
1 vote
1 answer
34 views

Adding multiple validations to a cell

I'm adding some validations to a form in excel. The rule is displayed when the cell is selected, and the cell must highlight red when it doesn't match the criteria. This is usually fine except I ...
David's user avatar
  • 13
0 votes
1 answer
481 views

How to apply two validation in one cell on Excel?

I have to apply two validation on a range of cell in Excel. The first validation is If A1=inactive, then B2 should populate with N/A, if not, then, (here comes the second validation), the user have to ...
user1064748's user avatar
1 vote
1 answer
468 views

EDI X12 file validation error (Azure Logic Apps)

I am trying to validate and parse an X12 file (835/837) in Microsoft Azure using Logic Apps. I have setup my integrations account, tied it to the logic app, schema and agreement is done. However I ...
Yura's user avatar
  • 11
1 vote
1 answer
83 views

firefox certificate validation ssl

i'm experimenting with old FFes prior v53. My favorite is 'Light', a lean FF49. Due to out-dated certs i get errors for most https-sites. Sure i can make exceptions for each, but that's unnerving and ...
Jens's user avatar
  • 11
5 votes
1 answer
50k views

How can I add autocomplete to an Excel drop down validation

I have an excel column where a drop down validation is performed on a list on a separate sheet. I would like to allow the user to start typing in the cell and have the names on the reference list ...
jasonmadesomething's user avatar
0 votes
2 answers
2k views

Excel custom data validation that restricts entry to date or "NA"

I am working on a training tracker for over 250 staff and over 100 training modules. I need to restrict entries into cells to only dates (in format dd/mm/yyyy) greater than the training version date (...
Boyarskee's user avatar
1 vote
0 answers
132 views

Create custom formatting for text fields in excel?

I have an issue in Excel and would like to create some custom formatting for a set of text fields. When I insert names into a spreadsheet, my source data often comes in with middle initials, surnames,...
Ed L.'s user avatar
  • 11
1 vote
2 answers
2k views

Check for text in Excel?

How can i get my IF function to return a error message if NO number has been entered into cell C4. My code below run if you enter a number but it also runs if Cell C4 is empty, only when i enter text ...
jase8888's user avatar
2 votes
1 answer
176 views

MS Excel - Data Validation

I am looking for formula i can use in the Data Validation tool in Excel. There is a type of field i want to apply rules to: Numeric & Symbols only (no alpha) I am at a complete loss, tried ...
OpenTage's user avatar
0 votes
0 answers
380 views

How to validate Windows 7 COA? [duplicate]

How can I tell if a retail box of Windows 7 is genuine, especially from the Certificate of Authenticity (COA) seal? The COA has 3 barcodes: left, right, and bottom. The left one has 2 number sequences,...
CodeBricks's user avatar
0 votes
1 answer
74 views

How to populate data from one sheet to another by making a list?

I am trying to populate data from one sheet to another. On one sheet I have a bunch of different salespeople separated by activity for each month. I want to make a list on another sheet whereby if you ...
Gunni Gill's user avatar
1 vote
1 answer
97 views

Indicating Excel cell contains a dropdown list

I have a list in a cell, however, by default the cell looks empty until a user clicks on it. How can I indicate to a user that the cell contains a dropdown list?
Naz's user avatar
  • 405
0 votes
0 answers
395 views

Validate format in Notepad++ using Regex

I am attempting to validate the below format. I have hundreds of lines of this and I am looking to search for JUST the incorrect ones in Notepad ++. Ex. PN1|1G5555| I want to just make sure that ...
BlainPLD's user avatar
0 votes
3 answers
7k views

Rigorous Email Validation in Excel 2013

I am using Excel 2013. I am building a form that the end user will fill in. I have a cell for users to enter their email address, and I want to build a thorough email validation. I searched a lot ...
Mohammed Abusaif's user avatar
0 votes
2 answers
86 views

windows validation gone after changing pc

I have acer Aspire 5742z PEW71 laptop. It have Intel Pentium P6100 processor (type is unknown) CPU Speed: 2.4 GHz, Hard Drive: 500 GB, RAM: 4 GB DDR3 with dual Channel , Screen Size: 15.5", I needed ...
Shohidul Alam's user avatar
0 votes
1 answer
2k views

Bypass broken form validation in browser?

I need to get to a page that's protected by a "give us some information about you" form. Fair enough, I want something from them, they want something in return. I agree to the deal. ...unfortunately ...
matt wilkie's user avatar
  • 5,123
1 vote
2 answers
9k views

Shell Script User Input Date Validation

How would I go about performing date validation on user input in a shell script? I want to notify the user if they enter the date in the wrong format. The correct format would be YYYYMMDD.
THE DOCTOR's user avatar
0 votes
1 answer
207 views

Validate range of values against another range of values in Excel

Similar to how CountIf validates a single value against a range of values (or, CountIfs validating a range of values against criteria), is there a way to validate a range of values against another ...
jgame's user avatar
  • 3
-4 votes
1 answer
103 views

I need some help in excel validation [closed]

I'm not good in excel. I need to include an excel sheet in my page, and I need an expert who can write these custom formulas for cells validation. 1) A column that accepts only letters, no numbers or ...
Majed6692's user avatar
0 votes
1 answer
87 views

Validating the “results” of the scrollbar in Excel

I have searched high and low, but found nowhere something that could help me. Here is my problem: I need to set a range of dates with two sliders. One slider sets the starting date of the examined ...
Letokteren's user avatar
0 votes
1 answer
1k views

MITM Proxy - Checking Validation of SSL Certificate Chains

I am attempting to check our Android app's SSL Certificate Validation. I have MITM Proxy running on my Mac and am using the Mac as a Proxy for my Android phone. I can see all of the Android's http/s ...
Chris's user avatar
  • 171
18 votes
4 answers
54k views

Validate/verify PDF files integrity

Is there any tool which I can run on the PDFs archives (all directories) and finally it lists/identifies the corrupt/invalid PDFs? I have hundreds of PDF files (related to documentation etc.) on my ...
Admiral's user avatar
  • 283
2 votes
1 answer
9k views

Opening dropdown box immediately on cell entry excel

I have successfully implemented cascading dropdown lists, where the contents of the dropdown are filtered by the previous selection, using an adaptation of Contextures Offset/Match method of ...
user avatar
2 votes
1 answer
55k views

Excel: Data Validation to make a cell required

I have an Excel file with Column Headers in it. I want to give this Excel file to customers and have them fill in a few rows of data. Several columns are required. but not all are required. How ...
Jen S.'s user avatar
  • 735
0 votes
1 answer
2k views

How do I verify an SMS came from the number which is in the From field? [closed]

I am wondering if it's possible to determine if any SMS'es I get that are suspicious, can be checked if they really come from the sender without actually calling the number and asking the person ...
Gizmo's user avatar
  • 1,949
4 votes
3 answers
18k views

How to protect data validation to fail while copy and paste data?

I am using data validation on a column by a predefined list. but it can be easily fooled or bypassed by pasting (Ctrl+V) data from other source. So how can i protect to user can't enter wrong data ...
Rahul Singh's user avatar
-1 votes
2 answers
340 views

excel data validation in cells wit

In excel I was wondering how you go about adding a simple list (data validation) to a range of cells but have the data validation list only appear if the adjacent cell is filled? For example a simple '...
Jant's user avatar
  • 1
0 votes
1 answer
736 views

Can I force MS Excel table column to use the specified pattern?

I need to develop a tool that enforces strict format of some table. The fields in this table follow specified patterns like number:number (11:20. 2:00), agreed date (11/20/2012 but not locale-...
h22's user avatar
  • 444
0 votes
4 answers
35k views

Data validation - require nearby cell not be blank

I'm trying to create a "comments" field in a worksheet for error-checkers that can only be used when certain errors are flagged as present. (by writing a whole number in the relevant cell) I've tried ...
user190280's user avatar
1 vote
1 answer
2k views

Excel data validation formula

I have a table with an input column and have set up two tables with the allowable input values. The correct table depends on the value in a cell at the end of each row. To determine which table is ...
Terry's user avatar
  • 11
3 votes
2 answers
28k views

How to acquire unique hardware ID of my computer?

I'm going to send my computer for maintenance. But the services at my place have bad reputation, so I think I better be careful. I intend to write down all the hardware ID, so I can know if they ...
Luke Vo's user avatar
  • 1,603
1 vote
1 answer
3k views

PDF to PDF/A converter and validator for .NET or Linux [closed]

I want to convert PDFs to PDF/A under either Windows or Linux. If Windows I want a managed .NET library (with a DLL, not installation). If Linux then the validation file must be readable for code. ...
user145084's user avatar
1 vote
2 answers
1k views

date format excel

Problem 1: I have an Excel Cell which has the number format as dd.mm.yyyy. I need to add limits to that particular cell, using Date criteria in Data Validation. In the data validation I set the ...
user avatar
2 votes
1 answer
1k views

Checking for valid document files

I need a simple way to check if my files are valid documents (pdf, doc, docx, ppt, pptx, xls, xlsx, odt, ods, odp and etc). I can't use file because magic does not work well at all. For example, for ...
Mohammad Hossein Fattahizadeh's user avatar
7 votes
2 answers
22k views

How to ignore Eclipse validation warning "Attribute (...) is obsolete. Its use is discouraged in HTML5 documents." in HTML and JSP fragments?

Create a html/jsp fragment in eclipse in a project where html/jsp validation is active and add <table width="80%"></table> You will get the warning in the question title. One can ...
jan's user avatar
  • 225
0 votes
1 answer
59 views

Getting ip error error in html validation

I installed firefox web developer tools when i try to validate page then i got an error. the screen shot of error below
NullPoiиteя's user avatar