Menu
  • HOME
  • TAGS

VBA *Wildcard* Vlookup - or alternative

excel-vba,replace,find,wildcard,vlookup

If using Vlookup like you're doing with blnLookupType set to true doesn't give the result you want, you can use Range.Find, then return the value you want with Offset. It supports wildcards and you can search for either part of a string or a whole. See examples below. Sub FindingPart()...

Is it possible to implement method with signature List> in Java?

java,generics,wildcard

I would assume that this is because of the jdk 1.7 type inference nature. As you may already know, the Arrays.asList(T ... elems) method is generic, but we seldom explicitly specify the type-parameter which we'd like the method to work with and thus we rely on the type inference feature...

Searching for a wildcard value when calling a shortcode?

php,wordpress,forms,wildcard

I worked out the issue was that I'd previously built another form on my staging site using CCF, I went through phpmyadmin posts and deleted everything ccf-based then rebuilt my form and since there were no previous forms this form was assigned the id 122 and my template now works...

Byte Pattern Finding (Needle in Haystack) - Wildcard/Mask?

c#,arrays,byte,wildcard,mask

Modifying your code to support wildcards is easy enough. Making it efficient for searching in large bodies of data will probably require a more sophisticated algorithm, like Boyer-Moore with wildcards (sorry, I don't have the code lying around). Here's one way of doing the former (off the top of my...

Python wild card match

python,match,wildcard

Get search input from the user. Open and reader file by csv module. Check first item from each row with search text. Print result. code: import csv search_text = raw_input('Enter search text:').strip() file2 = '/home/vivek/Desktop/stackoverflow/file3.txt' with open(file2) as fp1: root = csv.reader(fp1) if search_text=="*": result = list(root) else: result...

bash wildcard with variables inside an if statement

string,bash,if-statement,wildcard

In the reference manual, section Conditional Constructs, you will read, for the documentation of [[ ... ]]: When the == and != operators are used, the string to the right of the operator is considered a pattern and matched according to the rules described below in Pattern Matching, as if...

How to add a constant character to the end of a HTML search form

html,forms,search,wildcard,asterisk

simply attach an event listener to the submit click, and before submitting the form add an asterisk to the end of search query... document.getElementsByClassName("submitok")[0].addEventListener("click",function(){ document.getElementsByClassName("input")[0].value+="*"; }); <form action="index.php" method="get" style="margin:0" accept-charset="UTF-8" enctype="application/x-www-form-urlencoded"> <input class="input" name="q" type="text" value="" /> <input type="hidden" name="-1" value="0" /> <input type="hidden"...

What do double-asterisk wildcards mean?

unix,wildcard

Consider a folder folderA having file1, file2, folderB and folderB in turn has file3 and folderC ls will list all objects in the current folder so it will return file1, file2, folderB ls * will list all objects in the current folder and in addition one more level recursively file1,...

Wildcards and Like on Laravel Error not working on $variable

php,laravel,eloquent,wildcard,like

This '%$soptions%' does not get interpolated, instead you should write "%$soptions%" or "%{$soptions}%" or '%' . $soptions . '%'. Simple mistake.

Import symbols with wildcard, but rename or ignore some of them

scala,import,wildcard

You can use an underscore to exclude certain names. import scala.swing.{ToggleButton => _, _} import mydomain.swing._ An alternative solution is to import ToggleButton individually. Since individual imports take precedence over wildcard ones, the reference to ToggleButton will no longer be ambiguous. import scala.swing._ import mydomain.swing.{ToggleButton, _} ...

Is there a way of using wildcards in gnuplot?

regex,gnuplot,wildcard

This is not directly possible in gnuplot. However, you can use system calls to get a list of files to plot: filelist=system("ls *.csv") plot for [filename in filelist] filename using 1:2 So, here is an example that creates one plot per sample number with all references: do for [i=1:35] {...

Unzip files that begin with a particular string

vbscript,wildcard,unzip

You could use a regular expression for matching variable file names: Set re = New RegExp re.Pattern = "^home weekly.*\.zip$" Set fso = CreateObject("Scripting.FileSystemObject") Set app = CreateObject("Shell.Application") ExtractTo = "C:\Users\W1 Process\_ThisWeek" For Each f In fso.GetFolder("C:\Users\W1 Process\_ThisWeek").Files If re.Test(f.Name) Then Set FilesInZip = app.NameSpace(f.Path).Items app.NameSpace(ExtractTo).CopyHere(FilesInZip) End If Next ...

How to copy a file on several directories with the name *Co* (where *=wildcard)

copy,wildcard,directory

If your version of cp supports -n, you can do: find . -name '*Co*' -exec cp -n fileA {} \; If not: find . -name '*Co*' -exec sh -c 'test -f $0/fileA || cp fileA $0' {} \; Note that these will each descend recursively: if you don't want that...

Nested wildcards

java,generics,wildcard

It is important to understand the implication of the wildcard types. You already understood that you can assign your Map<Integer, Map<Integer, String>> to Map<?, ?> as Map<?, ?> implies arbitrary types, unknown to whoever might have a reference of the declared type Map<?, ?>. So you can assign any map to...

List only folders which matches the wildcard expression

wildcard,ls

Use find command, for example: # find anything that start with 'jo' end with 'm' (case insensitive) find . -iname 'jo*m' You can execute any command after that, for example: # find just like above but case sensitive, and move them to `/tmp` find . -name 'JO*M' -exec mv -v...

Why HashMap with generic declaration “ does not accept value ”new Object()" in the put method?

java,generics,hashmap,wildcard,superclass

The type ? super ArrayList means an unknown type, which has a lower bound of ArrayList. For example, it could be Object, but might be AbstractList or ArrayList. The only thing the compiler can know for sure is that the type of the value, although unknown, is guaranteed to be...

Is it possible to check if a Mutex is created by using wildcards?

c#,mutex,wildcard

So from the comments I get the sense that this is impossible so a better solution might be to check the running processes which I achieved like so: foreach (var process in Process.GetProcesses()) { if (process.MainWindowTitle.IndexOf("MyApp",StringComparison.InvariantCultureIgnoreCase) >= 0) { isNew = false; } } ...

Wildcard for Set in Map - return type incompatible - Why? [duplicate]

java,generics,dictionary,wildcard,return-type

Original example is complicated, I will use some simplifications In your example Foo.set() returns Set<? extends X> If Y extends X then Set<Y> IS Set<? extends X> But Foo.map() returns Map<K, Set<? extends X>> and Map<K, Set<Y>> IS NOT Map<K, Set<? extends X>> however Map<K, Set<Y>> IS Map<K, ? extends...

Wildcard SSL Certificates, Custom Domain Names, and Cloudflare

ssl,https,wildcard,cloudflare

There are a few factors to this. One is how far you trust CloudFlare. They will see your users' traffic in plaintext, after decrypting the tunnel between them and the user and before re-encrypting it to the origin server. Secondly, CloudFlare are not doing any validation of the server's certificate...

Usage of asterisk at the end of command

linux,shell,unix,wildcard

The asterisk * at the end is used to check in the list of files in your directory in lexicographic order.

xpath expression wild-cards

xpath,wildcard

You should be able to do this using starts-with() and a makeshift ends-with() (since XPath 1.0 doesn't actually have an ends-with() function): //*[starts-with(@name, '/Root/Table[') and substring(@name, string-length(@name) - 11 + 1) = ']/FirstName'] Here, 11 is the length of ]/FirstName....

JAVA SQL assign all wildcards to null

java,sql,prepared-statement,wildcard

I can just offer you to not use preparedStatement.setNull() in this case(so yours statements every time will be different and will take hard parse every time), but just replace all yours "?" to "NULL" inside your statement. Why not ?

Avoiding expansion when looping: for x in $foo

bash,shell,for-loop,wildcard,expansion

The solution to this should not under any circumstance involve ls. You can iterate the files with a for-loop and use an -x test to determine if files are executable. However, directories are usually executable too (if they're not, you cannot enter them, e.g. with cd), so depending on whether...

How to assign a class type to a wildcard class definition (java)

java,wildcard

You have a member variable newClassObject. You cannot call it as if it is a method, like this: // newClassObject is a variable, you can't call a variable using ...(); ParentClass x = newClassObject(); Since it's an instance of class java.lang.Class, you can call the methods of java.lang.Class on it;...

How to use wildcards at the beginning of property value?

neo4j,cypher,wildcard

You're pretty close, just put the case insensitive marker at the beginning and use .* as placeholder. Try the following: match (n)-[:RELATIONSHIP]-(NODE) where NODE.name=~ "(?i).*something.*" Return n.name ...

grep with wildcard symbols

bash,grep,wildcard

Why your commands are (not) working: 1. [email protected]:~/test# grep -o 192.1 z Only 192<any char>1 will be matched, and only the matching part will be printed because of the -o switch. 2. [email protected]:~/test# grep -o 192.1* z Only 192<any char>, 192<any char>1, 192<any char>11, 192<any char>111 etc. will be matched,...

How do I use the generic type of this class's generic type (Java)?

java,generics,inheritance,polymorphism,wildcard

You can declare a second type parameter for B and have that be the parameterization of A class B<K, T extends A<K>> { public K get() { // actual implementation return null; } } Then declare your variables B<String, A2> var = new B<>(); String ret = var.get(); What is...

How to use Wildcard Search Parameterized?

c#,sql,sql-server,search,wildcard

Short Answer As Nathan said, just add + on either side of the @Item_Description parameter. This will concatenate it together with the rest of the command string. SqlCommand searchcommand = new SqlCommand("Select * from [ITEM MASTER] WHERE Item_Description LIKE '%' + @Item_Description + '%' ", con); More Advice If you...

Using wildcards in Sql to match patterns

sql,oracle11g,wildcard

You can make use of regexp_like WITH DATA AS( SELECT 'XKA' str FROM dual UNION ALL SELECT 'XKB' FROM dual UNION ALL SELECT 'XSA' FROM dual UNION ALL SELECT 'XSB' FROM dual UNION ALL SELECT 'XAA' FROM dual ) SELECT str FROM DATA WHERE regexp_like (str, 'X[^KS]'); X -> first...

Why does this code compile? (java generic method)

java,wildcard,generic-method

JavaTest.<scruby>max(List, 0, 0); scruby is a raw type. This suppresses some of the type checks. You should add all required type parameters: JavaTest.<scruby<Integer>>max(List, 0, 0); Or just let Java infer them: JavaTest.max(List, 0, 0); ...

Generic wildcards in java. Compile error.

java,generics,wildcard

Because a Box<? extends Integer> can be a Box<SomeSubtypeOfIntegerNotIncluding10>. You want a Box<Integer> instead.

Numerical wildcard when using strcmp C/C++ for Arduino

c++,c,arduino,wildcard,strcmp

int i,j,k,l,m; if(strlen(input)==7 && sscanf(input, "LP%1d%1d%1d%1d%1d", &i,&j,&k,&l,&m)==5) { //run this } ...

How can I force MSBuild to respect project dependencies in my solution when my project uses a Csc task?

c#,visual-studio-2010,msbuild,wildcard

It appears that the issue was not build order so much as when the wildcards are evaluated. In my example, the CSFile tag is evaluated before the generated .cs files from ProjectA exist, so even though ProjectA happens first, they are not included in the build. To circumvent this, I...

command line arguments java * is being overloaded to pick up filenames

java,shell,cmd,wildcard

This has nothing to do with java, but with the command line, you need to use: java Calculate 2 "*" 3 The reason is that * is interpreted by the command line as a wildcard: it is replaced by all files in the folder, and luckily there is only one...

Filtering using multiple wildcards

make,filtering,wildcard,gnu-make,glob

Try relevant = $(foreach a,$^,$(if $(findstring irrelevant,$a),,$a)) ...

Why can't we capture wildcards for the method with two parameters?

java,generics,wildcard

In this method private <T> int comp(Comparable<T> upper, Comparable<T> lower){ return upper.compareTo((T) lower); } both of the parameters share the same type-parameter. Meanwhile, this is not true for the other method: private int compare (Comparable<?> upper, Comparable<?> lower){ return comp(upper, lower); } Here, the compiler has no evidence that the...

jQuery Wildcare Image Source

javascript,jquery,image,wildcard

Try this: <!-- SOME HTML AND ETC... --> <div id="gallery"> <img src="http://pic.test.net/images-small/001/002/123456.jpg" /> <img src="http://pic.test.net/images-small/001/002/1234567.jpg" /> <img src="http://pic.test.net/images-small/001/002/1234568.jpg" /> </div> <!-- SOME HTML AND ETC... --> <script> $(function(){ var $imagesContainer = $('#gallery'); $imagesContainer.find('img').each(function(){ var src = $(this).attr('src'); if(src.indexOf('images-small/')>-1) { src =...

Using Wildcards to Extract Text from Cell String Containing a Specific Value/Character

string,excel,extract,wildcard,worksheet-function

Please try, in C2: =SUBSTITUTE(LEFT(SUBSTITUTE(B2," ","|",(LEN(B2)-LEN(SUBSTITUTE(B2," ","")))),FIND("|",SUBSTITUTE(B2," ","|",(LEN(B2)-LEN(SUBSTITUTE(B2," ","")))))-1),",","") in D2: =MID(SUBSTITUTE(B2," ","|",(LEN(B2)-LEN(SUBSTITUTE(B2," ","")))),FIND("|",SUBSTITUTE(B2," ","|",(LEN(B2)-LEN(SUBSTITUTE(B2," ","")))))+1,LEN(B2)) ...

Vb.net wild cards in registry path

.net,vb.net,registry,wildcard,registrykey

How to iterate all keys at a specific registry path using System; using Microsoft.Win32; namespace RegistryLister { public static class Program { static void Main(string[] args) { //var key = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\MyProgram\"); var key = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\"); if (key != null) foreach (var keyName in key.GetSubKeyNames()) { //if (keyName.StartsWith("PROG7")) if (keyName.StartsWith("Mic")) Console.WriteLine(keyName);...

python pandas wildcard? Replace all values in df with a constant

python,pandas,wildcard

df_new = pd.DataFrame(np.ones(df.shape), columns=df.columns) import numpy as np import pandas as pd d = [ [1,1,1,1,1], [2,2,2,2,2], [3,3,3,3,3], [4,4,4,4,4], [5,5,5,5,5], ] cols = ["A","B","C","D","E"] %timeit df1 = pd.DataFrame(np.ones(df.shape), columns=df.columns) 10000 loops, best of 3: 94.6 µs per loop %timeit df2 = df.copy(); df2.loc[:, :] = 1 1000 loops, best of...

Extracting information from multi-level lists - R

r,list,wildcard,multi-level

You really should be storing your data in a data frame or some such. I understand that the recursive structure is convenient when you're running tests in loops, but still. Fortunately there is a function that can do the translation: lst <- list(a=list(b=list(c0=list(d0=1:3, e0=4:6), c1=list(d1=7:9, e1=10:12)))) library(reshape2) DF <- melt(lst)...

BATCH IF condition for specific format

windows,batch-file,if-statement,command-line,wildcard

@ECHO OFF SETLOCAL SET "leadnum=123456789" SET "anynum=%leadnum%0" FOR %%i IN ( 1.2.3 123.456.789 012.345.678 12.3 12 12a.345.678 12.34.56.78 12.34.777f 12.34. 12.34.56. ) DO ( ECHO %%i|FINDSTR /b /e "[%leadnum%][%anynum%]*\.[%leadnum%][%anynum%]*\.[%leadnum%][%anynum%]*" >NUL IF ERRORLEVEL 1 (ECHO %%i is NOT of format) ELSE (ECHO %%i is IN format) ) GOTO :EOF Here's a...

Excel Advanced Filter not working with Wildcard (* asterisk) using regular numbers and hyphenated number system

excel,filter,wildcard

You had the right idea when you tried formatting as text: wildcards don't work on numeric values. Where you're running into trouble is that formatting as text doesn't change numbers to text retroactively; only numbers entered after the format change get converted. Instead convert your data to strings first using...

Powershell Move-ADObject wildcard

powershell,wildcard

I would do something like this: get-adcomputer -filter "name -like '*Notebook*'" -searchbase "CN=Computers,DC=contoso,DC=net" | move-adobject -targetpath "OU=Notebooks,DC=contoso,DC=net" ...

SQL LIKE Equivalent in C#

c#,linq,wildcard,like-operator

You could achieve your goal by using regular expressions. See Regex.Match Method. You can transform your selected string from the dropdown list into a regular expression then use the Match method in your LINQ query. Regex r = new Regex(String.Format ("Customer {0} has {1} orders", "([^\s]+)", "([^\s]+)")); This code: o.CustomField.Contains(searchString)...

MySql MyIsam table with fulltext search wildcard

mysql,wildcard,myisam,full-text-indexing

I solved this issue by putting space before + match(col1,col2) against ('+scho* +bus*') but I have another issue, if I want to search by any keyword end with any thing, it can't be displayed, if I search by keyword "School" match(col1,col2) against ('+chool') 0 rows...

When does Firefox throw ssl_error_bad_cert_domain with a wildcard certificate?

firefox,ssl,wildcard

If so, then why wouldn't an SSL certificate with the common name "*.subdomain.mydomain.tld" work with the website "https://subdomain.mydomain.tld" and throw this specific error? A wildcard stands for a single label and not for nothing. That means *.subdomain.example.com does not match subdomain.example.com but it will match foo.subdomain.example.com. To match subdomain.example.com...

MySQL LIKE pattern matching returning empty set when it should be returning values

mysql,sql,wildcard,sql-like

Use a regular expression instead of a SQL Server style LIKE pattern: SELECT * FROM tableName WHERE description REGEXP '^..[aeiou].*$'; EDIT: For those who don't read documentation thoroughly, the documentation says: The other type of pattern matching provided by MySQL uses extended regular expressions. When you test for a match...

SSL - self signed certificate with wildcard

ssl,certificate,wildcard,self-signed

I think most browsers don't allow wildcard at the second level, because usually a single entity does not own a top level domain. So you need to have something like *.foo.local instead of *.foo.

Why use a wild card capture helper method?

java,generics,wildcard

In this particular case it's because the List.set(int, E) method requires the type to be the same as the type in the list. If you don't have the helper method, the compiler doesn't know if ? is the same for List<?> and the return from get(int) so you get a...

Excel - using wildcard in IF formula

excel,if-statement,wildcard,formula

Wildcards don't work here. Possible solution is instead of: $C7243=ANP$7&"*" Use: LEFT($C7243,LEN(ANP$7))=ANP$7 ...

Search uses * in database as a wildcard

c#,search,wildcard,reverse

Not sure what SQL server you're on, but hopefully this works on any (tested on MSSQL). If you look at the documentation for LIKE, you see that the wildcard you need is _ (underscore). Operators in SQL, in general, can be used both ways (i.e. both field LIKE constant and...

Replace wildcard from string

python,replace,wildcard

Python doesn't really deal with wildcards. You should read more on Regex, which isn't Python specific. In any case, this should take care of it: ex = "/Volumes/Obelix/5215.tif, /Volumes/Gemeinsam/25.tif, /Volumes/Obelix/5100.tif" newex = re.sub(r'/Volumes/Gemeinsam/.+?,?(\s|$)', '', ex) ...

r substring wildcard search to find text

r,substring,wildcard

Try library(tidyr) extract(employ.data, employee, into=c('num1', 'num2'), '([^-]*)-([^.]*)\\..*', convert=TRUE) # num1 num2 #1 60 150 #2 300 12 Or library(data.table)#v1.9.5+ setDT(employ.data)[, tstrsplit(employee, '[-.]', type.convert=TRUE)[-3]] # V1 V2 #1: 60 150 #2: 300 12 Or based on @rawr's comment read.table(text=gsub('-|.PNG', ' ', employ.data$employee), col.names=c('num1', 'num2')) # num1 num2 #1 60 150 #2...

excel macro vba Filtering using wildcards

excel,vba,excel-vba,filtering,wildcard

Try this: With ActiveCell.PivotTable.PivotFields("Column") For i = 1 To .PivotItems.Count If .PivotItems(i).Name like "A.*" or .PivotItems(i).Name like "H.*" Then .PivotItems(i).Visible = True else .PivotItems(i).Visible = False End If Next i End With ...

Adding new value to existing Stream

java,java-8,wildcard

The question belies an incorrect assumption: that streams actually contain their data. They do not; streams are not data structures, they are a means for specifying bulk operations across a variety of data sources. There are combinators for combining two streams into one, such as Stream.concat, and factories for creating...

How to write an SQL query that uses wild-card map to do transformation

sql,wildcard

Here is one way to do this using a CTE (will work on SQL Server and Oracle) WITH Map3 as ( -- TRANSFORM WILL BE NULL IF A MATCH WAS NOT MADE SELECT T1.COL1, T1.COL2, T1.COL3, M.TRANSFORM FROM Table1 T1 LEFT JOIN Mapping M ON T1.COL1 = M.COL1 AND T1.COL2...

Using Wildcards in Index(Match) function

excel,vba,excel-vba,excel-formula,wildcard

Try this: Range("D2").Value = Application.Index(Sheets("Future_220_140_MON").Range("B20:AK24"), _ Application.Match(Range("T2").Value, Sheets("Future_220_140_MON").Range("A20:A24"),0), _ Application.Match("*" & Range("C2").Value & "*", Sheets("Future_220_140_MON").Range("B1:AK1"),0)) Based on clarification, the code would need to be like this: Range("D2").Value = Application.Index(Sheets("Future_220_140_MON").Range("B20:AK24"), _ Application.Match(Range("T2").Value, Sheets("Future_220_140_MON").Range("A20:A24"),0), _...

Incorrect Syntax or misunderstanding powershell Do until loop

variables,powershell,switch-statement,wildcard

(While I might not have written it like this, I just fixed code so you could get out of your infinite loop) You might want something like Function Workstation{ Write-Host "Workstation $name" return $true } Function UserName{ Write-Host "User Name $name" return $true } DO { $Name = Read-Host "Please...

interesting behaviour of upper bounded java wildcards

java,generics,wildcard

Well that is because, Ultimately you are doing: List<? extends Integer> ls = new ArrayList<Integer>(); doJob(ls,ls,ls.get(0)); So ls (or your intList) is actually a List of an unknown type. But what you do know, is that this unknown type extends Number. So when you call doJob, T in doJob becomes...

Using Wildcard Sql for searching a word in a TextField

sql,database,laravel,web,wildcard

If you use mysql you can try this: <?php $q = Input::get('searchbox'); $results = DB::table('table') ->whereRaw("MATCH(columntobesearch) AGAINST(? IN BOOLEAN MODE)", array($q) )->get(); Ofcourse you need to prepare your table for full text search in your migration file with DB::statement('ALTER TABLE table ADD FULLTEXT search(columntobesearch)'); Any way, this is not the...

Trying to use wildcards in bash conditional statement/case mixed with exact alpha char and failing

bash,wildcard,conditional-statements,alpha

Using globs: [[ $tm0 == [01][0-9][0-5][0-9][aApP][mM] ]] Note that this will validate, e.g., 1900pm. If you don't want that: [[ $tm0 == @(0[0-9]|1[0-2])[0-5][0-9][aApP][mM] ]] This uses extended globs. Note that you don't need shopt -s extglob to use extended globs inside [[ ... ]]: in section Condition Constructs, for the...

Limit of 4Kbytes when using print in AWK?

printing,awk,wildcard

You can probably get away with: suffix=".$$.tmp" ' awk -v suf="$suffix" ' FNR == 1 {outfile = FILENAME suf} /pattern/ {headerfound = 1} headerfound && /^[[:blank:]]*$/ {$1 = "--"} { print > outfile } ' *.txt for f in *.txt; do echo mv "${f}$suffix" "$f" done Remove the echo from...

Using wildcards

sql,wildcard,netezza

In sql there is something known as an escape character, basically if you use this character it will be ignored and the character right behind it will be used as a literal instead of a wildcard in the case of % WHERE Text LIKE '%!%%' ESCAPE '!' The above sql...

T-SQL Replace Multiple Values with Wildcards

sql,string,sql-server-2008,replace,wildcard

You can define all the variables to be replaced and the replacement inside a table use it. create TABLE #ReplaceStrings (symb VARCHAR(5),replace_char varchar(5)) INSERT INTO #ReplaceStrings (symb,replace_char) VALUES ('/','|'),(',','|') DECLARE @OMG VARCHAR(200) SET @OMG = 'ABC,DE/F' SELECT @OMG = Replace(@OMG, symb, replace_char) FROM #ReplaceStrings select @OMG Here in a single...

Using masks to select subdirectories for transfer with WinSCP

ftp,wildcard,winscp

There's no really straightforward way to do this with WinSCP as it does not have a feature similar to --parents. Only way is to explicitly exclude all subdirectories you do not want to transfer: | b/; c/ (The | denote an exclude mask). See http://winscp.net/eng/docs/file_mask...

How generate CSR for wildcard multidomain certificates

ssl,certificate,wildcard,csr

For a Multi Domain wildcard certificate the CSR is to be generated for a non wildcard domain name (like www.domain.com or domain.com). While completing your order, you have to specify the Wildcard domain names in the Additional domain names list as follows: *.domain1.com *.domain2.com ...

unformatted output with wild card in Fortran

fortran,wildcard,fortran90

For a unit connected to a file for unformatted I/O it is illegal to specify a format as you do in write(10,'(i10)') nn The write of the value to the unformatted file is done in machine memory (binary) representation (some conversion may happen) and not as a human readable text....

Regex to find words that contain hyphen MS Office

regex,ms-word,find,ms-office,wildcard

You could try the below regex to match words like good-boy <[a-z]{1,}-[a-z]{1,}> [a-z]{1,} matches any lowercase letter one or more times....

Java Generics with Composite Key and Wildcards

java,generics,wildcard

From what I can work out from your sample code: 1) Your CompositeKeyImplementer needs to be generic. It implements a generic interface, and you later refer to it as a generic type. public class CompositeKeyImplementer<K1, K2> implements CompositeKeyType<K, V> { ... 2) You want to have a CompositeKeyImplementor<K1, K2> with...

Wildcard Regular Expression to Next Space

java,regex,wildcard

\S means non-whitespace character. It's a shorthand for [^\s]. Therefore \S* means a sequence of non-whitespace characters. So the regex you're looking for is val\S*....

Having trouble matching a single character in an SQL table

mysql,sql,wildcard

In MySQL, the underscore is used to represent a wildcard for a single character. You can read more about that Pattern Matching here. The way you have it written, your query will pull any rows where the id column is just one single character, you don't need to change anything....

Wildcards in Standard ML

wildcard,sml,ml

Yes, they can, but the matched list won't be empty, so the result of the null function holds, i.e., [] :: [], which is equivalent to [[]], is not an empty list. No, that's syntactically invalid. However, it can be shortened to this: fun null [] = true |...

how to avoid casting when implementing generic interface

java,generics,casting,wildcard

You have to change your class to implement Graph<K, V> instead of just Graph. public class AdjacencyList <K extends Comparable<K>, V> implements Graph<K, V> Then you can use K and V for your implemented methods' parameters. @Override public void addVertex(K key, V value) { // TODO Auto-generated method stub }...

pathnames in Common Lisp, filenames with wildcards in them

common-lisp,filenames,wildcard,clisp,pathname

It depends on the implementation, but for some, a backslash does in fact work. But because namestrings are strings, to get a string with a backslash in it, you have to escape the backslash with another backslash. So, for example, "foo?" is escaped as "foo\\?", not "foo\?". Last time I...

Casting generics list in Java

java,generics,wildcard

Every programming language allows you to shoot yourself into the foot. In this case, Java is in a dilemma: It could keep the generics information in the bytecode and break millions of lines of existing code or silently drop the generics information after the compiler has do it's utmost to...

PHP Array Keys Wildcard

php,arrays,wildcard

Thanks for the criticism! I ended up storing the second key in a variable so it looks like: $arraykey = key($myarray[$i]); if($myarray[$i][$arraykey] == "") { .... ...

PHP Reslter 3 Wildcard and Custom Routing

php,wildcard,restler

Wildcard routes do not support dynamic parts yet! so you can do the following instead class CRUDEntity { /** * @param int $entity_id * * @url GET /entity/* */ function getBatch($entity_id, $books = 'books') { if (!is_numeric($entity_id) || $books != 'books') { throw new RestException(404); } $dynamicArguments = func_get_args(); array_shift($dynamicArguments);...

How can I add and track files in git without tracking the directories they are in?

git,github,version-control,directory,wildcard

You write I want the file to be pushed alone without the directories it is in. That is not possible with Git. Your remote repository will have the same structure the your working tree of your local repository. Nothing you can do about that....

mssql search a varchar field for invalid typo

sql-server,validation,wildcard

Hopefully this is a one of fix-up; a negated character class: where patindex('%[^ A-Za-z,.''-]%', name) > 0 Although more letters than A-Z can appear in names ......

How to specify a wildcard in a SQL Server Table Adapter query

c#,sql,sql-server,wildcard,tableadapter

This is what I did, and it worked, I hope it's useful to you. 1.- In Dataset designer right click table adapter, add query 2.- Use SQL Satatements 3.- Select which returns a single value 4.- Open Query builder, It looks like this: 5.- And in my test I did...

Java import wildcard not importing everything inside package

java,import,awt,actionlistener,wildcard

Here is the definition of type-import-on-demand in the Java Language Specification: A type-import-on-demand declaration allows all accessible types of a named package or type to be imported as needed. TypeImportOnDemandDeclaration: import PackageOrTypeName . * ; It is important to understand the terminology: "all accessible types of a named package" means...

Wildcard and mutator methods

java,generics,collections,wildcard

List<? super Animal> list = new ArrayList<>(); list.add(new Dog()); //it's OK list.add(new Animal()); //and this is OK too The above code is allowed as it should be : because A dog is also an animal. List<? super Dog> list = new ArrayList<>(); list.add(new Dog()); //it's OK list.add(new Animal()); //error...

Searching through an array using Ruby's array.index() method using wildcards

ruby,arrays,wildcard

Yes, using Array#index is sensible: arr = [{x: 1, y: 2, base: "Yo, how ya' doin'?"}, {x: 1, y: 3, base: "Hey, bro!"}, {x: 2, y: 5, z: 4 }] target = { x: 1, y: 2 } arr.index { |h| h.values_at(*target.keys) == target.values } #=> 0 target = {...

Why can't I allow '*' characters in webapi routes safely? (or, if it can, how?)

asp.net-mvc,asp.net-web-api,wildcard,asp.net-web-api2

My question is, why is '*' evil? i.e. If I allow it, via requestPathInvalidCharacters in web.config They may have special meaning: The asterisk ("*", ASCII 2A hex) and exclamation mark ("!" , ASCII 21 hex) are reserved for use as having special signifiance within specific schemes. I agree with...

T SQL wildcard searching for a zip code

sql,search,wildcard

If what you said is true, that @MailFiveDigitZip is a char and not a varchar, then you're running into character padding issues. "44" in a varchar(5) is "44" "44" in a char(5) is "44 " (note in case it doesn't translate well... this is 44 plus 3 spaces) like "44...

TALEND tMap - how to use wildcard in string match?

java,wildcard,talend

Yes you can use java expression in Talend to achieve this. use below expression and test whether it works or not. row.regulation.endsWith(".2a") || row.regulation.endsWith(".2b") ...

bash shell wildcard pattern matching

shell,unix,filtering,wildcard

cat fileName | grep -E '^[0-9]{1,2},[A-Z][a-z][a-z].[0-9][0-9][0-9][0-9]' This will match "20,Apr.2014", "2,Mar.2013" pattern. {1,2} means one or 2 digits....

Split string with some known characters and unknown two digits in powershell [closed]

string,powershell,split,wildcard,digits

Use a regex with a capture group: .*?S.*?(\d{2}).*?E.* > "some.text.S**01**E02.partofstring.mkv" -replace '.*?S.*?(\d{2}).*?E.*','$1' 01 > "some.textstring.S**01**E02.partofstring.mkv" -replace '.*?S.*?(\d{2}).*?E.*','$1' 01 ...

Notepad++ erase anything in between.. without REGEX?

notepad++,wildcard

With an assumption. 1. The hex numbers bookending the code are always 6 chars long With RegEx in Notepad++. You should search for this: (#[0-f]{6}#)(.*)(#/[0-f]{6}#) and replace with ## Making sure the option to ". matches newline" is checked....

MySQL wildcard replace

mysql,replace,wildcard,placeholder

Using SUBSTRING_INDEX: UPDATE table1 SET column1 = REPLACE( column1, SUBSTRING_INDEX(column1, '/', 2), 'newsite.com' ) WHERE column1 LIKE 'example.com/%/' This should honour your subfolder structure....

powershell v2 - rename a file whose name matches a string containing a wildcard

powershell-v2.0,wildcard,rename

$d = Get-Date -format "yyyyMMddHHmm" $dir = "C:\test" $file = "filename*.log" get-childitem -Path $dir | where-object { $_.Name -like $file } | %{ rename-item -LiteralPath $_.FullName -NewName "$d`_$($_.name)" } This should work, assuming that the errors were relating to "Cannot bind argument to parameter 'Path'", and the NewName string. Issues...