code wanted: file splicing

[Skaperen]

i often need a command to take particular columns of different files and combine them. for example i just needed to take columns 1-19 of file A and columns 20-EOL of file B and output it. line 37 would come from line 37 of both files.

[wavic]

You can try cut
or awk

[Skaperen]

You can try cut
or awk

so how to combine the multiple files into one?

[wavic]

Hm! This will require some bash scripting and I am not aware of it. I think Pandas python module can do this.
I can try later to do some bash magic. It's embarrassing that I am using Linux for years and still don't know the bash scripting syntax.

[DeaD_EyE]

cat file1 file2 file3 file4 > final_file

[wavic]

He wants to get specific columns from each file and make a new file from them.

[nilamo]

What's a "column"?

Are these csv files? Or is each character a different column? If it's each character, what about multi-byte characters?

Without example input/output, the likelihood of finding preexisting code is minimal.

[Skaperen]

cat file1 file2 file3 file4 > final_file

and while cutting specified columns in each?

---

Hm! This will require some bash scripting and I am not aware of it. I think Pandas python module can do this.
I can try later to do some bash magic. It's embarrassing that I am using Linux for years and still don't know the bash scripting syntax.

i'd rather do new things in Python.

when did you start using Linux? i started in 1993. but i was using muliple Unix before then, and some even since then, so i had a head start.

---

What's a "column"?

Are these csv files? Or is each character a different column? If it's each character, what about multi-byte characters?

Without example input/output, the likelihood of finding preexisting code is minimal.

some might be CSV files. i'm working on a design for a new command.

[wavic]

10 years.

[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.