Hi,
I need to modify a file which contains about 70k lines. I need to find the line that contains a string. And on that same line I need to replace another existing string. The value that has to be found are 1200+ items.
Example:
I have an input file which has the items 8814942, 8814943 in it. UltraEdit has to search for those value and has to replacebyOnly the items in the input list should have this modification.
Does anyone have some idea how to that with UltraEdit. I cannot do this with Excel because I will lose my original format (white space, etc.)
Start:
After replace:
I need to modify a file which contains about 70k lines. I need to find the line that contains a string. And on that same line I need to replace another existing string. The value that has to be found are 1200+ items.
Example:
I have an input file which has the items 8814942, 8814943 in it. UltraEdit has to search for those value and has to replace
Code: Select all
"EURO "
Code: Select all
"EURO-2 "
Does anyone have some idea how to that with UltraEdit. I cannot do this with Excel because I will lose my original format (white space, etc.)
Start:
Code: Select all
1, 1,"8814942 ","XXXXXXXXXXXXX","EURO ","12/02/13", 1200, 800,155,35, 900, 800.00, 0, 0
2, 1, 1, 0.0, 0, 207.0, 123.0, 150.0, 1, 207.0, 1, 123.0, 1, 150.0,0,0,0, 54.3600006, 0.000000, 1,0
3, 1,0, 36, 216.0, 3, 4, 2, 3, 2, 4, 3, 3, 0, 3, 3, 1, 3, 17,2, 0, 0, 1
4, 1, 0, 6,"D352/01"," "," "," "
5, 1," "," "," "," "
6, 1," "," ", 1.5100," "," "
7, 1," "," "," "
8, 1," ", 0.0, 0.0, 0.0, 150.0, 0, 0, 0, 0, 1, 0, 0.00
1, 1,"8814943 ","XXXXXXXXXXXXX","EURO ","12/02/13", 1200, 800,155,35, 900, 800.00, 0, 0
2, 1, 1, 0.0, 0, 207.0, 123.0, 150.0, 1, 207.0, 1, 123.0, 1, 150.0,0,0,0, 54.3600006, 0.000000, 1,0
3, 1,0, 36, 216.0, 3, 4, 2, 3, 2, 4, 3, 3, 0, 3, 3, 1, 3, 17,2, 0, 0, 1
4, 1, 0, 6,"D352/01"," "," "," "
5, 1," "," "," "," "
6, 1," "," ", 1.5100," "," "
7, 1," "," "," "
8, 1," ", 0.0, 0.0, 0.0, 150.0, 0, 0, 0, 0, 1, 0, 0.00
Code: Select all
1, 1,"8814942 ","XXXXXXXXXXXXX","EURO-2 ","12/02/13", 1200, 800,155,35, 900, 800.00, 0, 0
2, 1, 1, 0.0, 0, 207.0, 123.0, 150.0, 1, 207.0, 1, 123.0, 1, 150.0,0,0,0, 54.3600006, 0.000000, 1,0
3, 1,0, 36, 216.0, 3, 4, 2, 3, 2, 4, 3, 3, 0, 3, 3, 1, 3, 17,2, 0, 0, 1
4, 1, 0, 6,"D352/01"," "," "," "
5, 1," "," "," "," "
6, 1," "," ", 1.5100," "," "
7, 1," "," "," "
8, 1," ", 0.0, 0.0, 0.0, 150.0, 0, 0, 0, 0, 1, 0, 0.00
1, 1,"8814943 ","XXXXXXXXXXXXX","EURO-2 ","12/02/13", 1200, 800,155,35, 900, 800.00, 0, 0
2, 1, 1, 0.0, 0, 207.0, 123.0, 150.0, 1, 207.0, 1, 123.0, 1, 150.0,0,0,0, 54.3600006, 0.000000, 1,0
3, 1,0, 36, 216.0, 3, 4, 2, 3, 2, 4, 3, 3, 0, 3, 3, 1, 3, 17,2, 0, 0, 1
4, 1, 0, 6,"D352/01"," "," "," "
5, 1," "," "," "," "
6, 1," "," ", 1.5100," "," "
7, 1," "," "," "
8, 1," ", 0.0, 0.0, 0.0, 150.0, 0, 0, 0, 0, 1, 0, 0.00