Trim Functionality

Part Shipped D000065432768 PR156790675 FedEx 10:20:30 745A88722B74 Over Night


how to trim to get the desired output?

thank you.

@Venkatesh_Chowdary split with respect to whitespace you will get array from that array select last array element you will get desired result.

Hi @Venkatesh_Chowdary,

Use Matches activity
Input : yourinput
Pattern : ([0-9A-Z]{12})(?= Over Night)
( [0-9A-Z]{12} )(?=.*)
Result: iEnumResult ->IEnumberable
after that use assign activity to get the data
strValue=iEnumResult (0).ToString()

Regards, Arivu


urvariable = urvariable.Split(" ".ToCharArray)(6).ToString

@arivu96 @indra"[dept]= ‘account’ ")

instead of “account” i want to give array variable. how can i give it. where dept is column name in my datatable

HI @Manjuts90,"[dept] like (‘account’,‘account1’)")

1 Like

@Venkatesh_Chowdary check attached file (1.8 KB)

1 Like

thank you @arivu96 @indra

it is working.