Replace filter: Custom-delimited record

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Replace filter: Custom-delimited record

Post by DFH » Fri Feb 16, 2018 3:27 am

The UI for the Replace filter: Custom-delimited record has no means to define the custom delimiter!

To the right of the Find type selector, the UI displays "(from search field)Delimiter: Text qualifier:" but there's no edit field to set either of these.

This is a poor show compared to the Restrict fields filter that has a good UI that covers all these things.

Furthermore, the context help for all these Replace filters is misdirected and/or missing.

Best regards,

David

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

Re: Replace filter: Custom-delimited record

Post by DataMystic Support » Thu Apr 26, 2018 10:36 pm

This is improved for 10.7.
Regards,

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads

DFH
Posts: 956
Joined: Sun Dec 09, 2007 2:49 am
Location: UK

Re: Replace filter: Custom-delimited record

Post by DFH » Tue Mar 03, 2020 12:57 am

I've just inserted a Replace filter and then used the Find type drop-down to select Custom-delimited record.

There is still no UI control to defined the custom delimiter character[s].

The same part of the UI pane just has Text qualifier as a label, but no corresponding UI control to specify anything custom.

So contrary to your last response, this is still outstanding.

David

PS The saved search has no JSON parameter corresponding to the custom delimiter.

Code: Select all

        "Search": {
          "search": "X",
          "replace": "Y",
          "ignoreCase": false,
          "patternType": 6,
          "greedy": false,
          "dotMatchesNewLines": true,
          "utf8support": true
        }

DFH
Posts: 956
Joined: Sun Dec 09, 2007 2:49 am
Location: UK

Re: Replace filter: Custom-delimited record

Post by DFH » Tue Mar 03, 2020 5:31 am

OK - there is this obscure description in the Help page for Find & replace.
Customer-delimited record - the find field is automatically set to a pattern that matches records with up to 40 fields - from $1$ to $40$. The delimiter is specified using the first character of the search field. The text qualifies is set using the second character of the search field. e.g. the text ," is used for CSV
After all these years using TextPipe, this is the first time I've come across this. It's so counter-intuitive!

What I was rather thinking of as a better combined UI would be the Convert Text to Columns Wizard in the Microsoft Excel™ Data Menu.

Step 2 of 3 in that UI has a useful additional feature - a tick box labled Treat consecutive delimiters as one
as well as the option to choose {none} as the Text qualifier (besides " or ' ).

David

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

Re: Replace filter: Custom-delimited record

Post by DataMystic Support » Wed Mar 04, 2020 4:30 pm

Thanks David - this is a great idea!
Regards,

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads

Post Reply