Replace filter: Custom-delimited record

[dfhtextpipe]

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

[DataMystic Support]

This is improved for 10.7.

[dfhtextpipe]

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
        }

[dfhtextpipe]

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

[DataMystic Support]

Thanks David - this is a great idea!