To read a tab-separated txt by column

General Discussion
1

Hi there,
Let’s consider a large txt, which could not be fully loaded by Excel, but it could be read by Xbench. However the source language and target are not in the Column1 and Column2, let’s say, they are in Column3 and Column4. Could we customize the Columns we want to import? In this case, we want to import Column3 and Column4 and displayed as source and target, with Column1 and Column2 as reference.

Wish you a nice day, thanks a lot.

Best Regards
Wang

2

Currently Xbench requires that source is column 1 and target is column 2.

Therefore, if Excel is not able to load the file to do the swap, perhaps you can try preprocessing the file with a different tool such as awk.

3

Thanks a lot for your help. I will learn these tools.