on 08-19-2014 10:09 PM
Hello Everyone,
I have a FTP to FTP scenario where I have "ABC.tar.gz" file on the sender side. I have to unzip this file which has "ABC.TXT" and "ABC.LOG" files.
I am able to create a .txt file with the following configurations on sender channel:
However, I don't get the desired output. The "ABC.TXT" file generated on the receiver side has the content of "ABC.LOG" as well.
Below is the file generated. I want my content to start from 0003|AB......
How should I eliminate the front content of my output file starting from "ABC.txt 00000664 0000147.........to oracle2 dba"?
Please advise.
Thank you!
Regards,
Sim
How can we eliminate the unwanted part from the target file structure?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Simran,
From which file are you getting the data ABC.txt 00000664 0000147.........to oracle2 dba"?
Can you give more details what is the requirement? What are the info you need to get from ABC.TXT and ABC.LOG?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello!
Are the unwanted lines of the output generated by the zip-module or is this the content of your second file?
Is this one big line without linebreak? You can find out by using a different editor like Notepad++
If the structure of the file is always the same, you can you MessageTransformBean to transform the textstream to XML and then remove the lines in the mapping or even directly by the bean.
Of course, you would need to transform it back to CSV in the receiver.
Hello Heiko,
These extra lines are NOT the content of second file.
Yes, the file will always be in the same format. Now how would I be able to eliminate the unwanted lines? Do I have to use ESR for this purpose? I have not been using ESR for this scenario.
I think these extra lines are the result of "gunzip" parameter.
Also the receiver needs a text file generated started from 0003|AB......
Please could you guide on using MessageTransformBean for eliminating the front lines from the unzipped file?
Thank you!
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.