You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » Delimited File Import Process Jumps to 100%
Post a reply
Topic review (newest first)
- yazun
- 2008-10-08 12:41:05
ah right,
the option was just removed from the list..
- yazuna
- 2008-10-08 12:29:18
Sorry, I was to fast - even in 2.4.2 still cannot make it to accept/work with anything like "\s+" or "\\s+" or even "[\t\x0B]+".
Could you please comment if the bug is really fixed?
Cheers
- yazuna
- 2008-10-08 12:14:49
Thank you for the follow up.
Version 3.0.0 just shows an error now, so still no possible to use it there. 2.4.2 works, thanks again.
Cheers
- mhirt
- 2008-08-02 01:15:16
You're right guys. I have created [Bugtracker] bug 4681
Thx for your support
- plegall
- 2008-07-24 22:15:09
Hum... I've also tried with a Java project and I understand the reason of your post, it doesn't seem to work at all. I'll check with Java guys if it's supposed to work and if yes, why it doesn't. To make this understandable, keep in mind that this wizard was designed for the first version of Talend Open Studio when Perl was the only generated language
- plegall
- 2008-07-24 22:05:36
yazuna wrote:
hmm, checked the TOS code - you should never put GUI elements for not implemented feature without any comments...
You are perfectly right. That's why we avoid to do this.
yazuna wrote:
there is no regexp separator logic there at all. it's a waste of time for many people...
or I am missing something?
TOS 2.4.1, Perl project. Input file:
Code:
1;plegall,2007-02-07 09:33:19 2|Li_SpeedyG 2007-02-07 14:54:57 3#yazuna~Today 17:38:32
It works "like a charm" :-)
- olektrolek
- 2008-07-24 17:59:45
test
- yazuna
- 2008-07-24 17:48:28
hmm, checked the TOS code - you should never put GUI elements for not implemented feature without any comments... there is no regexp separator logic there at all. it's a waste of time for many people...
or I am missing something?
cheers,
Chris
- yazuna
- 2008-07-24 17:38:32
Hello,
While trying to get custom regexp as a field separator for various space chars I got no response (single column or errors for a proper a regexp..
i.e. "\\s+" nor "[\t ]+" nor anything seem to work. Is it really regexp evaluator there?
cheers
- Li_SpeedyG
- 2007-03-06 03:12:40
rbillerey wrote:
Hi,
Here's a workaround to solve your problem : choose "custom ansi" and use \\| as a delimiter. Note that it's a workaround and next release of TOS will work with \| .
Hope this helps.
Best Regards
Thanks,
I will give it a try and report back..
- rbillerey
- 2007-03-04 21:02:51
Hi,
Here's a workaround to solve your problem : choose "custom ansi" and use \\| as a delimiter. Note that it's a workaround and next release of TOS will work with \| .
Hope this helps.
Best Regards
- Li_SpeedyG
- 2007-03-01 20:39:15
plegall wrote:
I've reproduced the "bug". In the "Field Separator" of a tFileInputDelimited, you don't have a simple string, you have a regular expression. The pipe "|" is a special character in a regular expression. To use the pipe as the separator, set the property to '\|'.
Hi Again plegall,
I have updated to Java 11 and I now seem to be able to view the results. However, I still do not seem to be able to separate the data as required. I used your technique both in the "file delimited" and "File Regex" with the following results:
FILE DELIMITED -- Trying various types of encoding Field Length = Custom RegExp, Custom RegExp = \| -- The output takes each character and developes a seperate field, even the | has a seperate field.
FILE REGEX -- Regular Expression Settings = \| -- The output is a sigle field labled 1 with every entry also 1
I would appreciate your help on resolving this issue.
Thank You,
GG
- Li_SpeedyG
- 2007-02-07 14:57:43
plegall wrote:
I've reproduced the "bug". In the "Field Separator" of a tFileInputDelimited, you don't have a simple string, you have a regular expression. The pipe "|" is a special character in a regular expression. To use the pipe as the separator, set the property to '\|'.
Thank you.
I will try the fix if the application will allow me to return to the point where I can imput these again.
Hopefully there is a work-around for the Java release issues.
THanks Again
- Li_SpeedyG
- 2007-02-07 14:54:57
rbillerey wrote:
Hi Li_SpeedyG,
I had the same problem with JVM 1.5.0_05 (under XP Home ) which was solved by an upgrade to JVM 1.5.0_11 ( last release ).
Regards.
Thanks for the heads up. However, on a clorporate level we are bound by release 4 du to incomatabliliy issues with other systems. Is there something else I can try? If not I may not be able to use this application.
- plegall
- 2007-02-07 09:33:19
I've reproduced the "bug". In the "Field Separator" of a tFileInputDelimited, you don't have a simple string, you have a regular expression. The pipe "|" is a special character in a regular expression. To use the pipe as the separator, set the property to '\|'.