Issue with a DT column split by position

Help Studio
1

im pulling in some data from excel into a DT. i need to simply split one column. i need to assign the right 9 characters. im struggling. any advice would be appreciated

This image depicts a spreadsheet with columns labeled DCAS UID, Sequence Number, Network Activity, Standard Document Nbr (PIIN), Cost Code, Quantity Paid, Converted Amt, Unit Price, Network, and Activity, with a highlighted section showing the Cost Code column and an annotation noting "just need right 9". (Captioned by AI)
This image depicts a spreadsheet with columns labeled DCAS UID, Sequence Number, Network Activity, Standard Document Nbr (PIIN), Cost Code, Quantity Paid, Converted Amt, Unit Price, Network, and Activity, with a highlighted section showing the Cost Code column and an annotation noting "just need right 9". (Captioned by AI)1138×130 7.49 KB

The image shows an assignment operation in a UiPath workflow, where the value of "row("Cost Code").Split('9130').ToString" is being assigned to the variable "NINSplit." (Captioned by AI)

2

IMG_2370
IMG_23704032×2268 3.32 MB

Is this u looking for ?

3

Hi @Waterfowl_Waterfowl_hunte

row("YourColumnName").ToString().Substring(Math.Max(0, row("YourColumnName").ToString().Length - 9))

Regards,

4

This is exactly it. thank you. I tried for 2 hours. i appreciate the education.

1 Like
5

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