how to split a word and get the first index value in component

Question

hi,i had a word like this “12345 - Data min”, i need to split this word based on - operator and get the first word.I had another requirement like split and save the words in another varaibleex : select * from emp;select * from customerquery variable should have splitted value like select * from empcan you help in implementing above scenario

ivysakh · Accepted Answer

Hi @rajeswarimyla,You can use expressions in a component to achieve this. An example is attached here for your reference.Cheers!Vysakh Indrasenan

rajeswarimyla · Answer

Thanks for your support, i can get the data successfully as expected.

Reply

Sign up

Login to the Ataccama Community

Scanning file for viruses.

This file cannot be downloaded