Replace List filter - pasting text containing a tab in the replace field

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply
DFH
Posts: 705
Joined: Sun Dec 09, 2007 2:49 am
Location: UK

Replace List filter - pasting text containing a tab in the replace field

Post by DFH » Thu Dec 22, 2016 10:47 pm

This is not a major issue, but still worth reporting.

Strange things can occur when you Paste from clipboard text containing more than one tab separator. e.g.
  • a b Z
where both the separators are tabs not spaces.
This displays as bZ in the Replace field, yet copying it to the clipboard shows the tab is still there.

After a Swap, the Find column ends up displaying bZ, and copying it to the clipboard shows the tab is still there.
Yet pasting this back from the clipboard, results in b in the Find field and Za in the Replace field.

I guess this is wholly logical, but it is something the filter design has not really anticipated.

Something to consider?:
After a Paste from clipboard, converting any such extra tabs into the pattern \t in the Replace field.

Regards,

David

User avatar
DataMystic Support
Site Admin
Posts: 2211
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Replace List filter - pasting text containing a tab in the replace field

Post by DataMystic Support » Fri Jan 06, 2017 7:53 am

Thanks David - I understand the issue, but I would prefer to leave the text unchanged for future copy/paste operations rather than change it to a \t. This would also happen with CSV data.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests