1 Reply by Eleanor Knott

  • Eleanor Knott
  • Veteran
  • Offline
  • Registered: 21-01-2009
  • Posts: 93

Re: Carriage returns in comments

Please tell me, why is Recorder insisting on putting carriage returns after every line in the comments?  It does this in all of the comments (in Event, Sample and Taxon Occurrence) and is very annoying, as it causes problems when I import the data into MapInfo.  I have to spend a lot of time removing carriage returns.

Ellie

Eleanor Knott
Technical Co-ordinator
Devon Biodiversity Records Centre
C/o Exeter Central Library
Castle Street
Exeter
EX4 3PQ
Tel. (01392) 274128

Eleanor Knott
Devon Biodiversity Records Centre

2 Reply by Graham Hawker

  • Graham Hawker
  • Veteran
  • Offline
  • Registered: 31-05-2006
  • Posts: 160

Re: Carriage returns in comments

We have had a problem with this in the past - not sure if it's people pressing return when entering comments. Anyway Mike Weideli did some work for us earlier this year and he kindly supplied an sql query to run against the database which strips carriage returns.

I'm sure he would supply it to you as well.

Graham Hawker
Thames Valley Environmental Records Centre

3 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Carriage returns in comments

If you install the NBNExpoter addin you will get a User Defined function dbo.nbn_exchange_strip_LFCR. This can be used in xml reports to remove the Line Feed and CR. The comment fields in R6 are in rtf format so whenever they ae used in reports you have to remove the formatting.  The  following will remove both the formattting and the CR/Line Feeds.

dbo.nbn_exchange_strip_LFCR(dbo.ufn_RtfToPlaintext(TOCC.comment)) as Comment,

Mike Weideli

MikeWeideli's Website