Community
    • Login

    find and replace with wildcards

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    16 Posts 4 Posters 2.1k Views
    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.
    • john EskiJ
      john Eski @Terry R
      last edited by

      @terry-r

      this is a bigger exampleof the data

      DETAILS,J29-1 L86 JOIST-0.75
      COMPONENT,V3,C89-41-0.75,INVERTED,1,345,20.5,2.5,20.5,347.5,DIMPLE,18,SWAGE,27.5,SWAGE,317.5,DIMPLE,327
      COMPONENT,B1,C89-41-0.75,NORMAL,1,1110,0,20.5,1110,20.5,DIMPLE,20.5,LIP NOTCH,24,DIMPLE,70.89,LIP NOTCH,72,LIP NOTCH,87.01,LIP NOTCH,513.68,LIP NOTCH,518.83,DIMPLE,529.81,DIMPLE,580.19,LIP NOTCH,591.17,LIP NOTCH,596.32,LIP NOTCH,1022.98,DIMPLE,1039.11,LIP NOTCH,1070.98,LIP NOTCH,1086,DIMPLE,1089.5
      COMPONENT,T2,C89-41-0.75,INVERTED,1,1110,0,329.5,1110,329.5,DIMPLE,20.5,LIP NOTCH,24,LIP NOTCH,259.03,LIP NOTCH,264.18,DIMPLE,275.15,DIMPLE,325.54,LIP NOTCH,336.52,LIP NOTCH,341.67,LIP NOTCH,768.33,LIP NOTCH,773.48,DIMPLE,784.46,DIMPLE,834.85,LIP NOTCH,845.82,LIP NOTCH,850.97,LIP NOTCH,1086,DIMPLE,1089.5
      COMPONENT,W4,C89-41-0.75,NORMAL,1,394.41,64.27,10.49,281.77,339.51,END_TRUSS,0,DIMPLE,12,SWAGE,27.5,SWAGE,366.91,DIMPLE,382.41,END_TRUSS,394.41
      COMPONENT,W4,C89-41-0.75,INVERTED,1,394.41,536.42,10.49,318.92,339.51,END_TRUSS,0,DIMPLE,12,SWAGE,27.5,SWAGE,366.91,DIMPLE,382.41,END_TRUSS,394.41
      COMPONENT,W4,C89-41-0.75,NORMAL,1,394.41,573.58,10.49,791.07,339.51,END_TRUSS,0,DIMPLE,12,SWAGE,27.5,SWAGE,366.91,DIMPLE,382.41,END_TRUSS,394.41
      COMPONENT,W4,C89-41-0.75,INVERTED,1,394.41,1045.73,10.49,828.23,339.51,END_TRUSS,0,DIMPLE,12,SWAGE,27.5,SWAGE,366.91,DIMPLE,382.41,END_TRUSS,394.41
      COMPONENT,V3,C89-41-0.75,NORMAL,1,345,1089.5,2.5,1089.5,347.5,DIMPLE,18,SWAGE,27.5,SWAGE,317.5,DIMPLE,327

      Terry RT 1 Reply Last reply Reply Quote 0
      • Terry RT
        Terry R @john Eski
        last edited by Terry R

        @john-eski said in find and replace with wildcards:

        this is a bigger exampleof the data

        You won’t get anybody to continue with the help until you provide the example within a black box as talked about in the pinned post I referred to, or from that in another referred to post called Formatting Forum Posts. Look for a black box containing an example. This is how your examples need to be shown, otherwise we have no guarantee that the data you want to show is shown correctly. Regex (regular expressions) and characters such as the double quotes are often interpreted by the posting engine, hence this need to use the black box approach.

        Terry

        PS the alternative is to insert your example data, then select it and click on the </> icon above the posting window. It will then show as this does.
        

        I also note that your new example data is different from the original. When posting data please show entire information. My idea works if ONLY numbers from the start of the line. Now you show also text on the line.

        john EskiJ 3 Replies Last reply Reply Quote 0
        • john EskiJ
          john Eski @Terry R
          last edited by

          This post is deleted!
          1 Reply Last reply Reply Quote 0
          • john EskiJ
            john Eski @Terry R
            last edited by

            @terry-r

            hope this works.

            
            
            
            DETAILS,,L121  L86-FFW-0.75
            COMPONENT,S1 Joins L120,C89-41-0.75,,INVERTED,1,2756,20.5,2,20.5,2758,DIMPLE,18.5,SWAGE,27.5,SERVICE,298,SERVICE,448,DIMPLE,1377.5,LIP NOTCH,1377.5,SERVICE,2458,SWAGE,2728.5,DIMPLE,2737.5
            COMPONENT,B1,C89-41-0.75,,NORMAL,1,2675,0,20.5,2675,20.5,DIMPLE,20.5,LIP NOTCH,24,BOLT HOLE,35,DIMPLE,120.5,LIP NOTCH,120.5,BOLT HOLE,175,LIP NOTCH,189.5,DIMPLE,189.5,WEB NOTCH,230,WEB NOTCH,1070,LIP NOTCH,1110.5,DIMPLE,1110.5,BOLT HOLE,1125,DIMPLE,1179.5,LIP NOTCH,1179.5,DIMPLE,1330.5,LIP NOTCH,1330.5,BOLT HOLE,1385,DIMPLE,1399.5,LIP NOTCH,1399.5,WEB NOTCH,1440,WEB NOTCH,2280,LIP NOTCH,2320.5,DIMPLE,2320.5,BOLT HOLE,2335,LIP NOTCH,2389.5,DIMPLE,2389.5,LIP NOTCH,2554.5,DIMPLE,2554.5,BOLT HOLE,2640,LIP NOTCH,2651,DIMPLE,2654.5
            COMPONENT,T1,C89-41-0.75,,INVERTED,1,2675,0,2739.5,2675,2739.5,DIMPLE,20.5,LIP NOTCH,24,TRIPLE WEB HOLE,110,DIMPLE,120.5,LIP NOTCH,120.5,DIMPLE,189.5,LIP NOTCH,191,DIMPLE,231.5,LIP NOTCH,239,SERVICE,245,DIMPLE,282.25,LIP NOTCH,287,LIP NOTCH,309.53,DIMPLE,650.01,LIP NOTCH,650.01,LIP NOTCH,990.48,TRIPLE WEB HOLE,1010,DIMPLE,1017.75,LIP NOTCH,1038.48,DIMPLE,1068.5,LIP NOTCH,1086.48,LIP NOTCH,1109,DIMPLE,1110.5,LIP NOTCH,1179.5,DIMPLE,1179.5,SERVICE,1253.01,DIMPLE,1330.5,LIP NOTCH,1330.5,DIMPLE,1399.5,LIP NOTCH,1401,DIMPLE,1441.5,LIP NOTCH,1449,DIMPLE,1492.25,LIP NOTCH,1497,LIP NOTCH,1519.52,LIP NOTCH,1860,DIMPLE,1860,TRIPLE WEB HOLE,1910,LIP NOTCH,2200.48,DIMPLE,2227.75,LIP NOTCH,2248.48,DIMPLE,2278.5,LIP NOTCH,2296.48,LIP NOTCH,2319,DIMPLE,2320.5,LIP NOTCH,2389.5,DIMPLE,2389.5,SERVICE,2466.67,DIMPLE,2554.5,LIP NOTCH,2554.5,LIP NOTCH,2651,DIMPLE,2654.5
            COMPONENT,N2,C89-41-0.75,,INVERTED,1,204,3,1379.5,207,1379.5,DIMPLE,17.5,SWAGE,27.5,DIMPLE,117.5,WEB NOTCH,117.5,LIP NOTCH,117.5,SWAGE,176.5,DIMPLE,186.5
            COMPONENT,S2,C89-41-0.75,,INVERTED,1,2756,120.5,2,120.5,2758,DIMPLE,18.5,SWAGE,27.5,SERVICE,298,SERVICE,448,DIMPLE,1377.5,SWAGE,1377.5,SERVICE,2458,SWAGE,2728.5,DIMPLE,2737.5
            COMPONENT,S3,C89-41-0.75,,NORMAL,1,2756,189.5,2,189.5,2758,DIMPLE,18.5,SWAGE,27.5,LIP NOTCH,1377.5,DIMPLE,1377.5,DIMPLE,2418.5,SWAGE,2418.5,TRIPLE WEB HOLE,2483,TRIPLE WEB HOLE,2674,SWAGE,2728.5,DIMPLE,2737.5
            COMPONENT,H1,C89-41-0.75,,NORMAL,1,956,172,2420.5,1128,2420.5,DIMPLE,17.5,LIP NOTCH,24,WEB NOTCH,24,LIP NOTCH,58,DIMPLE,59.5,LIP NOTCH,399.99,DIMPLE,427.26,LIP NOTCH,447.99,DIMPLE,478.01,LIP NOTCH,495.99,DIMPLE,528.77,LIP NOTCH,543.99,LIP NOTCH,556.04,DIMPLE,896.5,LIP NOTCH,898,WEB NOTCH,932,LIP NOTCH,932,DIMPLE,938.5
            COMPONENT,S4,C89-41-0.75,,INVERTED,1,355,231.5,2403,231.5,2758,DIMPLE,17.5,SWAGE,27.5,TRIPLE WEB HOLE,82,TRIPLE WEB HOLE,273,SWAGE,327.5,DIMPLE,336.5
            COMPONENT,W1,C89-41-0.75,,NORMAL,1,472.32,607.22,2412.49,274.29,2747.51,END_TRUSS,0,DIMPLE,11.3,SWAGE,27.5,SWAGE,35.07,SWAGE,437.25,SWAGE,444.82,DIMPLE,461.02,END_TRUSS,472.32
            COMPONENT,S5,C89-41-0.75,,INVERTED,1,355,650.01,2403,650.01,2758,DIMPLE,17.5,SWAGE,27.5,SWAGE,327.5,DIMPLE,336.5
            COMPONENT,W2,C89-41-0.75,,NORMAL,1,472.3,692.8,2412.49,1025.71,2747.51,END_TRUSS,0,DIMPLE,11.3,SWAGE,27.5,SWAGE,35.07,TRIPLE WEB HOLE,429.38,SWAGE,437.23,SWAGE,444.8,DIMPLE,461,END_TRUSS,472.3
            COMPONENT,S6,C89-41-0.75,,NORMAL,1,355,1068.5,2403,1068.5,2758,DIMPLE,17.5,SWAGE,27.5,TRIPLE WEB HOLE,82,TRIPLE WEB HOLE,273,SWAGE,327.5,DIMPLE,336.5
            COMPONENT,S7,C89-41-0.75,,INVERTED,1,2756,1110.5,2,1110.5,2758,DIMPLE,18.5,SWAGE,27.5,DIMPLE,1377.5,LIP NOTCH,1377.5,SWAGE,2418.5,DIMPLE,2418.5,TRIPLE WEB HOLE,2483,TRIPLE WEB HOLE,2674,SWAGE,2728.5,DIMPLE,2737.5
            COMPONENT,N3,C89-41-0.75,,INVERTED,1,324,1093,1379.5,1417,1379.5,DIMPLE,17.5,SWAGE,27.5,WEB NOTCH,86.5,LIP NOTCH,86.5,DIMPLE,86.5,SERVICE,160.01,WEB NOTCH,237.5,DIMPLE,237.5,LIP NOTCH,237.5,SWAGE,296.5,DIMPLE,306.5
            COMPONENT,S8,C89-41-0.75,,NORMAL,1,2756,1179.5,2,1179.5,2758,DIMPLE,18.5,SWAGE,27.5,SERVICE,298,SERVICE,448,DIMPLE,1377.5,SWAGE,1377.5,SERVICE,2458,DIMPLE,2607.5,SWAGE,2607.5,SWAGE,2728.5,DIMPLE,2737.5
            COMPONENT,N1,C89-41-0.75,,INVERTED,1,186,1162,2609.5,1348,2609.5,DIMPLE,17.5,WEB NOTCH,24,LIP NOTCH,24,SERVICE,91.01,LIP NOTCH,162,WEB NOTCH,162,DIMPLE,168.5
            COMPONENT,S9,C89-41-0.75,,INVERTED,1,2756,1330.5,2,1330.5,2758,DIMPLE,18.5,SWAGE,27.5,SERVICE,298,SERVICE,448,DIMPLE,1377.5,SWAGE,1377.5,SERVICE,2458,DIMPLE,2607.5,SWAGE,2607.5,SWAGE,2728.5,DIMPLE,2737.5
            COMPONENT,S10,C89-41-0.75,,NORMAL,1,2756,1399.5,2,1399.5,2758,DIMPLE,18.5,SWAGE,27.5,LIP NOTCH,1377.5,DIMPLE,1377.5,DIMPLE,2418.5,SWAGE,2418.5,TRIPLE WEB HOLE,2483,TRIPLE WEB HOLE,2674,SWAGE,2728.5,DIMPLE,2737.5
            COMPONENT,H2,C89-41-0.75,,NORMAL,1,956,1382,2420.5,2338,2420.5,DIMPLE,17.5,LIP NOTCH,24,WEB NOTCH,24,LIP NOTCH,58,DIMPLE,59.5,LIP NOTCH,399.98,DIMPLE,427.25,LIP NOTCH,447.98,DIMPLE,478,LIP NOTCH,495.98,DIMPLE,528.76,LIP NOTCH,543.98,LIP NOTCH,556.03,DIMPLE,896.5,LIP NOTCH,898,WEB NOTCH,932,LIP NOTCH,932,DIMPLE,938.5
            COMPONENT,S11,C89-41-0.75,,INVERTED,1,355,1441.5,2403,1441.5,2758,DIMPLE,17.5,SWAGE,27.5,TRIPLE WEB HOLE,82,TRIPLE WEB HOLE,273,SWAGE,327.5,DIMPLE,336.5
            COMPONENT,W3,C89-41-0.75,,NORMAL,1,472.31,1817.21,2412.49,1484.29,2747.51,END_TRUSS,0,DIMPLE,11.3,SWAGE,27.5,SWAGE,35.07,SWAGE,437.24,SWAGE,444.81,DIMPLE,461.02,END_TRUSS,472.31
            COMPONENT,S12,C89-41-0.75,,INVERTED,1,355,1860,2403,1860,2758,DIMPLE,17.5,SWAGE,27.5,SWAGE,327.5,DIMPLE,336.5
            COMPONENT,W4,C89-41-0.75,,NORMAL,1,472.3,1902.8,2412.49,2235.71,2747.51,END_TRUSS,0,DIMPLE,11.3,SWAGE,27.5,SWAGE,35.07,SWAGE,437.24,SWAGE,444.8,DIMPLE,461.01,END_TRUSS,472.3
            COMPONENT,S13,C89-41-0.75,,NORMAL,1,355,2278.5,2403,2278.5,2758,DIMPLE,17.5,SWAGE,27.5,TRIPLE WEB HOLE,82,TRIPLE WEB HOLE,273,SWAGE,327.5,DIMPLE,336.5
            COMPONENT,S14,C89-41-0.75,,INVERTED,1,2756,2320.5,2,2320.5,2758,DIMPLE,18.5,SWAGE,27.5,DIMPLE,1377.5,LIP NOTCH,1377.5,SWAGE,2418.5,DIMPLE,2418.5,TRIPLE WEB HOLE,2483,TRIPLE WEB HOLE,2674,SWAGE,2728.5,DIMPLE,2737.5
            COMPONENT,N5,C89-41-0.75,,INVERTED,1,369,2303,1379.5,2672,1379.5,DIMPLE,17.5,SWAGE,27.5,WEB NOTCH,86.5,LIP NOTCH,86.5,DIMPLE,86.5,SERVICE,163.68,WEB NOTCH,251.5,DIMPLE,251.5,LIP NOTCH,251.5,SWAGE,341.5,DIMPLE,351.5
            COMPONENT,S15,C89-41-0.75,,NORMAL,1,2756,2389.5,2,2389.5,2758,DIMPLE,18.5,SWAGE,27.5,SERVICE,298,SERVICE,448,DIMPLE,1377.5,SWAGE,1377.5,SERVICE,2458,DIMPLE,2607.5,SWAGE,2607.5,SWAGE,2728.5,DIMPLE,2737.5
            COMPONENT,N4,C89-41-0.75,,INVERTED,1,200,2372,2609.5,2572,2609.5,DIMPLE,17.5,WEB NOTCH,24,LIP NOTCH,24,SERVICE,94.68,SWAGE,172.5,DIMPLE,182.5
            COMPONENT,S16,C89-41-0.75,,NORMAL,1,2756,2554.5,2,2554.5,2758,DIMPLE,18.5,SWAGE,27.5,SERVICE,298,SERVICE,448,DIMPLE,1377.5,SWAGE,1377.5,SERVICE,2458,DIMPLE,2607.5,LIP NOTCH,2607.5,SWAGE,2728.5,DIMPLE,2737.5
            COMPONENT,S17 Joins L122,C89-41-0.75,,NORMAL,1,2756,2654.5,2,2654.5,2758,DIMPLE,18.5,SWAGE,27.5,SERVICE,298,SERVICE,448,DIMPLE,1377.5,LIP NOTCH,1377.5,SERVICE,2458,SWAGE,2728.5,DIMPLE,2737.5
            
            
            john EskiJ 1 Reply Last reply Reply Quote 1
            • john EskiJ
              john Eski @john Eski
              last edited by

              So this a typical singular file… , Blank lines need to be deleted also but i haven’t looked into that yet. I have tried reading the instructions but i am a layman in terms of code. i do not understand what is meant by some of the expresion/terms. im pretty good with excel but that is where my code knowledge ends. Is there a clearer definition of what each of the individual code parameters mean?

              john EskiJ Terry RT 2 Replies Last reply Reply Quote 0
              • john EskiJ
                john Eski @john Eski
                last edited by

                @john-eski

                ^\h*\R|\R\h*\z this sorted the blank lines nicely - THank you Peter!
                Search and you will find, i’m still digesting the post though…

                1 Reply Last reply Reply Quote 0
                • john EskiJ
                  john Eski @Terry R
                  last edited by

                  @terry-r
                  I should have Clarified the line situation better - every line except the header starts with the word “COMPONENT” , the Header starts with the word “DETAILS”

                  1 Reply Last reply Reply Quote 0
                  • Terry RT
                    Terry R @john Eski
                    last edited by

                    @john-eski said in find and replace with wildcards:

                    So this a typical singular file… , Blank lines need to be deleted also but i haven’t looked into that yet.

                    Thanks for at least showing the complete line in your example. As your original example doesn’t appear in the latest set I’ve had to try to determine where the “42” is to be added. Currently I think it will be immediately preceding the word “DIMPLE” in the first line that needs editing. If this isn’t correct you can adjust the number “11” in the following regular expression up or down to compensate.

                    I note the lines vary considerably in length and number of fields, so do wonder if your example data is correct. As you will see my latest solution varies considerably from my initial one. This is because your initial example was incorrect in it’s representation. Every character is important, even spaces.

                    Find:^([^,\r\n]*,){11}
                    Replace:${0}42,
                    Search mode is “regular expression”. The red text above can be copied directly into the Replace function.

                    We did wonder if you were conversant with regex, @PeterJones pointed out that your replacement code; if it had worked; would have shown all the characters selected written back repeatedly. I do strongly suggest you read the posts in the FAQ section. There are links there pointing to books that help you learn regular expression code. Bear in mind there are many flavours of regex, so sometimes the example code in those books won’t work in Notepad++ without some adjustment. Another website I think helps a lot is rexegg.com and regex101.com where you can enter regex code and it will explain the different portions of it. You might even want to load my solution into regex101.com once you determine it works so it can help clarify the different portions of it.

                    There is also a built-in function that can remove blank lines. Look under Edit, Line Operations. Truly blank lines and blank lines containing spaces only can be easily removed using these functions.

                    So give my latest idea a go. When initially trying it, either use it on a copy of the file, or use the replace button (not replace all) so you can see where the insert is occuring. If it’s wrong you can “undo”, adjust and try again.

                    Terry

                    1 Reply Last reply Reply Quote 1
                    • guy038G
                      guy038
                      last edited by guy038

                      Hello, @john-eski, @terry-r and All,

                      Regarding the last text, of 31 lines, provided by @john-eski, in reverse video, here are the first 33 columns, correctly aligned :

                      •----•-----------•----------------•--------------------•---•----------•---•---------•---------•---------•---------•---------•------------•------•-------------•--------•------------------•--------•-----------------•---------•-----------------•---------•-----------•---------•-----------------•---------•-----------------•---------•-----------•---------•-----------•---------•-----------•---------•
                      | 0  |     1     |       2        |         3          | 4 |    5     | 6 |    7    |    8    |    9    |   10    |   11    |    12      |  13  |     14      |   15   |        16        |   17   |       18        |   19    |      20         |   21    |    22     |   23    |       24        |    25   |       26        |   27    |     28    |   29    |    30     |   31    |     32    |    33   |
                      •----•-----------•----------------•--------------------•---•----------•---•---------•---------•---------•---------•---------•------------•------•-------------•--------•------------------•--------•-----------------•---------•-----------------•---------•-----------•---------•-----------------•---------•-----------------•---------•-----------•---------•-----------•---------•-----------•---------•
                      | 01 | DETAILS   |                | L121  L86-FFW-0.75 |   |          |   |         |         |         |         |         |            |      |             |        |                  |        |                 |         |                 |         |           |         |                 |         |                 |         |           |         |           |         |           |         |
                      | 02 | COMPONENT | S1 Joins L120  | C89-41-0.75        |   | INVERTED | 1 | 2756    |   20.5  |    2    |   20.5  | 2758    | DIMPLE     | 18.5 |  SWAGE      |   27.5 |  SERVICE         |  298   | SERVICE         |  448    | DIMPLE          | 1377.5  | LIP NOTCH | 1377.5  | SERVICE         | 2458    | SWAGE           | 2728.5  | DIMPLE    | 2737.5  |           |         |           |         |
                      | 03 | COMPONENT | B1             | C89-41-0.75        |   | NORMAL   | 1 | 2675    |    0    |   20.5  | 2675    |   20.5  | DIMPLE     | 20.5 |  LIP NOTCH  |   24   |  BOLT HOLE       |   35   | DIMPLE          |  120.5  | LIP NOTCH       |  120.5  | BOLT HOLE |  175    | LIP NOTCH       |  189.5  | DIMPLE          |  189.5  | WEB NOTCH |  230    | WEB NOTCH | 1070    | LIP NOTCH | 1110.5  |
                      | 04 | COMPONENT | T1             | C89-41-0.75        |   | INVERTED | 1 | 2675    |    0    | 2739.5  | 2675    | 2739.5  | DIMPLE     | 20.5 |  LIP NOTCH  |   24   |  TRIPLE WEB HOLE |  110   | DIMPLE          |  120.5  | LIP NOTCH       |  120.5  | DIMPLE    |  189.5  | LIP NOTCH       |  191    | DIMPLE          |  231.5  | LIP NOTCH |  239    | SERVICE   |  245    | DIMPLE    |  282.25 |
                      | 05 | COMPONENT | N2             | C89-41-0.75        |   | INVERTED | 1 |  204    |    3    | 1379.5  |  207    | 1379.5  | DIMPLE     | 17.5 |  SWAGE      |   27.5 |  DIMPLE          |  117.5 | WEB NOTCH       |  117.5  | LIP NOTCH       |  117.5  | SWAGE     |  176.5  | DIMPLE          |  186.5  |                 |         |           |         |           |         |           |         |
                      | 06 | COMPONENT | S2             | C89-41-0.75        |   | INVERTED | 1 | 2756    |  120.5  |    2    |  120.5  | 2758    | DIMPLE     | 18.5 |  SWAGE      |   27.5 |  SERVICE         |  298   | SERVICE         |  448    | DIMPLE          | 1377.5  | SWAGE     | 1377.5  | SERVICE         | 2458    | SWAGE           | 2728.5  | DIMPLE    | 2737.5  |           |         |           |         |
                      | 07 | COMPONENT | S3             | C89-41-0.75        |   | NORMAL   | 1 | 2756    |  189.5  |    2    |  189.5  | 2758    | DIMPLE     | 18.5 |  SWAGE      |   27.5 |  LIP NOTCH       | 1377.5 | DIMPLE          | 1377.5  | DIMPLE          | 2418.5  | SWAGE     | 2418.5  | TRIPLE WEB HOLE | 2483    | TRIPLE WEB HOLE | 2674    | SWAGE     | 2728.5  | DIMPLE    | 2737.5  |           |         |
                      | 08 | COMPONENT | H1             | C89-41-0.75        |   | NORMAL   | 1 |  956    |  172    | 2420.5  | 1128    | 2420.5  | DIMPLE     | 17.5 |  LIP NOTCH  |   24   |  WEB NOTCH       |   24   | LIP NOTCH       |   58    | DIMPLE          |   59.5  | LIP NOTCH |  399.99 | DIMPLE          |  427.26 | LIP NOTCH       |  447.99 | DIMPLE    |  478.01 | LIP NOTCH |  495.99 | DIMPLE    |  528.77 |
                      | 09 | COMPONENT | S4             | C89-41-0.75        |   | INVERTED | 1 |  355    |  231.5  | 2403    |  231.5  | 2758    | DIMPLE     | 17.5 |  SWAGE      |   27.5 |  TRIPLE WEB HOLE |   82   | TRIPLE WEB HOLE |  273    | SWAGE           |  327.5  | DIMPLE    |  336.5  |                 |         |                 |         |           |         |           |         |           |         |
                      | 10 | COMPONENT | W1             | C89-41-0.75        |   | NORMAL   | 1 |  472.32 |  607.22 | 2412.49 |  274.29 | 2747.51 | END_TRUSS  |  0   |  DIMPLE     |   11.3 |  SWAGE           |   27.5 | SWAGE           |   35.07 | SWAGE           |  437.25 | SWAGE     |  444.82 | DIMPLE          |  461.02 | END_TRUSS       |  472.32 |           |         |           |         |           |         |
                      | 11 | COMPONENT | S5             | C89-41-0.75        |   | INVERTED | 1 |  355    |  650.01 | 2403    |  650.01 | 2758    | DIMPLE     | 17.5 |  SWAGE      |   27.5 |  SWAGE           |  327.5 | DIMPLE          |  336.5  |                 |         |           |         |                 |         |                 |         |           |         |           |         |           |         |
                      | 12 | COMPONENT | W2             | C89-41-0.75        |   | NORMAL   | 1 |  472.3  |  692.8  | 2412.49 | 1025.71 | 2747.51 | END_TRUSS  |  0   |  DIMPLE     |   11.3 |  SWAGE           |   27.5 | SWAGE           |   35.07 | TRIPLE WEB HOLE |  429.38 | SWAGE     |  437.23 | SWAGE           |  444.8  | DIMPLE          |  461    | END_TRUSS |  472.3  |           |         |           |         |
                      | 13 | COMPONENT | S6             | C89-41-0.75        |   | NORMAL   | 1 |  355    | 1068.5  | 2403    | 1068.5  | 2758    | DIMPLE     | 17.5 |  SWAGE      |   27.5 |  TRIPLE WEB HOLE |   82   | TRIPLE WEB HOLE |  273    | SWAGE           |  327.5  | DIMPLE    |  336.5  |                 |         |                 |         |           |         |           |         |           |         |
                      | 14 | COMPONENT | S7             | C89-41-0.75        |   | INVERTED | 1 | 2756    | 1110.5  |    2    | 1110.5  | 2758    | DIMPLE     | 18.5 |  SWAGE      |   27.5 |  DIMPLE          | 1377.5 | LIP NOTCH       | 1377.5  | SWAGE           | 2418.5  | DIMPLE    | 2418.5  | TRIPLE WEB HOLE | 2483    | TRIPLE WEB HOLE | 2674    | SWAGE     | 2728.5  | DIMPLE    | 2737.5  |           |         |
                      | 15 | COMPONENT | N3             | C89-41-0.75        |   | INVERTED | 1 |  324    | 1093    | 1379.5  | 1417    | 1379.5  | DIMPLE     | 17.5 |  SWAGE      |   27.5 |  WEB NOTCH       |   86.5 | LIP NOTCH       |   86.5  | DIMPLE          |   86.5  | SERVICE   |  160.01 | WEB NOTCH       |  237.5  | DIMPLE          |  237.5  | LIP NOTCH |  237.5  | SWAGE     |  296.5  | DIMPLE    |  306.5  |
                      | 16 | COMPONENT | S8             | C89-41-0.75        |   | NORMAL   | 1 | 2756    | 1179.5  |    2    | 1179.5  | 2758    | DIMPLE     | 18.5 |  SWAGE      |   27.5 |  SERVICE         |  298   | SERVICE         |  448    | DIMPLE          | 1377.5  | SWAGE     | 1377.5  | SERVICE         | 2458    | DIMPLE          | 2607.5  | SWAGE     | 2607.5  | SWAGE     | 2728.5  | DIMPLE    | 2737.5  |
                      | 17 | COMPONENT | N1             | C89-41-0.75        |   | INVERTED | 1 |  186    | 1162    | 2609.5  | 1348    | 2609.5  | DIMPLE     | 17.5 |  WEB NOTCH  |   24   |  LIP NOTCH       |   24   | SERVICE         |   91.01 | LIP NOTCH       |  162    | WEB NOTCH |  162    | DIMPLE          |  168.5  |                 |         |           |         |           |         |           |         |
                      | 18 | COMPONENT | S9             | C89-41-0.75        |   | INVERTED | 1 | 2756    | 1330.5  |    2    | 1330.5  | 2758    | DIMPLE     | 18.5 |  SWAGE      |   27.5 |  SERVICE         |  298   | SERVICE         |  448    | DIMPLE          | 1377.5  | SWAGE     | 1377.5  | SERVICE         | 2458    | DIMPLE          | 2607.5  | SWAGE     | 2607.5  | SWAGE     | 2728.5  | DIMPLE    | 2737.5  |
                      | 19 | COMPONENT | S10            | C89-41-0.75        |   | NORMAL   | 1 | 2756    | 1399.5  |    2    | 1399.5  | 2758    | DIMPLE     | 18.5 |  SWAGE      |   27.5 |  LIP NOTCH       | 1377.5 | DIMPLE          | 1377.5  | DIMPLE          | 2418.5  | SWAGE     | 2418.5  | TRIPLE WEB HOLE | 2483    | TRIPLE WEB HOLE | 2674    | SWAGE     | 2728.5  | DIMPLE    | 2737.5  |           |         |
                      | 20 | COMPONENT | H2             | C89-41-0.75        |   | NORMAL   | 1 |  956    | 1382    | 2420.5  | 2338    | 2420.5  | DIMPLE     | 17.5 |  LIP NOTCH  |   24   |  WEB NOTCH       |   24   | LIP NOTCH       |   58    | DIMPLE          |   59.5  | LIP NOTCH |  399.98 | DIMPLE          |  427.25 | LIP NOTCH       |  447.98 | DIMPLE    |  478    | LIP NOTCH |  495.98 | DIMPLE    |  528.76 |
                      | 21 | COMPONENT | S11            | C89-41-0.75        |   | INVERTED | 1 |  355    | 1441.5  | 2403    | 1441.5  | 2758    | DIMPLE     | 17.5 |  SWAGE      |   27.5 |  TRIPLE WEB HOLE |   82   | TRIPLE WEB HOLE |  273    | SWAGE           |  327.5  | DIMPLE    |  336.5  |                 |         |                 |         |           |         |           |         |           |         |
                      | 22 | COMPONENT | W3             | C89-41-0.75        |   | NORMAL   | 1 |  472.31 | 1817.21 | 2412.49 | 1484.29 | 2747.51 | END_TRUSS  |  0   |  DIMPLE     |   11.3 |  SWAGE           |   27.5 | SWAGE           |   35.07 | SWAGE           |  437.24 | SWAGE     |  444.81 | DIMPLE          |  461.02 | END_TRUSS       |  472.31 |           |         |           |         |           |         |
                      | 23 | COMPONENT | S12            | C89-41-0.75        |   | INVERTED | 1 |  355    | 1860    | 2403    | 1860    | 2758    | DIMPLE     | 17.5 |  SWAGE      |   27.5 |  SWAGE           |  327.5 | DIMPLE          |  336.5  |                 |         |           |         |                 |         |                 |         |           |         |           |         |           |         |
                      | 24 | COMPONENT | W4             | C89-41-0.75        |   | NORMAL   | 1 |  472.3  | 1902.8  | 2412.49 | 2235.71 | 2747.51 | END_TRUSS  |  0   |  DIMPLE     |   11.3 |  SWAGE           |   27.5 | SWAGE           |   35.07 | SWAGE           |  437.24 | SWAGE     |  444.8  | DIMPLE          |  461.01 | END_TRUSS       |  472.3  |           |         |           |         |           |         |
                      | 25 | COMPONENT | S13            | C89-41-0.75        |   | NORMAL   | 1 |  355    | 2278.5  | 2403    | 2278.5  | 2758    | DIMPLE     | 17.5 |  SWAGE      |   27.5 |  TRIPLE WEB HOLE |   82   | TRIPLE WEB HOLE |  273    | SWAGE           |  327.5  | DIMPLE    |  336.5  |                 |         |                 |         |           |         |           |         |           |         |
                      | 26 | COMPONENT | S14            | C89-41-0.75        |   | INVERTED | 1 | 2756    | 2320.5  |    2    | 2320.5  | 2758    | DIMPLE     | 18.5 |  SWAGE      |   27.5 |  DIMPLE          | 1377.5 | LIP NOTCH       | 1377.5  | SWAGE           | 2418.5  | DIMPLE    | 2418.5  | TRIPLE WEB HOLE | 2483    | TRIPLE WEB HOLE | 2674    | SWAGE     | 2728.5  | DIMPLE    | 2737.5  |           |         |
                      | 27 | COMPONENT | N5             | C89-41-0.75        |   | INVERTED | 1 |  369    | 2303    | 1379.5  | 2672    | 1379.5  | DIMPLE     | 17.5 |  SWAGE      |   27.5 |  WEB NOTCH       |   86.5 | LIP NOTCH       |   86.5  | DIMPLE          |   86.5  | SERVICE   |  163.68 | WEB NOTCH       |  251.5  | DIMPLE          |  251.5  | LIP NOTCH |  251.5  | SWAGE     |  341.5  | DIMPLE    |  351.5  |
                      | 28 | COMPONENT | S15            | C89-41-0.75        |   | NORMAL   | 1 | 2756    | 2389.5  |    2    | 2389.5  | 2758    | DIMPLE     | 18.5 |  SWAGE      |   27.5 |  SERVICE         |  298   | SERVICE         | 448     | DIMPLE          | 1377.5  | SWAGE     | 1377.5  | SERVICE         | 2458    | DIMPLE          | 2607.5  | SWAGE     | 2607.5  | SWAGE     | 2728.5  | DIMPLE    | 2737.5  |
                      | 29 | COMPONENT | N4             | C89-41-0.75        |   | INVERTED | 1 |  200    | 2372    | 2609.5  | 2572    | 2609.5  | DIMPLE     | 17.5 |  WEB NOTCH  |   24   |  LIP NOTCH       |   24   | SERVICE         |   94.68 | SWAGE           |  172.5  | DIMPLE    |  182.5  |                 |         |                 |         |           |         |           |         |           |         |
                      | 30 | COMPONENT | S16            | C89-41-0.75        |   | NORMAL   | 1 | 2756    | 2554.5  |    2    | 2554.5  | 2758    | DIMPLE     | 18.5 |  SWAGE      |   27.5 |  SERVICE         |  298   | SERVICE         | 448     | DIMPLE          | 1377.5  | SWAGE     | 1377.5  | SERVICE         | 2458    | DIMPLE          | 2607.5  | LIP NOTCH | 2607.5  | SWAGE     | 2728.5  | DIMPLE    | 2737.5  |
                      | 31 | COMPONENT | S17 Joins L122 | C89-41-0.75        |   | NORMAL   | 1 | 2756    | 2654.5  |    2    | 2654.5  | 2758    | DIMPLE     | 18.5 |  SWAGE      |   27.5 |  SERVICE         |  298   | SERVICE         | 448     | DIMPLE          | 1377.5  | LIP NOTCH | 1377.5  | SERVICE         | 2458    | SWAGE           | 2728.5  | DIMPLE    | 2737.5  |           |         |           |         |
                      •----•-----------•----------------•--------------------•---•----------•---•---------•---------•---------•---------•---------•------------•------•-------------•--------•------------------•--------•-----------------•---------•-----------------•---------•-----------•---------•-----------------•---------•-----------------•---------•-----------•---------•-----------•---------•-----------•---------•
                      

                      So, @terry-r, your regex S/R :

                      SEARCH ^([^,\r\n]*,){11}

                      REPLACE :${0}42,

                      would insert a new field 42

                      • Right before the string DIMPLE, in 26 cases

                      • Right before the string END_TRUSS, in 4 cases

                      Best Regards

                      guy038

                      1 Reply Last reply Reply Quote 1
                      • guy038G
                        guy038
                        last edited by guy038

                        Hi, @john-eski, @terry-r and All

                        To be exhaustive, here are, below, the next columns from the 34th to the 75th :

                        •----•-----------•---------•-----------•---------•------- -•---------•-----------•---------•-----------•---------•-----------------•--------•-----------•---------•-----------•---------•-----------•--------•-----------•---------•-----------•------•-----------•--------•-----------•--------•-----------•--------•-----------•---------•--------•--------•-----------•--------•--------•--------•-----------•------•-----------•--------•-----------•--------•
                        | 0  |    34     |   35    |    36     |   37    |   38    |   39    |    40     |   41    |    42     |   43    |       44        |   45   |    46     |   47    |    48     |   49    |     50    |   51   |    52     |   53    |    54     |  55  |    56     |  57    |    58     |   59   |    60     |   61   |    62     |   63    |   64   |   65   |    66     |   67   |   68   |  69    |    70     |  71  |    72     |   73   |    74     |   75   |
                        •----•-----------•---------•-----------•---------•------- -•---------•-----------•---------•-----------•---------•-----------------•--------•-----------•---------•-----------•---------•-----------•--------•-----------•---------•-----------•------•-----------•--------•-----------•--------•-----------•--------•-----------•---------•--------•--------•-----------•--------•--------•--------•-----------•------•-----------•--------•-----------•--------•
                        | 01 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 02 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 03 | DIMPLE    | 1110.5  | BOLT HOLE | 1125    | DIMPLE  | 1179.5  | LIP NOTCH | 1179.5  | DIMPLE    | 1330.5  | LIP NOTCH       | 1330.5 | BOLT HOLE | 1385    | DIMPLE    | 1399.5  | LIP NOTCH | 1399.5 | WEB NOTCH | 1440    | WEB NOTCH | 2280 | LIP NOTCH | 2320.5 | DIMPLE    | 2320.5 | BOLT HOLE | 2335   | LIP NOTCH | 2389.5  | DIMPLE | 2389.5 | LIP NOTCH | 2554.5 | DIMPLE | 2554.5 | BOLT HOLE | 2640 | LIP NOTCH | 2651   | DIMPLE    | 2654.5 |
                        | 04 | LIP NOTCH |  287    | LIP NOTCH |  309.53 | DIMPLE  |  650.01 | LIP NOTCH |  650.01 | LIP NOTCH |  990.48 | TRIPLE WEB HOLE | 1010   | DIMPLE    | 1017.75 | LIP NOTCH | 1038.48 | DIMPLE    | 1068.5 | LIP NOTCH | 1086.48 | LIP NOTCH | 1109 | DIMPLE    | 1110.5 | LIP NOTCH | 1179.5 | DIMPLE    | 1179.5 | SERVICE   | 1253.01 | DIMPLE | 1330.5 | LIP NOTCH | 1330.5 | DIMPLE | 1399.5 | LIP NOTCH | 1401 | DIMPLE    | 1441.5 | LIP NOTCH | 1449   |
                        | 05 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 06 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 07 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 08 | LIP NOTCH |  543.99 | LIP NOTCH |  556.04 | DIMPLE  |  896.5  | LIP NOTCH |  898    | WEB NOTCH |  932    | LIP NOTCH       |  932   | DIMPLE    |  938.5  |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 09 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 10 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 11 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 12 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 13 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 14 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 15 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 16 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 17 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 18 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 19 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 20 | LIP NOTCH |  543.98 | LIP NOTCH |  556.03 | DIMPLE  |  896.5  | LIP NOTCH |  898    | WEB NOTCH |  932    | LIP NOTCH       |  932   | DIMPLE    |  938.5  |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 21 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 22 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 23 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 24 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 25 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 26 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 27 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 28 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 29 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 30 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        | 31 |           |         |           |         |         |         |           |         |           |         |                 |        |           |         |           |         |           |        |           |         |           |      |           |        |           |        |           |        |           |         |        |        |           |        |        |        |           |      |           |        |           |        |
                        •----•-----------•---------•-----------•---------•---------•---------•-----------•---------•-----------•---------•-----------------•--------•-----------•---------•-----------•---------•-----------•--------•-----------•---------•-----------•------•-----------•--------•-----------•--------•-----------•--------•-----------•---------•--------•--------•-----------•--------•--------•--------•-----------•------•-----------•--------•-----------•--------•
                        

                        Note that the final columns, from the 76th to the 115th, concerns the record 04, only

                        BR

                        guy038

                        john EskiJ 1 Reply Last reply Reply Quote 0
                        • john EskiJ
                          john Eski @guy038
                          last edited by

                          @guy038 Thanks Guy and Terry

                          this is a machine file so certain piece have more operations than others (operations like Dimple)

                          terry’s code worked really well. Thank you again Terry, now i just have to do the reading to comprehend

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