Community
    • Login

    Find replace with itiration

    Scheduled Pinned Locked Moved
    Help wanted · · · – – – · · ·
    2
    13
    407
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • NAGARAJGOUDA PATILN
      NAGARAJGOUDA PATIL @Neil Schipper
      last edited by

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

      i need both find and repalce

      1 Reply Last reply Reply Quote 0
      • NAGARAJGOUDA PATILN
        NAGARAJGOUDA PATIL @Neil Schipper
        last edited by

        @neil-schipper
        =CONCATENATE is for joining nly

        Neil SchipperN 1 Reply Last reply Reply Quote 0
        • Neil SchipperN
          Neil Schipper @NAGARAJGOUDA PATIL
          last edited by Neil Schipper

          @nagarajgouda-patil
          Are you not joining

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

          ??

          Neil SchipperN NAGARAJGOUDA PATILN 2 Replies Last reply Reply Quote 0
          • Neil SchipperN
            Neil Schipper @Neil Schipper
            last edited by

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

            1 Reply Last reply Reply Quote 0
            • NAGARAJGOUDA PATILN
              NAGARAJGOUDA PATIL @Neil Schipper
              last edited by NAGARAJGOUDA PATIL

              Screenshot (49).png

              NAGARAJGOUDA PATILN Neil SchipperN 2 Replies Last reply Reply Quote 0
              • NAGARAJGOUDA PATILN
                NAGARAJGOUDA PATIL @NAGARAJGOUDA PATIL
                last edited by

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

                Neil SchipperN 1 Reply Last reply Reply Quote 0
                • Neil SchipperN
                  Neil Schipper @NAGARAJGOUDA PATIL
                  last edited by

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

                  NAGARAJGOUDA PATILN 1 Reply Last reply Reply Quote 0
                  • NAGARAJGOUDA PATILN
                    NAGARAJGOUDA PATIL @Neil Schipper
                    last edited by

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

                    1 Reply Last reply Reply Quote 0
                    • Neil SchipperN
                      Neil Schipper @NAGARAJGOUDA PATIL
                      last edited by

                      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 PATILN 1 Reply Last reply Reply Quote 0
                      • NAGARAJGOUDA PATILN
                        NAGARAJGOUDA PATIL @Neil Schipper
                        last edited by

                        @neil-schipper
                        thanks for your help

                        1 Reply Last reply Reply Quote 0
                        • First post
                          Last post
                        The Community of users of the Notepad++ text editor.
                        Powered by NodeBB | Contributors