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()...
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...
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...
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...
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...
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...
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"...
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,...
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, _} ...
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] {...
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 ...
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...
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...
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...
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...
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; } } ...
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...
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...
The asterisk * at the end is used to check in the list of files in your directory in lexicographic order.
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,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 ?
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...
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;...
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 ...
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,...
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...
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...
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...
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); ...
Because a Box<? extends Integer> can be a Box<SomeSubtypeOfIntegerNotIncluding10>. You want a Box<Integer> instead.
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...
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...
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...
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 =...
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)) ...
.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);...
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...
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)...
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...
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...
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" ...
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,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...
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...
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,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.
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,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 ...
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...
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) ...
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,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 ...
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...
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...
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), _...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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....
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...
\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*....
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....
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 |...
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 }...
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...
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...
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] == "") { .... ...
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);...
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....
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 ......
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,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...
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...
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 = {...
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...
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...
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") ...
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....
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 ...
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,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.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...