UltraEdit, UltraCompare, UEStudio forums

Thank you very much fleggy for \d\K,(?=[\d,]+?\.) I need a favor from you. Can you just explain me this regular expression?

Yes there are commas in other context too, but I only want to remove the commas where there is a decimal dot.

Thank you. What should I use to replace these commas so that 1,234,567.89 becomes 1234567.89 ?

I have following data: 2,480.24 1,455.00 1,664 1,666 1,562.00 208.14 -1,134 1,223 -138.54 148.91 -134 2,835 -9.72 346.12 -2,517 2,275 -310.64 283.20 -2,060 2,060 -245.06 245.06 -1,373 1,373 -165.70 165.70 1,750.57 I want to highlight only the data with comma and decimal dot which means: 2,480.24 1,4...

Thanks a lot. I can also use: Find what: (?= \d\d \> ) Replace with: .

Hi! I have the data: 30434 -38 38 28532 -35 35 1446 -02 02 -1446 02 -02 -28532 35 -35 -30434 38 -38 426770 951 10 407 534 -426770 -951 -10 -407 -534 I want to insert a decimal point in every column. The output should be: 304.34 -.38 .38 285.32 -.35 .35 14.46 -.02 .02 -14.46 .02 -.02 -285.32 .35 -.35...

Thank you mofi sir for clarifying

Yup sir, it's working, but it's not highlighting all the string at once. It is highlighting one by one.

Suppose the file contains: 3085.34 3987.19 2.06 4354.89 -369.76 ●15.35 19.84 0.01 21.67 -1.84 5010.51 194252.54 8966.93 0.00▪ 185285.61 24.93 966.60 44.62 0.00 921.98 33867.97 15405.43 1156.39 0.00 14249.04 ▪168.53 ▪76.66 5.75 0.00 70.91 4714.18 6092.15 3.14 6653.96 -564.95 23.46 30.31 0.02 33.11 -2...

Thank you very much Ovg, and also grateful thanks to Mofi.

Suppose this is the data in Excel 15597 000 000 030 000 -030 000 -030 991 002 8146 000 000 015 000 054 000 054 149743 000 000 374 000 -374 000 -374 I want to insert a decimal point in every column. The output should be: 155.97 0.00 0.00 0.30 0.00 -0.30 0.00 -0.30 9.91 0.02 81.46 0.00 0.00 0.15 0.00 ...

Hello! 10767 00 00 10767 01 00 00 01 9186 00 00 9186 01 00 00 01 63990 00 978 63012 06 00 00 06 26145 00 00 26145 03 00 00 03 82973 11593 00 71380 07 01 00 06 228479 11593 87462 129424 20 01 08 11 33027 00 00 33027 03 00 00 03 232079 11593 83401 137085 20 01 07 12 Suppose this is the file in Excel. ...

Thank you..... bro thank so much .......... u helped lot

A value in a CSV file is 2.33 - (minus is on the right side). How do we put all the minus signs to the left side like - 2.33 (minus is on the left side) using a Perl regular expression replace in UltraEdit?