@wielki-asasyn said in Formula in Replace function:
I would like to replace the “D001” part of the name with D002, D003, D004 etc to have unique names.
I thought I knew what you wanted, proceeded to produce a solution using regular expressions, then once I read your post again I’m not sure I have the correct interpretation. So I’ll ask some questions.
The single line of example above, are there about 350+ similar lines of text needing replacing?
Is the single line provided actually a portion of the 1 (and only) line in the file thus within that 1 line there will be approximately 350+ names?
If the answer to #2 is yes, that’s the idea I followed. My solution involves a few steps. Firstly we’d need to cut this down into individual lines so each name was on a line by itself. Then we’d use the column editor to add an increasing number to the start of the line. Then we’d replace the existing “Dnnn” string with the number at the start of the line. Lastly we’d merge the records back into the original format.
So my steps are.
Using the Replace Function we have
Find What:\|[^”]+”(?!})\K
Replace With:\r\n
Search mode MUST be regular expression. Click on the Replace All button.
So now each name should be on a separate line. Note the regex uses a negative lookahead so that we don’t create a line with the } on it by itself.
Now the cursor must be placed at the first line, first position, actually immediately before the first character. We use the Column Editor (under Edit main menu) and select “number to insert” and use initial number of 1, increase by 1 and leading zeros MUST be ticked, click OK. Provided you have correctly located the cursor you will now see every line is preceded by a 3 digit number, increasing by 1 each line. Since you say there were approximately 350+ names every number created should be 3 digits long as you requested.
Now we use another regex to move this, replacing the existing number using Replace function.
Find What:^(\d{3})(.+?)(“D)\d{3}
Replace With:\2\3\1
Again search mode MUST be regular expression and wrap around ticked. Click on the Replace All button
Confirm the numbers have been correctly replaced. Last step is to join the separated lines back to the original format. So again using the Replace function.
Find What:[^}]\K\R
Replace With: nothing in this field, leave it empty.
Click on the Replace All button and now you should have the format you wished with unique numbers for each name.
Terry
