AutoHotkey Community

[Carcophan]

I am using COM to read some customer information from one of our tools, and a parse loop to split it into individual bits for output/reporting ect.

---> My issue is, sometimes the 4th field of the msgbox or report data will contain all of the parse data. This only happens if field 4 is blank. If it is blank, it instead gets filled with ALL the information. If it is NOT blank, it contains what it should naturally contain.

[sinkfaze]

Hmm...maybe this?

[Carcophan]

The actual code you posted gives an error becuase it is missing an ')', I changed it to Info .= (A_Index=1 ? "" : "`n") ? A_LoopField which also doesn't work, it makes 1,2,3 and 4 empty, as oppsed to 3 or 4.

[SoLong&Thx4AllTheFish]

For what its worth (haven't looked at your question really) for parsing loops I ALWAYS use

[sinkfaze]

I corrected the code Carcophan, try it again.
_________________
Try Quick Search for Autohotkey or see the tutorial for newbies.

[Carcophan]

[sinkfaze]

Sorry Carcophan, it needed correcting again (off day ), try it again. All this is:

[Carcophan]

[Carcophan]

So I've finally had a chance today to play around with this.

Sadly the latest example also does not work. I did notice though, when rereading your comment:

[sinkfaze]

Can you post a sample of what's in the variable before you attempt to parse it (both with and without the blank field)?
_________________
Try Quick Search for Autohotkey or see the tutorial for newbies.

[Carcophan]

We have our famous tool, that I have hinted at various times in the past. The Kiosk style IE page, that is a skin for an old DOS-type database.
Data is all over the place, but house/customer info is in a set location. The address/house/customer info is also always (luckly) in the same order.

Information in our tool, displays as follows::
Name (Line1 = First/Last)
Address (Line2= Street)
Address (Line3= TOWN/zip, unless it is an appartmnet, then it is the appt #)
Address (Line4= TOWN if there was an appartment number in line 3, BLANK if no apparment)


Rough sample IF A_INDEX=4:

1.) Joe Blow
2.) 123 Fake St
3.) Apt #7D
4.) Townsville, XY 12345
5.) Account number
6 - 10) Whatever else, working with/without index=4

1.) Joe Blow
2.) 123 Fake St
3.) Townsville, XY 12345
4.) <contains data for fields 5, 6, 7, 8 ,9 and 10>
5.) Account number
6 - 10) Whatever else, working with/without index=4


Changing a_Index to 3, removed an/all content that would be displayed in line #4. So in theory it would cut off the persons Town name/state/zip, just becuase they do not live in an appartment building.

[sinkfaze]

This one is bizarrely more difficult than it looks. A parsing loop is not sufficient, since it will only loop for the number of delimiters found; similar a while loop will also not work for the same reason. If the number of loop iterations is less than the amount of variables needed the task simply becomes too cumbersome to work with well. What you have to do is create a pseudo while loop that can work based off of the number of delimiters in the file (in this case, newlines). If there are 4 newlines then there is data in the apartment field; if only three it is blank, Here are two tests of the code:

[Carcophan]

Dumb question, but can I just plug in my 'clipboard' variable inplace of the 'var' variable?

and I should also be able to .= the values of my other regex stuff, output 'line1, line2, line3, line4, regexVar1, regexVar2, var3...'


I didn't think it would turn into something so complicated. Thanks for all your time with this boss. I can't test this till tomorrow again, but it makes a lot of sense the way you layed it out.

[sinkfaze]

Yes you could just replace var with Clipboard to test.

[Carcophan]