Questions tagged [validation]
Validation is the process of checking a parameter against a specification to ensure compliance.
65
questions
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 ...
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 ...
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 ...
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/...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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,...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 (...
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,...
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 ...
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 ...
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,...
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 ...
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?
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 ...
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 ...
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 ...
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 ...
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.
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 ...
-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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
-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 '...
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-...
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 ...
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 ...
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 ...
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.
...
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 ...
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 ...
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 ...
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