Hot answers tagged

1

I found this to test the String =IF(AND(ISNUMBER(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))),A1,"") and placed the code to locate the first string and second string. Here is the entire thing. I don't know much about this, just pieced a bunch of different little snippets. I am now hoping that someone can help me streamline this. ...


1

Since you asked for an example of a VBA solution, this will print the first only numeric sub-string in the cell to the right - Option Explicit Public Sub ExtractStreetNumber() Application.ScreenUpdating = False Const nullCharacter As String = " " Dim subString As String Dim fullAddress As String Dim subStringArray() As String Dim ...


1

find and size The default unit of size for the find command is a block of 512 bytes. Confusingly, when you specify a file size in units such as kB, MB or GB, find rounds up the file size and uses that figure before testing against the size predicate. E.g., when the size predicate is expressed in GB (-size -1G), the size of a 900MB file is rounded up to ...


1

There are multiple ways this can be done. The combination of find -print0 and xargs -0 is powerful and safe to work in combination with sed -z (using NULL as line delimiter): find /home/ec2-user/backups -type f -mtime +3 -print0 |\ sed -z 's/^.*\?backups/s3:\//' |\ xargs -0 -n 1 s3cmd del Since s3cmd does not (yet) support deleting multiple files, ...



Only top voted, non community-wiki answers of a minimum length are eligible