Trim Functionality

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

output:
745A88722B74

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
Properties
Input : yourinput
Pattern : ([0-9A-Z]{12})(?= Over Night)
or
( [0-9A-Z]{12} )(?=.*)
Result: iEnumResult ->IEnumberable
after that use assign activity to get the data
strValue=iEnumResult (0).ToString()

Regards, Arivu

@Venkatesh_Chowdary

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

@arivu96 @indra

Outputdatable.select("[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,

Outputdatable.select("[dept] like (‘account’,‘account1’)")

1 Like

@Venkatesh_Chowdary check attached file

TrimText.zip (1.8 KB)

1 Like

thank you @arivu96 @indra

it is working.