Find replace with itiration

Neil Schipper

@nagarajgouda-patil Do you know how to perform the text concatenate operation in Excel?

If you do, what would be the advantage of doing a F&R in Npp when you can construct the needed text in Excel?

If you don’t, it’s worth your while to learn it.

In OpenOffice, this cell formula creates text by joining three pieces, two specified in the command and one drawn from another cell:

=CONCATENATE("Some canned text";A1;"Other canned text")

(As I recall it’s the same in Excel but if not it will be close.)

One way I can imagine being wrong is if your original data has the leading numbers as you’ve shown, like 3.state_hey and you need to strip each one off, and only use state_hey in the newly built text. In that case, it could be justified to first transfer the column to an Npp text doc. This is easy but I won’t guess if it’s your actual need.

NAGARAJGOUDA PATIL

@neil-schipper
data in excel is
state1
state2
state_hey
state_4

i need both find and repalce

NAGARAJGOUDA PATIL

@neil-schipper
=CONCATENATE is for joining nly

Neil Schipper

@nagarajgouda-patil
Are you not joining

<EA Na=“ + state_1 + #Start” VL=“ + state_1 + ” O=“R”/>

??

Neil Schipper

@neil-schipper Are you literally needing to convert state to sate (which I assumed was a typo)?

NAGARAJGOUDA PATIL

NAGARAJGOUDA PATIL

@nagarajgouda-patil here i did find - and replace but individually i need formula

Neil Schipper

@nagarajgouda-patil So your need is complete;y fulfilled, right?

NAGARAJGOUDA PATIL

@neil-schipper
i need formaula
what i did in uploaded excel is manual find and replace
i have 100s of data like this

Neil Schipper

You dumped an image with no explanation. Is the result column hand-crafted by you to demonstrate needed output, or did you use a formula (with concatenate command)?

but individually i need formula

I’m not sure what you mean. Do you know how to look through Excel’s help documentation for formula commands?

NAGARAJGOUDA PATIL

@neil-schipper
thanks for your help