Hi,
I just wonder how do i wants to extract data from mainframe?
I got the data as text file that do not contain any delimiter? Is there any way Talend can handle this matter?
Plz help me
Hi,
So your problem is how to extra data from text file that do not contain any delimiter? I have designed a demo job as follows:
id name
1 shong
2 sabrina
tfileinputdelimited-->tLogrow
Is that what you need? Or Is your file fixed_length?
Would you give us an example of your source file(without delimiter)
see pics
Best regards
Sabrina
Hi Sabrina,
I'm not sure that is accurate resolution since i received encoded data that contain of number in the whole file like '321900000000000003000000440300' and i need to break it accurately so that this encoded data can be translated properly.
According to user they retrieve info from mainframe (not sure what it is) and convert it into textfile with encoded info and that's why nobody can understand the info and only after translate it back to analog.
I'm personally hard to explain....
Hi,
The info about your requirement is a little for us. Would you get more info from user? Do you mean the data "321900000000000003000000440300" is ASCII? and encoding it into UTF8 or others? Need your confirmation.
Best regards
Sabrina
Hi,
I have designed a demo job using component tChangefileEncoding and converting "ASCII" into "UTF-8". The result is "3.219E+29". Is it the readable test you mentioned? What's more, you can use "Custom" option to custom which type you want.
Best regards
Sabrina