UltraEdit, UltraCompare, UEStudio forums

Hi Mofi, I found out too late, the totaling function on the export system doesn't work. Is there an elegant way to do this in UEStudio? I've attached a screenshot of an example column. So far, what I've come up with is run a regex against the resulting file and total after the fact. Your thoughts? I...

Thank you so much Mofi. This worked great.  

Hi Mofi, Mofi, I found your script and it worked awesome. Couple that with some Find/replace macros and it fixes the date, the spacing and everything perfectly.  But I made a mistake with my original plan. I didn't realize the "headers" and "trailer" records come before and after a batch of items in...

Hi Mofi These are small files > 12 KB. I would say 20 transactions per day max. I thought long and hard about your questions and think I now have a better way of handling what I am trying to do. But could still use your help. I built the CSV export so that it will now put the header, item order, and...

I am working on a project where I have a text file that has all our order and shipping data into one page. Order numbers are being exported to a system. This system doesn't work with comma separated values. It has a stringent spacing system, i.e. it uses fixed column widths for the order data. There...

Mofi, I don't know how you do it, but in my sample export file it worked first time. Thanks! I am going to work with it so it will add stuff on different lines for the final file. Basically the first line is address, then second is item detail. Thanks again!

Hi Mofi, As always, thank you so much for your helpful information! I did find both the convert to fixed column (which works very well). I also found your fixed column to CSV example and tried to reverse it.   When you said: ... UltraEdit script because of a script has support for string variables a...

Hi all, I have a list that needs to go to a warehouse. The warehouse has an odd column layout that goes something like this: Data column 1: W with a width always just one character Data column 2: Name with a width of fixed 30 characters Data column 3: Street address with a width of fixed 30 characte...

Thanks all! This solved the problem.  

Hi I have a CSV file that changes daily for export to a different system. Trying to figure out how to drop the "day" from the first instance it appears in a line, but not the second.  CSV example: Item#,date1,sold,date2,PO# ItemA,12/18/2017,375,1/22/2018,77954 ItemB,12/18/2017,60,1/22/2018,77954 Ite...

Thank you so much Mofi. I have combined all the queries into one package as you show above. Will move on to the auto start of the scripts and see if I can get them to work too.  😀

Hello, long time UE user. A company I consult for is looking to do daily exports of inventory in CSV format which are FTP’d to a repository. The challenge is I have to run a sequence of regex queries on the CSV before it is ready to FTP. I already have the queries built and working. They are current...