Community

It may be possible to do this with TestPad's Regular Expressions.

Submit a sample of the source data, showing the before and after contents. Use a masking character to hide confidential information, but explain the msaked content as alpha or numeric or both, spaces, etc.

Here is another solution also:

Search for: ^.{7}

The current syntax tool cannot use RegEx or wild cards like braces or brackets. It only handles whole words. You will need to enter each value with the surrounding characters.

I think he is looking for chars 46-49.

This should work.....
Search for: ^.{45}(.{4}).*$
Replace with: \1

Thanks ben.

You confirmed my suspicion. Another lesson learned from a great teacher.

Ths solution provided by kengrubb does work but it is limited by having to hard code the first four characters. I wanted to overcome that, so I thought that this would work for any 4 char string: Search for: ^(.{4})(.*)\n\1(.*)$ Replace with: \1\2\3 But surprisingly, I got an error message that this...

It does involve other steps, but I use CSDiff to see exact changes. This involves making a copy of the original files first, doing the Replace, then using CSDiff to compare the modified files to the copies of the originals. I just contributed to answering the same question by you on 2/20, here: http...

I think that what you want to do may be possible with TextPad and TextPad macros. The major limitation will be that the macro cannot be edited, so the steps must be perfectly worked out and documented in advance.. You first need to use RegEx to rearrange the data to do the proper sorting. The sortin...

I use CSDiff for File Comparisons. More info here: http://www.componentsoftware.com/Products/CSDiff/ Here is an excerpt of highlights: Features of CSDiff: * Powerful folder and single file comparison tool. * Single screen display provides a unique, intuitive difference analysis, making it ideal for ...

I used your settings searching for "a" and replacing with "a". Had no errors, here is message from my log: === BEGIN REPLACE COMMAND === { Time: 2010-Feb-20 22:46:44 Search Pattern: a Replacement Format: a Character Encoding: windows-1252 Root folder: C:\Temp Include Filter: *.tx...

I have the licensed version of WildEdit 2.0 Does not have the options described by ben_josephs. On the Replace tab there is an unchecked box labeled: "."matches end of line characters. On the second tab, "Options", there is a check box for Replacement Format with three radio opti...

If you can copy/move all the files into the same folder, you might want to try doing that with WildEdit.

I am not a Java expert, but it sounds like you need to create script to do something like this: Set line counter to 0 Start loop Increase line counter by 1 Read next Data Source file line (same as line counter) Use RegEx to extract the value to a variable Write the extracted value variable to STK pr...

Thanks for the solution and the clarification.

It sounds like you are looking for a RegEx string.

If you can provide a before and after sample we can be of more help. Show part of the source file and show what you are trying to capture. Be sure to explain/show all variations such as variable letters vs digits, string lengths, etc.