How to remove unwanted characters at the end of the string?

Help Activities
, ,
1

Hi, I want to remove unwanted characters at the end of each row in attached excel sheet.
Namely I want to get rid of every character that starts with “VV” at the end of the string.

DT.xlsx (19.3 KB)

2

Hi @Palaniyappan. Could you please help me on this.

3

Hi @Sirimalla_Karthik_Chandra,
Do you have a particular format for the string you require, excluding the unwanted characters?

4

Hi @vishal.kp , thank you for replying. I’m attaching a excel file. I need the data to be looked as in column C. there is no specific format.

DT.xlsx (36.2 KB)

5

@Sirimalla_Karthik_Chandra, It would affect data if we randomly clear the unwanted characters from the string. If we can come up with a specific format for your string, e.g. Ends with a number or specific length, the output will be more accurate. :slight_smile:

6

Actually i’m extracting the data from a txt file. this is the vba code that im using currently “line.Substring(172,9)”. and I want to remove the characters that starts from “VV” in every string.

7

Hi @Sirimalla_Karthik_Chandra, can you check the sheet2 of the attached file and confirm if that is the desired output?DT.xlsx (30.2 KB)

1 Like
8

@vishal.kp , Thanks man. that’s the desired output. Could you please share the xaml file or could please share what are the activities you have used to get the output.

9

Here you go :slight_smile: SKC2.xaml (5.7 KB)

2 Likes
10

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