Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
TALEND012019
Contributor
Contributor

extracting data

 

I am new to talend, can somebody help for extracting following information from a csv file:

 

1)Extract if apostrophe is found after a digit like 455' NEW

2)Extract if there is period(dot) with multiple characters to its previous or next...examples like below:

a.b or a. b or a . b (this is not to be extracted)

ab.d or ab.dc or a.bc <with or without space after dot (these need to be extracted)

3)count of alpha is greater than digits..

example:

abcd4(this needs to be extracted)

4)for multiple OR conditions, I need to write multiple times...is there anyway to list these or conditions in any csv file or list all these at once.

like for fetching name having RAM OR BHIM..i need to write...CAN'T IT BE DONE IN A SINGLE TIME (row5.name.equals("ram")||row5.name.equals("BHIM"))

 

 

Labels (3)
1 Reply
Anonymous
Not applicable

Hello,

What does your input source look like?

Here is a tMap component which can transform and route data from single or multiple sources to single or multiple destinations. 

Please have a look at tMap scenario:https://help.talend.com/reader/qKn3z_Eiw4JM~sZ515DcOw/o_LXMYvloz~e2wSOyrw4Lw

Best regards

Sabrina