Excel row data has unwanted data how to remove

[lakshmi.mp]

Hi,

Excel row has some unwanted data how to remove the substring and continue with the required data.

If the string has date and followed by some characters means that needs to be removed.
The above attached text file is first row data of excel.
Please help me.

Thanks & Regards,
Lakshmi

[jack.chan]

refer to this
Excel.xaml (7.0 KB)

assuming txt is your excel text, assign
system.Text.RegularExpressions.Regex.Replace(txt, "(?m)([\d]{1,2}-[A-Z][a-z]{2}-[\d]{2}.*?$)", "")

to newTxt (string variable)

then write newTxt to another file
result:

[lakshmi.mp]

@jack.chan, The above solution worked thank you and how to remove unwanted spaces multiple lines.

Thanks,
Lakshmi

[lakshmi.mp]

@jack.chan ,

How to remove multiple blank lines in the text file.

Thanks,
Lakshmi

[jack.chan]

Excel.xaml (8.9 KB)

[lakshmi.mp]

Not able to remove the blank lines.

[supermanPunch (Arpan)]

Hi @lakshmi.mp ,

If you want to have the Output in the above manner, then you could use the below Expression :

textStr = System.Text.RegularExpressions.Regex.Replace(textStr,"(\r?\n){2,}",Environment.NewLine+Environment.NewLine)

Here, textStr variable contains the output of Read Text File Activity, we modify the value in the same variable and assign to the same variable, you can then use Write Text File Activity to save the value in a text file.

[jack.chan]

because those were originally there, you want them removed as well?

[lakshmi.mp]

@jack.chan , yes want to remove unwanted blank lines.

[lakshmi.mp]

@jack.chan Thanks a lot .

Its working now.

Thanks & Regards,
Lakshmi