Trim Functionality

Learning Hub Academy Feedback
, ,
1

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

output:
745A88722B74

how to trim to get the desired output?

thank you.

2

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

3

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

4

@Venkatesh_Chowdary

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

5

@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

6

HI @Manjuts90,

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

8

@Venkatesh_Chowdary check attached file

TrimText.zip (1.8 KB)

9

thank you @arivu96 @indra

it is working.