AutoHotkey Community

I'd like to remove all of the carriage returns and field names so that I just have the data. I will later replace the AAAA with commas.

I've been working on this for a few hours, searching the forums, regex tutorials, the AHK manual and testing. I think I'm close, but I can't get it to work. Any help would be greatly appreciated.

Thanks,
Pete

Is this what you want?

Not regex but it worked. If you want the " gone around the IPs and stuff to just add in this line after the StringLeft line:
StringReplace, results, results, ",,all ***this is not tested but I am pretty sure it will work***

You need to run two unique RegExReplace calls:

_________________

Try Quick Search for Autohotkey or see the tutorial for newbies.

Thank you for all of the replies. a4u, That seems to do everything, but it still leaves either a carriage return or line feed between each result. Sinkfaze, that works great for my current problem, though then I realized I will also need to parse the same data a different way as well. These are the results of WMI queries that I'm trying to reformat into sqlite statements. Is there a way to insert a string of characters such as $# between the 2 records in the example? I will replace these later with my sqlite query.

I've spent a few hours trying to learn more about regex, but am still having trouble figuring out how your regex works. Do you have any suggestions for good resources to learn regex.

Thanks,
Pete

How about:
http://www.autohotkey.com/docs/misc/RegEx-QuickRef.htm
http://www.autohotkey.com/wiki/index.ph ... =Tutorials
http://www.autohotkey.com/forum/topic43197.html

Thanks a4u, Yes that works well too for my first problem. I'm assuming that the single regexreplace will be faster than the one that sinkfaze posted? Not that it will probably matter much at this point because the amount of data that I'm searching through is fairly small, but just for future reference. I'm reading through Sinkfaze's excellent tutorial now that you linked to and I'm realizing how powerful regex is. I'm pretty sure I will be able to figure out my second question on my own after reading the tutorial. I will post the answer here if/when I come up with it.
Thanks,
Pete

Woohoo! This is what worked. Thank you everyone. Turns out I didn't need regex for the second part of this task (or first depending on how you read it), but I've learned a great deal more about it with your help.



I will still need to trim a little and add my sqlite syntax, but this will work.