String Manipulation in DataTable Question

[Dillon_Marius]

Hi Guys,
I’m extracting the Last Name but as can be seen there are cells with three words.
For cell with two words value it’s straight forward.
For cell with three words value, I want the middle value and last value
In this case (per ss), I want to extract: “Van Oord” as Last Name

Using either row("Name").ToString.Split(" "c).Last
or row("Name").ToString.Split(" "c).(1) will only extract one word value.

Can someone guide me on what to do if I want the middle and last value as Last Name?
Best I can think of atm is to use if condition to count substrings where if there are three values I extract index (1) and (2) as Last Name.

Update/Edit: The String Manipulation needs to work on both scenarios where there are two values words and three value words (in for each loop)

Additional reference:

[lrtetala (Lakshman Reddy)]

Hi @Dillon_Marius

Can you try with this

inputString = "Lakshman Reddy Tetala"
outputString = inputString.Substring(inputString.IndexOf(" ") + 1)

[lrtetala (Lakshman Reddy)]

@Dillon_Marius

I want the middle value and last value

[Dillon_Marius]

Hi @lrtetala

Appreciate the reply.
Could you show this formula in for each row form? (forgot to mention in the post)
Also does it work on both scenarios where there are two words value and three words value?

Thanks

[lrtetala (Lakshman Reddy)]

@Dillon_Marius

CurrentRow(0).ToString.Substring(CurrentRow(0).ToString.IndexOf(" ")+1)

Input

Output

[Dillon_Marius]

Awesome @lrtetala !

Thank you for the tailored answer.
Appreciate you!

[ptrobot]

@Dillon_Marius

row(“Name”).ToString.Split(" "c).Last

For Windows project (not Windows Legacy), you can also use:

row("Name").ToString.Split(" "c, 2).Last

The “2” argument is to indicate that you only want the string split in two parts.

[Dillon_Marius]

Wow.
That’s equally awesome! Easier to digest also. Thank you and Cheers @ptrobot !