find and replace with wildcards
-
Aside from @Terry-R 's excellent start, I highly recommend you read the section of the manual on Substitutions, because your repeated use of
${0}in your original expression indicates that you don’t understand the difference between the whole match${0}and the matched-group-replacement${1},${2}, … and up (shown as${ℕ}in the manual) -
@terry-r tHANK YOU TERRY
-
@john-eski i will try that , the example data is :
,1,315.28,742.86,11.19,924.62,268.81, there are hundreds/thousands of these lines accross 100 files.I read the the info RE find and replace but could not see anything that i missed.
-
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 -
@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.
-
This post is deleted! -
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 -
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?
-
^\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… -
@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” -
@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
-
Hello, @john-eski, @terry-r and All,
Regarding the last text, of
31lines, provided by @john-eski, in reverse video, here are the first33columns, 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
26cases -
Right before the string END_TRUSS, in
4cases
Best Regards
guy038
-
-
Hi, @john-eski, @terry-r and All
To be exhaustive, here are, below, the next columns from the
34thto the75th:•----•-----------•---------•-----------•---------•------- -•---------•-----------•---------•-----------•---------•-----------------•--------•-----------•---------•-----------•---------•-----------•--------•-----------•---------•-----------•------•-----------•--------•-----------•--------•-----------•--------•-----------•---------•--------•--------•-----------•--------•--------•--------•-----------•------•-----------•--------•-----------•--------• | 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
76thto the115th, concerns the record04, onlyBR
guy038
-
@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
