String Trim

Help Studio
, ,
1

Hello guys i have an excel with data containing
image

I want to remove only "-A " or “-B” in the last and should remove for any alphabet letter.

note this string length is not constant it may vary

2

Hi @Gokul_Murali

How about this Regular expression?

System.Text.RegularExpressions.Regex.Replace(YourString,"-\w$","").Tostring

Use this code in Invoke code activity

dt.AsEnumerable.ToList.ForEach(Sub(x) x("ColumnName") = system.Text.RegularExpressions.Regex.Replace(x("ColumnName").ToString,"-\w$","").ToString.trim)

image

Regard
Gokul

3

@Gokul_Murali

Please try this in invoke code after reading data into datatable dt and add a argument to invoke code dt with direction as in/out

dt.AsEnumerable.ToList.ForEach(sub(x) x("ColumNname") = System.Text.RegularExpressions.Regex.Match(x,".*(?=-[A-Z])").Value)

image

cheers

5

Hi @Gokul_Murali ,

Use the invoke code activity and keep dt as in/out argument:

dt.AsEnumerable.ToList.ForEach(Sub(x) x("ColumnName") = system.Text.RegularExpressions.Regex.Replace(x("ColumnName").ToString,"-\w$","").trim)

Regards,

6

@Gokul001 @vishal.kp

MicrosoftTeams-image (25)

Iam getting error like this.

7

@Anil_G

MicrosoftTeams-image (26)
MicrosoftTeams-image (26)786×331 18.3 KB

Iam getting error like this

8

Hi @Gokul_Murali ,

Can you share the workflow, to take a closer look?

Regards,

9

@Gokul_Murali

A small change which I missed, i gave only x inside match it should be x("YourColumname").ToString

dt.AsEnumerable.ToList.ForEach(sub(x) x("ColumNname") = System.Text.RegularExpressions.Regex.Match(x("ColumnName").ToString,".*(?=-[A-Z])").Value)

Hope this helps

Cheers

10

Hi @Gokul_Murali

I don’t receive any error

image
image794×333 15.2 KB

Can you try to update the system package and check it

Regards
Gokul

11

@Gokul001
Test.zip (9.5 KB)

please check the file that i have attached

12

@Anil_G

BlankProcess9.zip (9.5 KB)

Showing the same error

13

Hi @Gokul_Murali ,

In this workflow, you are passing a wrong variable as argument inside the Invoke Code activity.

image
image782×221 8.77 KB

I believe it should be dt and not data1.

14

@supermanPunch @Gokul001

Thankyou so much

15

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