Questions tagged [emeditor]

EmEditor is a fast, lightweight, yet extensible, easy-to-use text editor for Windows.

162 questions
3
votes
3 answers

It is possible to add numbers from 0-99 at the end of all line?

Hello i got something in format: Marcin:Marcin Pawel:Pawel i want to add numbers between 0-99 at the end of line so result should be like: Marcin:Marcin1 Marcin:Marcin2 .. Marcin:Marcin99 Pawel:Pawel1 Pawel:Pawel45 .. Pawel:Pawel99 etc. Does…
3
votes
3 answers

Regex : Keep text between 2 keywords but only if another keyword exists inside them

I am using emeditor and I am trying to isolate about 2 millions articles containing keyword3 from a french wikipedia dump .xml file (20GB, 338 millions rows, 4.8 millions articles in total). I would like to keep the text contained between 2 keywords…
edmisnu
  • 45
  • 5
3
votes
2 answers

Convert first lowercase to uppercase and uppercase to lowercase (regex?)

I have a huge file in this layout: world12345:Betaalpha world12344:alphabeta world12343:ZetaBeta world12342:!betatheta I need to convert the first lowercase letter after the ":" to uppercase and the first uppercase letter to lowercase.…
2
votes
1 answer

Remove/change red underline in columns

EmEditor CSV mode shows a red underline to fill the remainder of a column when a cell's text is not wide enough. Does anyone know how to either remove or change this?Example of red underline buffering
2
votes
1 answer

In EmEditor: How to sum up values from two column's cell (in the same row) and store the results in third column?

I have a pipe separated file: Col1| Col2| Col3 12 | 10 | 54 | 17 | How I can get in the sum ( 22 & 71 ) in the Col3 ? Is there a build-in Function for this kind of operation ?
XPB
  • 23
  • 3
2
votes
2 answers

how to remove some strings in emeditor(Regex )

i want to remove some string and save other part of string that i need from a file with emeditor .. file line like :…
justine
  • 21
  • 2
1
vote
1 answer

EmEditor Macro to Save Large Files from 0 to 100000

Trying to set up a macro for EmEditor to execute the following steps that I could otherwise do manually. open file view > large file controller set To=1000 Click Apply Click Save Opened Portion As... Enter TestMacro and Save I'm using: EmEditor…
MMsmithH
  • 323
  • 1
  • 8
1
vote
1 answer

Em editor phone number formatting

I have phone number/number look like this xxxxxxxxxx I want to turn it to this formatting on em editor xxx-xxx-xxxx Basically 3 digit -3 digit -4 digit like an USA phone number. How can I do it? Formatting phone number
1
vote
1 answer

How to sort emails data using its color codes in emeditor

I have this little challenge. I want to ask, how do i sort the emails using the color code (light green) as stated in this picture here I have tried to remove the non emails by scrolling through, but i need a solution that can make it a one click…
1
vote
1 answer

How to call external JS library using \J syntax

I'm trying to encrypt one column of my very big CSV file. So I'm using JavaScript as the expression on the "Find and Replace" dialog of EmEditor: https://www.emeditor.org/en/howto_search_replacement_expression_syntax.html I've correctly identified…
J. Mag
  • 11
  • 1
1
vote
1 answer

Is it possible to specify the beginning and end points of the file to be opened before opening?

Is it possible to specify the beginning and end points of the file to be opened before opening? For example, if I have a file of size 1234567890 bytes and I want to open it from 2345777 to 2345888, how do I set these values before opening it, so…
lyrically wicked
  • 1,185
  • 12
  • 26
1
vote
1 answer

In EmEditor, how to normalize multiple consecutive whitespaces to 1 in multi-column file

When I search for \s\s+ to replace with “ “, lines in column 1 and 2 get concatenated, unless text line in column 1 ends in punctuation mark. Please provide expression to normalize whitespaces w/o losing multi-column data structure.
1
vote
1 answer

EmEditor Filtering and Searching Column Separator / Filtering and Inserting a Separator into Multiple Rows of CSV

I have a table 20 columns wide and millions of rows long. The information is public and voluntarily made public and disseminated publicly. I am an attorney, and I do not believe there can be any real concern about showing this data. In this…
1
vote
2 answers

How To Get The Number Of Days Between Two Dates In Emeditor

In Emeditor, how do i get the number of days between 2 date columns? Example: Column A: 25/11/2022 Column B: 29/11/2022 -> Column C: 4 days
1
vote
1 answer

Emeditor: run a macro for all file inside a folder?

How to run a (previously recorded) macro for all files inside a folder ? Example : I have recorded a macro that is working correctly for an opened html file. I have saved the macro as "test.jsee". I have a folder in my computer named…
edmisnu
  • 45
  • 5
1
2 3
10 11