I have a fixed length text file with thousands and thousands of records. I need a script/macro to look at position 209-218, and if it contains all spaces, then replace it with the values in position 63-69. And, yes, I would need to append 3 spaces at the end of the file since I am copying a 7-character field into a 10-digit field. Can anyone help?

Thanks!

Sorry about the lack of info in my original post. Here is some clarification:

-It is a text file (see attached).
-The data contain lines with a fixed length for ALL lines.
-There is an ending character (CRLF) at the end of every record.
-UE Version is 13.20a+1.
-Regular Expression engines preferred: UltraEdit style is fine, if that is easier to implement. This is so new to me that I have no preference yet.
-I've attached a zip file that contains a Before script snapshot and an After script snapshot - deleted later.

Thanks.

Maybe Mofi has signed off for tonight - here's is how:

Use
Search - Replace in files...

Find what:
^(.{62}(.{7}).{139})[ ]{10}

Replace:
\1\2...
(the three dots should be three spaces)

In files type: (specify your file mask)
directory: (specify your path).

Use "Regular expressions" and switch on perl regular expression engine (check with UE help to find out how).

Be careful!! - this will alter multiple files on disk of setup wrong - use at own risk !!

Jorrasdk, Mofi,

Awesome! That worked. For some reason, I couldn't get it working in ver13, but I just upgraded to 14.20 and it worked there. Thanks so much.

Can I ask for a little explanation on why that worked (or point me to some documentation)? Most of it makes sense, but I'm a little confused on what the 62 and 139 represent. I assumed they were starting positions in my file, but my file has position 63 and 209 as the starting positions for my data elements.

Thanks again.

Here is an explanation made using RegexBuddy - also check www.regular-expressions.info for tutorials, references and more.

^(.{62}(.{7}).{139}) {10}

Assert position at the beginning of a line (at beginning of the string or after a line break character) «^»
Match the regular expression below and capture its match into backreference number 1 «(.{62}(.{7}).{139})»
--Match any single character that is not a line break character «.{62}»
----Exactly 62 times «{62}»
--Match the regular expression below and capture its match into backreference number 2 «(.{7})»
----Match any single character that is not a line break character «.{7}»
------Exactly 7 times «{7}»
--Match any single character that is not a line break character «.{139}»
----Exactly 139 times «{139}»
Match the space character « {10}»
--Exactly 10 times «{10}»

So you see 62 and 139 are number of columns to skip past to get to the "interesting" columns.

Thank you, jorrasdk. Very helpful.