Newbies whitters23 Posted December 13, 2008 Newbies Share Posted December 13, 2008 Hi, Just joined the forum so not sure if this is exactly the correct place to post this so apologies in advance if it is wrong. I'm using the troi url plugin to down load investment fund data from the following address: http://www.trustnet.com/ut/funds/perf.aspx?txtSearch=&sort=5&ss=0&txts=&txtss=&columns=&page=0&booIMA=0®1=all&sec=all&ima=all&unit=all&type=all when the html arrives in the field in FileMaker, some of the characters are squares (which i believe are acsii character). how can i find out what these character are and then substitute them with carrage returns so a new line in the text is created? if someone could give me a step by step process to resolve this including any additional software i might need then that would be ideal. Hope someone can help me or point me a direction to resolve this. thanks Whitters Link to comment Share on other sites More sharing options...
aldipalo Posted December 13, 2008 Share Posted December 13, 2008 Welcome to the Forum. Have you written to Troi Tech Support? I've found most plug in developers to be most helpful with their product. Usually respond within 24 hours. hth Link to comment Share on other sites More sharing options...
Newbies whitters23 Posted December 13, 2008 Author Newbies Share Posted December 13, 2008 Hi, An email went to the developers this morning, but as it's the weekend I'm not too hopeful of getting anything back before Monday so i thought I'd give the forum a go and see if i could get it resolved over the weekend as I'd like to re-start downloading the fund info on Monday as I've missed a few days now. Whitters Link to comment Share on other sites More sharing options...
Newbies whitters23 Posted December 13, 2008 Author Newbies Share Posted December 13, 2008 I stand corrected - while I was writing back to the forum the guys @ Troi came back with some advice. Hopefully that will sort things out. Link to comment Share on other sites More sharing options...
comment Posted December 13, 2008 Share Posted December 13, 2008 To identify the character, you could copy it and paste it into an application that can identify characters (I don't know which one that would be on Windows). However, identifying it won't help much. A temporary patch (or a permanent one, if you cannot get this resolved) would be to paste the offending character into a global text field, then clean the text by: Substitute ( text ; gBadCharacter ; ¶ ) I wouldn't recommend pasting the character directly into the formula itself, because with some control characters this may cause Filemaker to crash. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5619 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now