how to separate pincode into specific field?

- - Knowledge base
Product Updates
Events

30-Day Free Trial: It’s Never Been Easier To Get Started With StreamSets

1 year ago

Home
Community overview
StreamSets Platform
StreamSets Academy
how to separate pincode into specific field?

I had Pincode like alpha numeric how can i separate numeric value into specific field
this is field value -4900 B ICI RD BUT I WANT Output like -4990 and remainig another field like-B ICI RD

Page 1 / 1

Hi @lakshmi_narayanan_t You can try string manipulation with expression evaluator processor (i.e as below)

Reply

Couldn't find what you're looking for?

The StreamSets Community has your back.

Ask your question here!

Terms & Conditions

Sign up

Already have an account? Login

Social Login

Username *

E-mail address *

What I do... *

Data Leader Data Architect Data Engineer Data Scientist Other

Company *

Country *

Zip Code *

Marketing Communications

Yes No

Password *

I have read and Agree to the Website Terms of Service and I have read and acknowledged the Privacy Policy.

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.