You are viewing limited content. For full access, please sign in.

Question

Search for Hard Carriage Returns or Tabs

Laserfiche Version 9

Updated December 16, 2016

asked on December 16, 2016 • Show version history

Is there a way to search and find hard carriage returns or tabs embedded into fields like "Subject"? They become a nuisance when exporting lists to Excel. In Word, you can use ^p for a paragraph/line break or ^t to find tabs. Is there a way to do that in LF?

0 0

Replies

replied on December 16, 2016

Probably the easiest way is to use SQL directly:

select a.tocid, a.str_val, b.name 
from propval a inner join toc b
	on a.tocid = b.tocid
where a.str_val like '%' + CHAR(10) + '%'
or a.str_val like '%' + CHAR(13) + '%'
or a.str_val like '%' + CHAR(9) + '%'

Tab = char(9)

Line feed = char(10)

Carriage return = char(13)

Then maybe pair it with a Workflow replaces those characters with spaces or something similar.

1 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked December 16, 2016
Updated December 16, 2016
122 views