topic Re: Isolate and extract numeric values from a string and convert to int in Talend Studio

Isolate and extract numeric values from a string and convert to int

Anonymous — Sat, 16 Nov 2024 03:15:06 GMT

Hi,

I have a string that can take the following forms:

"1"

"23"

"1 abcdef"

"23 abcdf"

I want to extract the numerical value from the string and then convert it to an int data type (as specified in output DB).

I have tried using the Integer.parseInt, but the job fails since the string contains non-numerical values as well.

Can someone please advise me.

Thanks!

Re: Isolate and extract numeric values from a string and convert to int

TRF — Mon, 17 Feb 2020 12:45:39 GMT

Did you try with the following regex to remove every non-digit characters?

row1.yourField.replaceAll("\D", "")

Re: Isolate and extract numeric values from a string and convert to int

Anonymous — Mon, 17 Feb 2020 13:18:36 GMT

Thanks for your advise TRF. I overlooked one issue: The string can also take this form:

"1 abcdef 234"

"23 abcdef 567"

I only want to extract the first numbers(1 and 23). If I go head with the mentioned regex I will still be stuck with the digit-characters I don't want.

Re: Isolate and extract numeric values from a string and convert to int

TRF — Mon, 17 Feb 2020 13:31:33 GMT

If you know the value you want to extract is placed at the beginning, use this one:
row1.yourField.replaceAll(" .*$", "")

Re: Isolate and extract numeric values from a string and convert to int

Anonymous — Thu, 09 Apr 2020 06:28:37 GMT

I tried this but its not working. my string is like this "abc 20mbps"

Re: Isolate and extract numeric values from a string and convert to int

manodwhb — Thu, 09 Apr 2020 07:09:38 GMT

Check the below expression.
row2.column==null?"":row2.column.replaceAll( "[^\\d]", "" )

Re: Isolate and extract numeric values from a string and convert to int

Anonymous — Thu, 09 Apr 2020 07:36:52 GMT

Thanks its works . If i have to extract mbps from the string "abc 20mbps" , how to do that?

Thanks in advance

Re: Isolate and extract numeric values from a string and convert to int

manodwhb — Thu, 09 Apr 2020 07:52:48 GMT

You need to extract 20mbps from that string?

Re: Isolate and extract numeric values from a string and convert to int

Anonymous — Thu, 09 Apr 2020 09:08:31 GMT

We want to create a date variable in numeric format based on this string variable mcdvoice.

Re: Isolate and extract numeric values from a string and convert to int

Anonymous — Thu, 09 Apr 2020 13:45:16 GMT

no, only mbps....

Re: Isolate and extract numeric values from a string and convert to int

gmobile1664879803 — Tue, 04 Oct 2022 10:38:40 GMT

Yes, according to 29.9% of those who responded to our study, Burger King serves the messiest burger. The chain is the same one where, according to readers of Mashed, you can also find the worst fish sandwiches and the grossest lavatories in the entire fast food industry (messiness, in the latter case, being a decidedly undesirable trait). With 20.62% of the vote, McDonald's takes second place in the messy burger category. Despite selling "billions and billions" of burgers, our readers believe that McDonald's serves the worst burgers. (Burger King placed second in that poll.) mcdvoice

Re: Isolate and extract numeric values from a string and convert to int

gmobile1664879803 — Tue, 04 Oct 2022 10:40:08 GMT

Burger King is indeed the messiest burger, according to 29.9% of the people who responded to our study. The worst fish sandwiches and grossest facilities in all of fast food may be found at the same chain, according to readers of Mashed (messiness, in the latter case, being a decidedly undesirable trait). McDonald's, which our readers deemed to serve the worst burgers despite selling "billions and billions," came in second place in the sloppy burger category with 20.62% of the vote. (In that vote, Burger King finished in second place.) dgcustomerfirst

Re: Isolate and extract numeric values from a string and convert to int

gmobile1664879803 — Tue, 04 Oct 2022 10:40:42 GMT

According to 29.9% of the participants in our study, Burger King does serve the messiest burger. Readers of Mashed have said that the same fast food chain has the worst fish sandwiches and the dirtiest facilities in all of fast food (messiness, in the latter case, being a decidedly undesirable trait). With 20.62% of the vote, McDonald's, which our readers thought served the worst burgers despite selling "billions and billions," landed in second place for sloppy burgers. Burger King came in second place in that vote. tellthebell

Re: Isolate and extract numeric values from a string and convert to int

gmobile1664879803 — Tue, 04 Oct 2022 10:41:19 GMT

Burger King does indeed serve the messiest burger, according to 29.9% of study participants. According to Mashed readers, the same fast food restaurant chain serves the worst fish sandwiches and maintains the poorest facilities of any fast food outlet (messiness, in the latter case, being a decidedly undesirable trait). McDonald's, which our readers believed provided the worst burgers while selling "billions and billions," came in second for sloppy burgers with 20.62% of the vote. In that poll, Burger King came in second place. talktowendys

Re: Isolate and extract numeric values from a string and convert to int

gmobile1664879803 — Tue, 04 Oct 2022 10:41:49 GMT

According to 29.9% of study participants, Burger King does actually serve the messiest burger. The same fast food restaurant brand, according to Mashed readers, offers the worst fish sandwiches and maintains the worst amenities of any fast food shop (messiness, in the latter case, being a decidedly undesirable trait). With 20.62% of the vote, McDonald's, which our readers thought served the worst burgers while selling "billions and billions," landed in second place for sloppy burgers. Burger King came in second in the survey. krogerstoresfeedback