Code

Comments

11111

Adds an extra column to the end with value "Yes"

11112

Adds an extra column to the end with value "cm"

11113

Adds an extra column to the end with value "Tonne"

11116



11119

Adds an extra column to the end with value 6

13323

VTFE - ATM v2: Pads the row with spaces to 1250 total characters then splits fixed-width into columns, divides weight by 10, divides length/width/height by 100, divides total cubic by 1000, splits column 22 (compared with v1) into two, and has two extra columns on the end

13421

Clemidger: Merges columns 8 & 9 into one column, and merges columns 30, 31 and 32 into one. Then adds column with value "Yes" to the end

13422

Merges columns 18, 19, 20 into single field

15521

DXT - Spicers: Adds four columns to the end with values "Skid", 0.91, 0.65 and 0.5

15791

IFS: breaks up rows based on key/value pairs separated by a space

16323

VTFE - ATM: Pads the row with spaces to 950 total characters then splits fixed-width into columns, divides weight by 10, divides length/width/height by 100, divides total cubic by 1000.

16324

VTFE - Hobsons: Pads the row with spaces to 750 total characters then splits fixed-width into columns, and divides length/width/height by 100

16547

If the first column is "H", include the row, otherwise ignore it.

18637

Go Logistics: Adds an extra column to the end with value 1. (18637B only): If there are more than ten columns, ignore the row if the barcode column (column 10) starts with "801", "911", "941" or "991"

22222

Adds an extra column to the end with value "Del"

22332

Direct Freight: Gathers header row, detail row and barcode details based on column 0, then combines them into a single row when outputting them

33819

RED / Hunter Douglas: Writes the first 18 columns, then repeats column 1 again at the end as the barcode, previously being used as the item reference

33919

Adds two columns at the end, qty = 1 and weight = 2

33999

Outputs all fields, but includes the value of column 15 a second time appended to the value in column 17

45786

Edifact file format, used by Black & Decker and VTFE: Uses the value in Column 0 as a key to populate the values, combining them into a single record when it receives a key of "GIN"

53332

Complete Data Access (WADS): Adds twelve columns to the end, with Carton, Keg, Item and Pallet description, weight and count (adding a blank for anything not present).

54792

VTFE transformation for Toll Chemicals: If Column 0 is "H", store the information as “header”. If Column 0 is "C" and there is header information, return the header information, then columns 0 through 7, then two blank fields, then Column 1 again. If Column 0 is "D" and there is header information, make sure there are at least 9 columns. Then return the header

58367

Godfrey Hirst: Takes column 7 and splits it into a state and postcode, then adds another column with value 1. Finally adds another column again to the end with value "Roll"

65637

Hunter Express: Splits column 3 into two values. Also, if column 0 value already exists, sets both columns 2 and 5 to value 0

65638

Hunter Express v2: Takes the values of columns 0, 15 and 16 joined together and skips the row entirely if they’ve already been read previously.

67539

FSA: If column 9 > 0, set the value to "Item", otherwise blank it out. If column 10 > 0, set the value to "Pallet" and the value of column 12 to 0, otherwise blank out column 10.

67540

FSA/CUB: If the settings say to ignore the first row, create a row with one column with value "IGNORE". Either way, take the values in column 9 as cartons, in column 10 as pallets and in column 20 as kegs. If any of them are non-zero, write the other columns, then add the type of freight, the count and the count of cartons again as extra columns at the end.

68998

Liquor: Adds together the number of tobacco (count of rows with column 9 = "Y"), cartons (from column 10), repacks (from column 11), kegs (from column 12), weight (from column 13) and pallets (from column 14). Combines the information into a single record per consignment.

72111

Jaix: Combines columns 29 and 30 into a single field, and multiplies the value in column 20 by 1000. Finally, adds an extra column at the end with value "Yes" 

72112

Jaix: Combines columns 29 and 30 into a single field. Combines columns 32 and 33 into a single field. If the original column 32 was non-blank, adds an extra column at the end with a value of "Yes", otherwise adds an extra column with a value of "No".

72139

Hi-Trans: Multiplies the value in column 23 by 1000.

72312

