Specific columns have hifen i need to take before value and it is for bulk uploaad

Hi team ,

I have a bulk data it is around 5lakhs.
I need to insert specific columns only with the code that is separated by hifen. Need to take before value of hifen remaining need to neglect. I will keep photo for reference and this should happen for 4lakh data.i don’t want to use for each because it will take more time. First photo is the actual data…second one is the resultant i need.please help me out… thanks in advance.


Hi @cbhavana ,
You can use regular expressions to extract only the codes.
image

Expression: ^\w{2,3}

Thanks & Regards,
Shubham Dutta

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.