- Replies
- Views
- Last post
- 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...Replies: 9 Views: 9.7K
- 9 Replies
- 9.7K Views
- Last post by Mofi
Dec 07, 2018
- 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...Replies: 5 Views: 2.7K
- 5 Replies
- 2.7K Views
- Last post by Mofi
Nov 08, 2018
- 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...Replies: 12 Views: 6.2K
- 12 Replies
- 6.2K Views
- Last post by MickRC3
Jan 08, 2018
- 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...Replies: 2 Views: 6.6K
- 2 Replies
- 6.6K Views
- Last post by Blarneystone
Dec 21, 2017