Trimming Text

Learning Initatives Automation Starter
, ,
1

How to trim first and last letter in a sentence?

Example: I have a sentence that start and end with % , so i want to trim % from both start and end of the sentence.

2

Hi @Anusuya_R ,

Could you give a try on the below Expression :

yourStrVar.Trim("%".ToCharArray)
3

@Anusuya_R ,U can try.

string_len = YourString.Length

YourCutString = YourString.SubString(1,string_len-2)
4

Nope… It didnt work

5

I have set of rows with particular value.Not all the row value begins with $ so i think it wont work

6

@Anusuya_R ,Ok,there are have fixed number of words sames like “$”?Or it is random?

7

Hey!

Try like this

Input.Replace("%","").ToString.Trim

Reference:

Trim
Trim1011×557 18.9 KB

Regards,
NaNi

8

Hi @Anusuya_R ,

Could you show us How you have implemented it ?

In Addition, also give a try on the below :

yourStrVar.Trim.Trim("%".ToCharArray)

Do note that % was the symbol that you have mentioned earlier that you want to remove.

What is the actual set of characters that you want to Trim?

9

Hi @Anusuya_R
Assign InputString = InputString.Trim(" “c,”%"c)
This will remove empty spaces and % in start and end.
Try this and Please let me know if this worked or not

1 Like
10

Perfect… Its working !!!

1 Like
11

Hi,

I have a point to add here, If we are using Replace for ‘%’ then it will replace all % in the text. But If we used trim then with character then it will remove only in start and ends.

1 Like
12

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