Re: URL File extra spaces

2013-03-09 Thread Jim MacConnell
No idea. In my case, there was a space "before" the first char. Took me a while to realize that. Maybe the breaks filter without spaces? Sent from my iPad On Mar 9, 2013, at 7:32 AM, Thomas McGrath III wrote: > I don't know what the heck is going on here. I can't even filter the > resulting

Re: URL File extra spaces

2013-03-09 Thread Thomas McGrath III
Peter, I realized after I sent that email that I needed replace instead of filter. But of course that is not the cause of the issue. I think it must be a UTF issue. For now I came up with another workaround. Thanks Tom -- Tom McGrath III http://lazyriver.on-rev.com mcgra...@mac.com On Mar 9,

Re: URL File extra spaces

2013-03-09 Thread Thomas McGrath III
Scott, After changing to binfile it loads without the extra spaces. But then I run into other issues using contains etc. on the returned text. So I had to come up with a bit of code to strip out what I need etc. But I think It must be the UTF issue. Tom -- Tom McGrath III http://lazyriver.on-r

Re: URL File extra spaces

2013-03-09 Thread Peter M. Brigham
I recall a thread on this problem a year or two ago, can't find in in Gmane, though. It did have to do with UTF-8 vs UTF-16. You have to unidecode the text then uniencode it again (or vice versa) to change it from UTF-16 to UTF-8 (or vice versa). Sorry I can't recall the details. As far as the

Re: URL File extra spaces

2013-03-09 Thread Peter Haworth
Hi Tom, I think the filter command works on complete lines, not characters. Maybe try "replace space with empty in " instead. Not sure why the spaces appeared in the first place but, as someone else suggested, perhaps using binfile instead of file might fix it. Pete lcSQL Software

Re: URL File extra spaces

2013-03-09 Thread Scott Rossi
This is really dumb, but have you tried reading as binary (binfile) instead of file? I recently found that LiveCode was not seeing returns in text files saved out of LiveCode, and opening using binfile seems to have solved my issue (though don't know why). Regards, Scott Rossi Creative Direct

Re: URL File extra spaces

2013-03-09 Thread Jim MacConnell
Encountered this for first time last week when file exported by script from ERP system was different than a manual export. Issues was UTF-8 vs UTF-16 I believe. I didn't have to deal with it though. Simply pointed out the issue to the database guy and he changed the export format. Solved my prob

Re: URL File extra spaces

2013-03-09 Thread Thomas McGrath III
I don't know what the heck is going on here. I can't even filter the resulting field without spaces. filter field "Input" without spaces yet the field still has the spaces I then in a button tried with one of the spaces selected and get 32 so I know it's a space: answer charToNum(the selected