code wanted: file splicing

[DeaD_EyE]

https://www.joeldare.com/wiki/using_awk_on_csv_files

awk -F "," '{OFS=","; print $2,$9}' ./Dropbox/opc_client/ULD\ Numbers\ optimized\ for\ PLC\ -\ ULD\ Numbers.csv

OFS = Output Field Separator

Output:
A Certified Aircraft Container,AAA 46201 LH
A Certified Aircraft Container,AAD 46202 AF
A Certified Aircraft Container,AAF 46203 KL
A Certified Aircraft Container,AAP 46204 LH
...

awk -F "," '{OFS=","; print $2,$9}' ./Dropbox/opc_client/ULD\ Numbers\ optimized\ for\ PLC\ -\ ULD\ Numbers.csv > result1.csv

Then you can do the same with the other files.
Then you concatenate the files afterwards.