Search found 15 matches

by LindaO
19 May 2021 14:29
Forum: General Usage
Topic: Extracting text from a string
Replies: 9
Views: 2289

Re: Extracting text from a string

Thanks Mike. I spent a lot of my time RTBM when I first started in IT/programming quite a few years ago and had read up on the different text functions in FH before posting. Must having been having a senior moment, as totally misunderstood the TextPart function. Hence the stupid question! I could ha...
by LindaO
18 May 2021 15:20
Forum: General Usage
Topic: Extracting text from a string
Replies: 9
Views: 2289

Re: Extracting text from a string

That worked - thanks so much. You have no idea how long I have spent on this - tried to make something very simple extremely complicated.

Regards,

Linda.
by LindaO
18 May 2021 15:17
Forum: General Usage
Topic: Extracting text from a string
Replies: 9
Views: 2289

Re: Extracting text from a string

Ah, penny just dropped the -1 might work. Thanks will try it.
by LindaO
18 May 2021 15:15
Forum: General Usage
Topic: Extracting text from a string
Replies: 9
Views: 2289

Re: Extracting text from a string

I have tried TextPart but I can't get it extract at the last position as number of last position varies - if value was in the first position in the string it would be a problem. Sometimes its the obvious that the solution but so far I am missing how to resolve. I have tried various text functions pl...
by LindaO
18 May 2021 14:35
Forum: General Usage
Topic: Extracting text from a string
Replies: 9
Views: 2289

Extracting text from a string

Hello, Be grateful for any help please? I am trying to extract the last place name from an address field using a query. Each part of the address is separated by a comma but the number of "parts" to the address can vary as can the number of characters in each "part". For example, "24 High Street, The...
by LindaO
28 Aug 2019 11:49
Forum: General Usage
Topic: Sibling query help
Replies: 8
Views: 5066

Re: Sibling query help

Sorry for delay in thanking you both but been working at turning out more sophisticated custom queries now I have an idea of what FH queries can and can't do. Still thinking about a plug in but won't be over next month or so.

Thanks and regards,

Linda.
by LindaO
25 Aug 2019 09:15
Forum: General Usage
Topic: Sibling query help
Replies: 8
Views: 5066

Re: Sibling query help

Hello Mike, Thanks for the sibling query which I will extend to cover my data needs. It does the hard work of identifying the sibling who is also the "record owner" and will make it easier when using the data outside FH. Looking at the expressions you have developed it gives me many more ideas for b...
by LindaO
24 Aug 2019 13:24
Forum: General Usage
Topic: Sibling query help
Replies: 8
Views: 5066

Re: Sibling query help

Jane, Thanks for your reply. Not had a go at plugins yet but maybe this is my opportunity! If there is no solution with a query will probably, at least in the short term, output a text file and manipulate it outside FH with code. I know my data quite well so know what RecordId's to check to see if m...
by LindaO
24 Aug 2019 12:16
Forum: General Usage
Topic: Sibling query help
Replies: 8
Views: 5066

Sibling query help

I have been trying, without success, to produce a query to output the siblings for every RecordId in FH. I have experimented with outputting data in linear format, viz RecordId, Sibling1, Sibling2.... etc which produces 1 row per RecordId and also stacked format, viz RecordId, SiblingName, Relations...
by LindaO
21 Sep 2011 16:32
Forum: The Lost Posts Archive
Topic: FH stopped working
Replies: 103
Views: 51159

FH stopped working

McAfee updated and FH working again!

Regards,

Linda
by LindaO
20 Sep 2011 17:15
Forum: The Lost Posts Archive
Topic: FH stopped working
Replies: 103
Views: 51159

FH stopped working

Hmmmm...well I shut down FH and then restarted it and the problem is back again - shuts down after approx 1 min!  Grrrrr!  I have a call reference number from BT so will call them again - but probably tomorrow now!

Regards,

Linda.
by LindaO
20 Sep 2011 16:54
Forum: The Lost Posts Archive
Topic: FH stopped working
Replies: 103
Views: 51159

FH stopped working

Well done as advised by BT and so far so good - FH been up and running for nearly 10 mins so far. For info - removed McAfee, restarted as need by McAfee but then did a cold reboot to make sure McAfee was removed from memory before doing a McAfee reinstall. So far so good, so fingers crossed...but le...
by LindaO
20 Sep 2011 16:19
Forum: The Lost Posts Archive
Topic: FH stopped working
Replies: 103
Views: 51159

FH stopped working

(a) Exactly what McAfee products you have.   BT NetProtect Plus consists of McAfee Security Centre V10.5 Build 103.5.240;  McAfee Virus Scan v14.5 Build 14.5.130 (DAT date 19/09/2011), McAfee Firewall V11.5 Build 11.5.141, McAfee Site Advisor v3.4 Build 3.4.0.143, McAfee Parental Controls (not confi...
by LindaO
19 Sep 2011 16:51
Forum: The Lost Posts Archive
Topic: FH stopped working
Replies: 103
Views: 51159

FH stopped working

Rolling back the system to a restore point on 15 Sep and disabling McAfee automatic updates has worked successfully for just over 24 hours.  Now though McAfee has re-enabled automatic updates without me telling it to and FH has stopped working again!  Annoying but think I am going to wait this out n...
by LindaO
18 Sep 2011 14:09
Forum: The Lost Posts Archive
Topic: FH stopped working
Replies: 103
Views: 51159

FH stopped working

I have the same problem as everyone else with FH only running for seconds and then exiting - I am running Vista and McAfee. I set McAfee not to update automatically and did a Windows system restore to 15 Sept and after restore made sure McAfee still wouldn't automatically update. All seems to be ok ...