Gulf Coast Bank Digital Corporate Banking User Guide

105

Creating a New File Map - Fixed Width

10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 J KLMNOPQRST U V W X Y Z A B C D E F G H I 10a 1a 2a 3a 4a 5a 6a 7a 8a 9a 10b 1b 2b 3b 4b 5b 6b 7b 8b 9b 10c 1c 2c 3c 4c 5c 6c 7c 8c 9c 10d 1d 2d 3d 4d 5d 6d 7d 8d 9d

10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 J KLMNOPQRST U V W X Y Z A B C D E F G H I 10a 1a 2a 3a 4a 5a 6a 7a 8a 9a 10b 1b 2b 3b 4b 5b 6b 7b 8b 9b 10c 1c 2c 3c 4c 5c 6c 7c 8c 9c 10d 1d 2d 3d 4d 5d 6d 7d 8d 9d

10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9 J KLMNOPQRST U V W X Y Z A B C D E F G H I 10a 1a 2a 3a 4a 5a 6a 7a 8a 9a 10b 1b 2b 3b 4b 5b 6b 7b 8b 9b 10c 1c 2c 3c 4c 5c 6c 7c 8c 9c 10d 1d 2d 3d 4d 5d 6d 7d 8d 9d J KLMNOPQRST U V W X Y Z A B C D E F G H I J1 J2 10a 1a 2a 3a 4a 5a 6a 7a 8a 9a 10b 1b 2b 3b 4b 5b 6b 7b 8b 9b 10c 1c 2c 3c 4c 5c 6c 7c 8c 9c 10d 1d 2d 3d 4d 5d 6d 7d 8d 9d 11a 12a 13a 14a 15a 16a 17a 18a 19a 20a 11b 12b 13b 14b 15b 16b 17b 18b 19b 20b 11a 12a 13a 14a 15a 16a 17a 18a 19a 20a A1 B1 C1 D1 E1 F1 G1 H1 I1 11b 12b 13b 14b 15b 16b 17b 18b 19b 20b 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9

J1 10a 1a 2a 3a 4a 5a 6a 7a 8a 9a 10b 1b 2b 3b 4b 5b 6b 7b 8b 9b 10c 1c 2c 3c 4c 5c 6c 7c 8c 9c 10d 1d 2d 3d 4d 5d 6d 7d 8d 9d J KLMNOPQRST U V W X Y Z A B C D E F G H I J3 J2 J1 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5 6 7 8 9

11a 12a 13a 14a 15a 16a 17a 18a 19a 20a

J3 1a 2a 3a 4a 5a 6a 7a 8a 1b 2b 3b 4b 5b 6b 7b 8b 1c 2c 3c 4c 5c 6c 7c 8c K L M N O P Q R U V W X Y Z A B C D E F G H J2 J3 11 12 13 14 15 16 17 18 21 22 23 24 25 26 27 28 1 2 3 4 5 6 7 8

11b 12b 13b 14b 15b 16b 17b 18b 19b 20b

11a 12a 13a 14a 15a 16a 17a 18a 19a 20a

Click the “Upload From File” link. 1. Click the New Mapping button. 11b 12b 13b 14b 15b 16b 17b 18b 19b 20b J1 A1 B1 C1 D1 E1 F1 G1 H1 I1 A2 B2 C2 D2 E2 F2 G2 H2 I2 2. Select the CSV file you would like to upload. 3. (Optional) Enter how many header rows to skip. 4. (Optional) Enter how maniy trailer rows to skip. 5. (Optional) Check the box to skip the first row. 6. Adjust the column breaks. J3 A3 B3 C3 D3 E3 F3 G3 H3 I3 A3 B3 C3 D3 E3 F3 G3 H3 I3 J2 A1 B1 C1 D1 E1 F1 G1 H1 I1 A2 B2 C2 D2 E2 F2 G2 H2 I2

A2 B2 C2 D2 E2 F2 G2 H2 I2

A1 B1 C1 D1 E1 F1 G1 H1 I1

A3 B3 C3 D3 E3 F3 G3 H3 I3

A2 B2 C2 D2 E2 F2 G2 H2 I2

11a 12a 13a 14a 15a 16a 17a 18a 19a 20a

A3 B3 C3 D3 E3 F3 G3 H3 I3

11b 12b 13b 14b 15b 16b 17b 18b 19b 20b

A1 B1 C1 D1 E1 F1 G1 H1 I1

J1

a. Create column breaks by clicking on a desired position. b. Delete column breaks by clicking on a desired line.

1d 2d 3d 4d 5d 6d 7d 8d

J2

A2 B2 C2 D2 E2 F2 G2 H2 I2

11a 12a 13a 14a 15a 16a 17a 18a

J3

A3 B3 C3 D3 E3 F3 G3 H3 I3

11b 12b 13b 14b 15b 16b 17b 18b

7. Click the Continue button.

A1 B1 C1 D1 E1 F1 G1 H1 A2 B2 C2 D2 E2 F2 G2 H2 A3 B3 C3 D3 E3 F3 G3 H3

Commercial Services: Upload From File