How to remove middle string

Help
1

Hi all,
i have one excel which contains description like
“NEFT CR-KKBK0958-BHARAT FINAL LIMITED-BJ ALNZ LIFE INSNCE CO LTD-KKBKH191257”
i want to remove BHARAT FINAL LIMITED-BJ ALNZ LIFE INSNCE CO LTD
output is like NEFT CR-KKBK0958-KKBKH191257
here share u my exceltest.xlsx (9.4 KB)

2

Hi,
try this XAML
Sting Split.xaml (5.0 KB)
as i had only one test case i have made a regex hope it helps.
if you face any problems you can get back anytime.

3

@sayli here goes your xaml file buddysplit12.xaml (5.5 KB) i just used the text from the excel file.plz let me know if any thing goes wrong

1 Like
4

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