• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » String Extraction (ie Substring).

#1 2008-06-13 17:35:18

ptremblay
Member
Registered: 2008-05-27
Posts: 52

String Extraction (ie Substring).

Bonjour,


I have a source column named ProtocolTitle in Access of type MEMO (in Talend = String of length 1073741823) to go to an Oracle target column of length 50.

How can I do the equivalent of Left(row1.ProtocolTitle, 50)?

In order words capturing the first 50 characters of the source.

Thanks.
PM

Offline

#2 2008-06-13 17:38:02

maverick
Member
Company: 1913
Registered: 2008-03-27
Posts: 71
Website

Re: String Extraction (ie Substring).

Hi,

In Java :
row1.ProtocolTitle.substring(0, 49);


Matthieu Garde
Software development
1913 - L'expertise des PME
www.1913.fr

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » String Extraction (ie Substring).

Board footer

Powered by FluxBB