extracting data

TALEND012019 — Sat, 16 Nov 2024 06:43:41 GMT

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"))

Re: extracting data

Anonymous — Thu, 28 Mar 2019 06:36:51 GMT

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.

Best regards

Sabrina