Skip to main content
Solved

how to separate pincode into specific field?

  • September 5, 2023
  • 1 reply
  • 18 views
lakshmi_narayanan_t
Discovered Fame

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
 

 

Best answer by Rishi

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

 

 

View original
Did this topic help you find an answer to your question?

1 reply

Rishi
StreamSets Employee
Forum|alt.badge.img
  • RishiStreamSets Employee
  • StreamSets Employee
  • 96 replies
  • Answer
  • September 5, 2023

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

 

 

Reply


Terms & Conditions