Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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!

 

 

14 Replies
gmobile1664879803
Contributor
Contributor

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

gmobile1664879803
Contributor
Contributor

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

gmobile1664879803
Contributor
Contributor

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

gmobile1664879803
Contributor
Contributor

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

gmobile1664879803
Contributor
Contributor

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