[ArthurZ]

Hi,
As far as I can see, there is no way for the search input box to accept a block of formatted text and allow me to execute a substitution.
An example would be to replace
if found then
country := ‘USA’;
RETURN country;
end if;
with
if found then
country := ‘USA’;
RETURN country;
end if;
to
IF NOT FOUND THEN
country := ”;
state_code := ”;
RETURN NEXT;
END IF;

[Yutaka Emura]

Hello ArthurZ,

I am not exactly sure what you would like to do, but it sounds like macros (JavaScript or VBScript) should work for this purpose.

Thank you!

[ArthurZ]

Hi Yutaka,
Try yourself please to replace
major_hwy, –13
second_hwy, –14
latlonconcat, –15
source, –16
quadkey, –17
in

INSERT INTO public.knownpoi(
lat, –1
lon, –2
country, –3
provstate_name, –4
city_name, –5
time_zone, –6
street_name, –7
street_num, –8
postcode, –9
speed_limit, –10
is_urban, –11
private, –12
major_hwy, –13
second_hwy, –14
latlonconcat, –15
source, –16
quadkey, –17
circle_geom
)
with
second_hwy, –13
maj_hwy, –14
latlonconcat, –15
source, –16
in many places at once.
I understood with the macro I need to edit it each time
and also getting
[Window Title]
EmEditor

[Main Instruction]
This feature (recording mouse activities and keyboard input to other applications) might not work under some versions of Windows and security settings. This feature might not be supported in future versions of EmEditor.

[ ] Do not show this message again [Continue] [Cancel]

[Yutaka Emura]

Hello,

I think you want to use the “Multiline” option. Right-click on the “>” button next to the Find text box, and then you can select “Multiline”.

Alternatively, you can use escape sequences and use “\n” as a newline.

If you need to replace multiple patterns, you might want to use Batch Replace by clicking the “Batch” button.

I hope this makes sense to you. Please let me know if you have any further questions.

Thank you!

[Author]

Posts