Author |
Message |
Rohit77 Principal Member


Joined: 24 Oct 2005
              Posts: 187 Location: Bangalore

|
Posted: Mon Sep 09, 2019 4:03 am Post subject: Last name |
|
|
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 |
|
Back to top |
|
 |
BOBJFan Principal Member


Joined: 24 Sep 2011
        Posts: 139

|
Posted: Mon Sep 09, 2019 5:55 am Post subject: Re: Last name |
|
|
Can you provide some example of your data? |
|
Back to top |
|
 |
Bobber19 Forum Member


Joined: 27 Nov 2019
Posts: 1

|
Posted: Wed Nov 27, 2019 5:52 pm Post subject: Re: Last name |
|
|
you can use 'word_ext' string function
word_ext("FieldName", 2, ' ') |
|
Back to top |
|
 |
|