Last name

system · September 9, 2019, 9:03am

Hi Team,

I have 1 column Name: “First Name” “Last name”.It cotains the data.I just wanted to select only the “last name” into staging table.Which function need to use.

Please advise

Thanks in advance

Regards
Rk

Rohit77 (BOB member since 2005-10-24)

system · September 9, 2019, 10:55am

Can you provide some example of your data?

BOBJFan (BOB member since 2011-09-24)

system · November 27, 2019, 10:52pm

you can use ‘word_ext’ string function

word_ext(“FieldName”, 2, ’ ')

Bobber19 (BOB member since 2019-11-27)