MoveIt: If column 0 = "M", save the values in columns 15-26 as pickup address. If column 0 = "C", save the values in each column as a header, except replace the values in columns 23-34 with the values from columns 0-11 from the saved pickup address. Finally, if column 0 = "I" and header information has been saved, write the header information, then the row information, dividing the values in columns 10, 11 and 12 by 1000 and add an extra column at the end with the value from column 1 over again.

74816

Jaix/Niche: Set column 30 to be the values in columns 29 and 30 combined. Similarly, set the value in column 44 to be the values of columns 43 and 44 combined. Multiply the value in column 36 by 1000.

74817

Jaix: Exactly the same as 74816 except that it adds an extra column at the end with a value of 1.

76332

Casella: If column 0 = "C", write everything saved as header, as detail and as barcode. Then blank out the saved values and save this row as header. If column 0 = "D" and something is saved as header, write everything saved as header, as detail and as barcode. Then blank out the saved value of detail and barcode and save this row as detail. If column 0 = "T" and something is saved as header, add the value in column 1 to the end of the saved barcodes separated by pipe character (|). Otherwise, if there is something saved as header, add the values in the row to the saved header. After all rows are read, write out the saved header, details and barcode one last time.

77360

Buffalo: If the row has at least 7 columns, and the value in column 1 is not blank, write the cells, but replace the values in columns 4 and 6 with 0 if column 6 = "-". Finally, add a column with value "NSW" to the end.

77361

New England / Toll: If any row does not have exactly 42 columns, send an error email. If column 0 = "NEW02" and column 25 = "DOWNER EDI MINING (BOGGABRI)", replace column 0 with "TOLLDOW". If column 12 ends in "-00", remove the "-00". If the values in columns 30 and 31 are both 0, replace the value in column 30 with the one in column 32. If the values in columns 30 and 32 are both 0, replace the value in column 30 with the one in column 31.

77362

ALN: If column 0 = "CN1", save the first 26 columns, plus the values in columns 47-50 as a single column as Special Instructions, plus the final column as Customer Identifier, plus column 34 as Service Level into the header. If column 0 = "CN2" and there is something saved in the header, write the header, followed by the first 18 columns of the row, then column 1 again as the barcode.

77363

VTFE: Checks that the row has at least 1248 characters and that there is a * or . character after the 1248th. Splits the first 1249 characters from fixed-width to columns, dividing the weight by 10, the length/width/height by 100 and the total cubic by 1000.

773632

NDST: Does the same as 77363, but checks characters 1243, 1244 and 1245 for Tailgate Required (pickup), Tailgate Required (delivery) and Hand Unload respectively. Adds delivery Special Instructions and pickup Special Instructions as two extra columns at the end.

77364

VTFE: Does the same as 77363 except that it doesn't check for the * or . characters after the 1248th character.

77365

VTFE / Loreal: Same as 77363 but removes rows with description of "Envelope" in them.

77369

ALN Transmate: If column 0 = "H", save the row as header. If column 0 = "D", write the header columns, then this row's columns.

78716

RoadRunner: If row starts with "C", if we have saved item info then write saved header, item info and barcodes - separated by semi-colon (;). Either way, blank the saved header, item info and barcodes. Then split the row from fixed-width and save as header. If the row starts with "F", if we have saved item info then write saved header, item info and barcodes - separated by semi-colon and blank the saved item info and barcodes. Then split the row from fixed-width and save as item info. If the row starts with "H", take the characters from 29-188, split by spaces and save as barcodes. Finally, after all the rows have been read, write the saved header, item info and barcodes one last time.

98447

Allied 2017: If column 0 = "D", write the previous header (if it exists and has exactly 19 columns), then save this row as header. If column 0 = "I" and we have saved a header, if the saved header has more than 6 columns and either column 4 or column 6 of the saved header has a value, if the saved header has exactly 16 columns, add three blank columns. Take column 5 of the row / 100 as the length, column 6 / 100 as the width and column 7 / 100 as the height. Multiply these three values together and save as column 18 of the header. Append column 1 of the row to column 16 of the header. Append column 8 of the row to column 17 of the header - so long as it is not already contained within that column. Once all rows have been read, write the saved header so long as it has exactly 19 columns.