Reputation
1,180
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
6 11
Newest
 Organizer
Impact
~114k people reached

Aug
19
comment Batch file to create .7z archive for each file (in folder/subfolder) to a new destination (folder/subfolder structure)
Why didn't you say so! AHK can do this whole thing better. Any reason that cmd.exe needs to be involved at all?
Aug
19
comment Batch file to create .7z archive for each file (in folder/subfolder) to a new destination (folder/subfolder structure)
One other suggestion: you might also be hitting the limits of what a batch file can do (there's no native way to get the length of a string, for example). Windows Power Shell might be your next step.
Aug
19
comment Batch file to create .7z archive for each file (in folder/subfolder) to a new destination (folder/subfolder structure)
Do you use this batch file from various locations? Or do you always run it for the same pair of directories? If the same pair, there's the %string:~4,3% method of extracting part of a variable (in this case grabbing three characters after skipping the first four characters of %string%).
Aug
19
comment Batch file to create .7z archive for each file (in folder/subfolder) to a new destination (folder/subfolder structure)
%%~pnxi.7z is a shorter way to write that bit, as you're combining the p, n, and x which give you the path, filename, and extension respectively. This is already at the limit of my understanding of batch files. I'm pretty sure that there's a way to capture just the part of the path that you care about.
Aug
18
comment Batch file to create .7z archive for each file (in folder/subfolder) to a new destination (folder/subfolder structure)
I guess I really meant ("%DestinationDrive%%%~pni.7z")
Aug
18
comment Batch file to create .7z archive for each file (in folder/subfolder) to a new destination (folder/subfolder structure)
Where you specify the destination 7z archive in your first line ("%%~i.7z"), why don't you construct the destination with something like ("%DirectoryDestination%%%~ni.7z")?
Jul
16
comment Regex for “Delete everything going forward but only up until start of [Expression]”
SU isn't the site to hire people to write Regex patterns for you. You should try using a site like Debuggex to figure out what Regex pattern will do what you need: debuggex.com/r/Su3W9RkG3by7ZlZt
Jul
6
comment Automatically updating graph that only picks out information per date
please edit your question based on your comment responses. You'll get the best answers if readers can see the core issue immediately upon reading your question.
Jul
6
comment Automatically updating graph that only picks out information per date
I just noticed that you want to pull all three rows that match the date. I'll have to change my answer to match that.
Jul
6
comment Automatically updating graph that only picks out information per date
Have you tried a Scatter chart? Where does that fall short?
Jul
6
comment Automatically updating graph that only picks out information per date
If three lines are added for a day, do you only care about the most recent? Or do you want to graph the sum of the three?
Jul
6
comment Automatically updating graph that only picks out information per date
Welcome to SU. Please clarify your question. What software (and version) are you using to create a graph? What is the best solution you've devised so far? What do you want the graph to show (such as, "daily values over the last month")?
Jul
6
comment Using wildcard in notepad++ to replace a very specific range of entries/values
I disagree with @barlop: I don't believe the question emphasized making the change to XML files in batch. The question did, however, emphasize using Notepad++. While barlop's answer may be the better one (recommending the right tool for the job), Xupicor's answer is not a bad one.
May
15
comment Excel 2010 Advanced Filter issue
Oh, I think I just caught something: you're okay with AAA or with 1A2B, but you don't want to see both.
May
15
comment Excel 2010 Advanced Filter issue
For example, here's the simple mockup I did based on reading your question: dropbox.com/s/6mb3nsbbxm7oa5d/AdvancedFilter.xlsx?dl=0
May
15
comment Excel 2010 Advanced Filter issue
I was just thinking that you might mock up your table in your question. If you use the code formatting option, the font will be monospaced, so you can get your columns to line up. Otherwise, your options are a publicly shared file on something like Dropbox or a screenshot.
May
15
comment How to reload a bak of etc/apache2/httpd.conf in terminal after bad changes made with Vim?
@TD.512 is saying that "/Users/catherinelegna/Desktop/Capture d’écran 2015-05-15 à 15.20.03.png" doesn't do us any good. Please edit your question and replace that line with the image itself. Or upload the image to an image-sharing site and link to it.
May
15
comment Excel 2010 Advanced Filter issue
When I set up an Excel spreadsheet with the example criteria, it behaves as expected. You might be doing something that only becomes clear once we can see what you're doing instead of imagining it.
May
15
comment Excel 2010 Advanced Filter issue
Can you provide the simplest example you can test in Excel that produces this behavior?
Apr
24
comment Properly extracting from an array
Also, if you're using PowerShell to read a CSV file into a PowerShell array, what's wrong with $project = Import-Csv "project.csv" ?