Search found 15 matches
- 19 May 2021 14:29
- Forum: General Usage
- Topic: Extracting text from a string
- Replies: 9
- Views: 2294
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...
- 18 May 2021 15:20
- Forum: General Usage
- Topic: Extracting text from a string
- Replies: 9
- Views: 2294
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.
Regards,
Linda.
- 18 May 2021 15:17
- Forum: General Usage
- Topic: Extracting text from a string
- Replies: 9
- Views: 2294
Re: Extracting text from a string
Ah, penny just dropped the -1 might work. Thanks will try it.
- 18 May 2021 15:15
- Forum: General Usage
- Topic: Extracting text from a string
- Replies: 9
- Views: 2294
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...
- 18 May 2021 14:35
- Forum: General Usage
- Topic: Extracting text from a string
- Replies: 9
- Views: 2294
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...
- 28 Aug 2019 11:49
- Forum: General Usage
- Topic: Sibling query help
- Replies: 8
- Views: 5067
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.
Thanks and regards,
Linda.
- 25 Aug 2019 09:15
- Forum: General Usage
- Topic: Sibling query help
- Replies: 8
- Views: 5067
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...
- 24 Aug 2019 13:24
- Forum: General Usage
- Topic: Sibling query help
- Replies: 8
- Views: 5067
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...
- 24 Aug 2019 12:16
- Forum: General Usage
- Topic: Sibling query help
- Replies: 8
- Views: 5067
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...
- 21 Sep 2011 16:32
- Forum: The Lost Posts Archive
- Topic: FH stopped working
- Replies: 103
- Views: 51284
FH stopped working
McAfee updated and FH working again!
Regards,
Linda
Regards,
Linda
- 20 Sep 2011 17:15
- Forum: The Lost Posts Archive
- Topic: FH stopped working
- Replies: 103
- Views: 51284
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.
Regards,
Linda.
- 20 Sep 2011 16:54
- Forum: The Lost Posts Archive
- Topic: FH stopped working
- Replies: 103
- Views: 51284
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...
- 20 Sep 2011 16:19
- Forum: The Lost Posts Archive
- Topic: FH stopped working
- Replies: 103
- Views: 51284
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...
- 19 Sep 2011 16:51
- Forum: The Lost Posts Archive
- Topic: FH stopped working
- Replies: 103
- Views: 51284
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...
- 18 Sep 2011 14:09
- Forum: The Lost Posts Archive
- Topic: FH stopped working
- Replies: 103
- Views: 51284
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 ...