topic Remove Character from the first to # in Talend Studio

Remove Character from the first to #

Anonymous — Sat, 16 Nov 2024 03:31:08 GMT

All,

I have used SOAP to connect sharepoint list and stored the data in an XML file.

I can see some unwanted characters also combined with the actual data in around 15 columns, say for example

float;#1.00000000000000 -- Need to remove float;#

2505;#Mark, Roy - Need to remove 2505;#

3328;#Ingra, Valere -- Need to remove 3328;#

90;#0 -- Need to remove 90;#

what ever come before # and '#' needs to be removed from those columns.

Re: Remove Character from the first to #

kavita02 — Tue, 21 Jan 2020 05:55:16 GMT

Hi @Karthi-Talend ,

what I could understand from inline question is you want to remove all the characters before '#' from a column. I guess you can do that using substring() function.

Below is the sample code for the same:

String s = "float;#1.00000000000000";
System.out.println("String After Trimming Characters before # = "+s.substring(s.indexOf('#')+1));

output ==>

String After Trimming Characters before # = 1.00000000000000

You can use the same function for any variable in tMap or tJavarow.

Re: Remove Character from the first to #

TRF — Tue, 21 Jan 2020 07:14:50 GMT

You may also use a simple regex such as
row1.col1.replaceAll("^.*#", "")