Hello,
I have a large sheet that I need split into separate individual text files.
Each row of the sheet looks like this:
A:
B: 12
C: C:\Full\folder\path\
D: original_filename.txt
E:
F:
G: English words or sentences
H: Chinese characters
Columns A, E and F can be safely ignored.
I will sort by C, then D and then B, to get the original order of the text in each files.
I need a script that will create two identical folders
C:\Full\folder\path-EN\
Where each file inside the EN folder is made up of content from column G only.
C:\Full\folder\path-CH\
Where each file inside the CH folder is made up of content from column H only.
So, use C to recreate the path (+ EN or CH), D to recreate the filename, B to recreate the order of the lines in the text file and G or H as the only content to be added to each file.
Your help would be greatly appreciated.
I have a large sheet that I need split into separate individual text files.
Each row of the sheet looks like this:
A:
B: 12
C: C:\Full\folder\path\
D: original_filename.txt
E:
F:
G: English words or sentences
H: Chinese characters
Columns A, E and F can be safely ignored.
I will sort by C, then D and then B, to get the original order of the text in each files.
I need a script that will create two identical folders
C:\Full\folder\path-EN\
Where each file inside the EN folder is made up of content from column G only.
C:\Full\folder\path-CH\
Where each file inside the CH folder is made up of content from column H only.
So, use C to recreate the path (+ EN or CH), D to recreate the filename, B to recreate the order of the lines in the text file and G or H as the only content to be added to each file.
Your help would be greatly appreciated.
