[Yutaka Emura]

Please write an example to each of your question (1 and 2) so that it will be easier to write an answer.

As for Time calculation, Scenario 1, If you want to add 5.50 seconds to each time in your example, you can open the Replace dialog box, and enter:

Find:
(\d\d):(\d\d)\.(\d\d)

Replace with:
\J nAdd=550; n=parseInt("\1")*6000+parseInt("\2")*100+parseInt("\3")+nAdd; s=("0000"+(n % 6000)).substr(-4); ("00"+parseInt(n/6000)).substr(-2)+":"+s.substr(0,2)+"."+s.substr(2);

and make sure the Regular Expressions option is turned on.

You can replace nAdd=550 with the actual time you want to add in 10 milliseconds.

[Yutaka Emura]

Hello,
Can you please write when the flashes occur? Please write a procedure to reproduce the issue.
Thank you,

[Yutaka Emura]

We’ve just released v22.0.901.

– Added the Sort/Remove Duplicate split strings in Selection, Sort Columns, and Manage Columns command.

[Yutaka Emura]

Is the Fast Binary Comparison option on?

[Yutaka Emura]

If you clear the Ignore Case option in the Sort page of the Customize dialog box, the result will be exactly like this.

[Yutaka Emura]

Please write an example how this works, and why you need this type of sort.

[Yutaka Emura]

I think you would like to use the Remove Newline Characters or Join Lines command.

[Yutaka Emura]

OK. I now understand your question.

Currently, you can select a CSV mode (for instance Tab-separated, NOT Comma-separated) so that only one column should exist. Select the only one column, select the Split Columns command, then select (None), enter the Separator (Comma + Space in this case), set the Sort split strings option, and select a desired sort criterion.

Alternatively, you can split to multiple lines by replacing Comma + Space with a newline, sort, and then replace a newline with Comma + Space to restore newlines.

I will think about a new command in the future.

[Yutaka Emura]

I am still not sure if I understand your question, but if you are talking about a nested CSV like this page:
https://www.emeditor.com/text-editor-features/more-features/nested-csv/

and if you would like to sort, for instance, “apple;banana;cherry“, you can select “Split Columns” while selecting the second column, select (None), enter the separator (a semicolon in this case), set the Sort split strings option, and select a desired sort criterion.

[Yutaka Emura]

This macro will sort (A to Z, case insensitive) by row level at the current cursor (or selected cell) line. You can use this macro to develop further for different sort criteria.

function SortOneColumn( yLine )
{
    count = document.GetColumns();
    arr = new Array(count);
    for( i = 0; i < count; ++i ) {
        s = document.GetCell( yLine, i + 1, eeCellIncludeNone );
        arr[i] = { name: s, col: i };
    }
    arr.sort( function( a, b ) {
      var nameA = a.name.toLowerCase();
      var nameB = b.name.toLowerCase();
      if( nameA < nameB ) {
        return -1;
      }
      if( nameA > nameB ) {
        return 1;
      }
      return 0;
    });

    bSorted = false;
    for( i = 0; i < count; ++i ) {
        if( arr[i].col != i ) {
            document.MoveColumn( arr[i].col + 1, arr[i].col + 1, i + 1 );
            bSorted = true;
            break;
        }
    }
    return bSorted;
}

yLine = document.selection.GetActivePointY( eePosLogical );
while( SortOneColumn( yLine ) );

I am not sure what you mean by 1. On delimiter level.

[Yutaka Emura]

You can write a macro to save a file as GB2312 (my sample as below), and then use the Advanced Open on the File menu or the Run with Temporary Options on the Macros menu to specify all the files to convert.

document.Encoding = 936;  // Chinese Simplified (gb2312)
s = document.FullName;
nExt = s.lastIndexOf( "." );
nBackslash = s.lastIndexOf( "\\" );
if( nExt == -1 || nExt < nBackslash ) {
	nExt = s.length;
}
s = s.substr( 0, nExt ) + "-gb2312" + s.substr( nExt );
document.Save( s );

[Yutaka Emura]

The Fuzzy Matching and Regex are mutually exclusive; they can’t be used together. However, the Fuzzy Matching and Escape Sequence can be used together.

[Yutaka Emura]

1. The Fuzzy Matching option becomes grayed out to show it can’t be combined with the Regular Expressions option.

2. You can set the Skip this dialog box next time option in the Fuzzy Matching dialog box, or clear the Show the Fuzzy Matching Options dialog box when selecting Fuzzy Matching option in the Search page of the Customize dialog box.

[Yutaka Emura]

I did exactly the same way as the screenshot shows — “CR @”.
I don’t believe it’s an issue, but can you please try saving both your sample and linked file as UTF-16 with BOM, and see if you can still reproduce the issue?

[Yutaka Emura]

I downloaded your files and tested, but I still couldn’t reproduce the issue.

[Yutaka Emura]

I am not sure if I understand your question. Please write a simple sample with a simple regex to reproduce the issue.

[Yutaka Emura]

The Replace in Files dialog box does NOT include the Extract button. You can use the Find in Files dialog box to open all files containing the search string first, and then use the Replace dialog with the Search All Documents in the Group option.

[Yutaka Emura]

Please email me all your files after zipped so I will look into the issue.

[Yutaka Emura]

Is your linked file saved as UTF-8?

[Yutaka Emura]

I couldn’t reproduce the issue. Which version of EmEditor are you using? Are you using the default regex engine (Boost.Regex)? Did you make any changes in the Advanced dialog box?

[Yutaka Emura]

Please simplify your samples as much as possible while you can still reproduce the issue, and clarify the last part of your question (after “I tried using negative lookahead like this”). Please add explanations why you believe your regular expression should not match or does not help.

[Yutaka Emura]

The Extract button is available in Find in Files dialog box. Are you using the latest version of EmEditor?

[Yutaka Emura]

I’ve reproduced these issues, and they will be fixed on v21.9.915. Thank you!

[Yutaka Emura]

Does this mean everything is resolved now?

[Yutaka Emura]

v21.9.914 allows you to specify a string as well as a character range.
Thanks,

[Author]

Posts