I have a file like below which is un structured. The real data starts from line number 10. We can use tfileinput delimiter for that with having header as 10. But i would like to take the values which is right to "Game DATE" and "TRIG: CO." . These are in line numbers 6 and 8. I need to take those values and have them as two fields along with the actual data set, whcih starts form Line number 10. Kindly advise on this.
"SSG TRIG: S81GS146" "END GAME" "Player Place - NY"
" Game DATE:","11/27/2018" "CURRENT DATE:","11/27/2018"
You'll probably need two hits at reading the data in, firstly reading full row, for 1 rows. Inspect each line and extract data if its what you want. secondly, for the data rows, with a header size of 10 to skip the "header".
Here is a TalendHelpCenter:tFileInputRaw in talend which reads all data in a raw file and sends it to a single output column for subsequent processing by another component.
Hi David, thanks, can you please help me more with inspect each lines and extract . The second option I have done already and its is bringing the data to my output. But the first part , I am still not able to achieve. Kindly help.
I am able to take all the data into one column, but how I have to split it in different columns, is what confusing. Since im yet to explore Talend much, i am not able to proceed further.
