Input:
Part Shipped D000065432768 PR156790675 FedEx 10:20:30 745A88722B74 Over Night
output:
745A88722B74
how to trim to get the desired output?
thank you.
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.
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
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