hello Forum,
I have the following problem:
I get an Oracle txt file with the data i need to run a report.
the problem is that the layout format is not always the same ( mainly due to tab alignement).
i have made a print screen where i have 2 different files with different layout:
-in the first image the Name1 client column is overlapping the Beleg-Nr column; in the second it is shown correctly.
i have recorded a macro for the 2nd file to format the report : to apply the text to column functionality using the tab reparator.
the problem is that if i use the macro to format the 1st file, i get the following output.
Uploaded with ImageShack.us
I'm really stuck here.
do you know if there is any way/solution to avoid all these problems.
is there a way to set the output of the file as csv instead of text, or even better to export it to excel?
or is there a solution to convert this directly to excel?
I have the following problem:
I get an Oracle txt file with the data i need to run a report.
the problem is that the layout format is not always the same ( mainly due to tab alignement).
i have made a print screen where i have 2 different files with different layout:
-in the first image the Name1 client column is overlapping the Beleg-Nr column; in the second it is shown correctly.
i have recorded a macro for the 2nd file to format the report : to apply the text to column functionality using the tab reparator.
the problem is that if i use the macro to format the 1st file, i get the following output.
Uploaded with ImageShack.us
I'm really stuck here.
do you know if there is any way/solution to avoid all these problems.
is there a way to set the output of the file as csv instead of text, or even better to export it to excel?
or is there a solution to convert this directly to excel?
