DataMystic

Posted: **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

Posted: **Thu Apr 26, 2018 10:36 pm**

This is improved for 10.7.

Posted: **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
        }

Posted: **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

Posted: **Wed Mar 04, 2020 4:30 pm**

Thanks David - this is a great idea!

DataMystic

Replace filter: Custom-delimited record

Replace filter: Custom-delimited record

Re: Replace filter: Custom-delimited record

Re: Replace filter: Custom-delimited record

Re: Replace filter: Custom-delimited record

Re: Replace filter: Custom-delimited record