New Member here... apologies if I'm missing something obvious.
I have a MS Excel input file with a column that contains a Hyperlink URLS. So what you see / is visible within the cell is "Hello World", but there is a URL link within that text that contains "
https://helloworld.com".
What I need to do is exposed the embedded URL from this column as text. After which I can parse text string to extract a key value.
After doing some research, believe I can do the parsing via "tExtractRegexFields". What I have not been able confirm is now to expose the hyperlink URL as text so I can parse.
Any thoughts or suggesting?
Thanks,
Don Miller
Your file structure is OK. I cannot see any problems. It looks like mine studio.
What about the content of the component directories? Could you post the file list here?
Can you please take a look into the log file of the studio:
C:\Talend\TOS_DI-Win32-r104014-V5.3.1\workspace\.metadata\.log
Is there any message related to our problem?
It would be interesting if some - so called - translators classes was created:
C:\Talend\TOS_DI-Win32-r104014-V5.3.1\workspace\.JETEmitters\src\org\talend\designer\codegen\translators\file\spreadsheet\
Here you should find a file like TFileExcelSheetInputBeginJava.java
(I assume your workspace in the default location)
I have tested the components also under release 5.3.1 und currently under 5.4.0M1.
Which components and the directories specifically do you need? Also, I'm not seeing a method to post physical files to this discussion topic. Log file has nothing specific to "tFileExcelSheetInput". I do see entries for "", "tFileInputExcelProcess", but these look like on going logging vs. errors. No 'spreadsheet" directory exists after "C:\Talend\TOS_DI-Win32-r104014-V5.3.1\workspace\.JETEmitters\src\org\talend\designer\codegen\translators\file". When I search for "tFileExcelSheetInput" in the Pallet on the left side of Open Studio, the only hit I get is in the "Misc" folder and the only element that shows is "Note".
Hi Don,
I am running out of ideas what happens in your installation. What about a WebEx session to take a look at you installation and whats wrong? I am probalby not the best supporter though thats why I prefer a personal view on the problem. We can plan appointments via email: jan.lolling@cimt-ag.de. I would be able to make a session this evening from 20:00. It is ok for you or to late? The only spare time earlier is on Friday after noon.
Best regards
Jan Lolling
