Last name

Not endorsed by or affiliated with SAP	Register \| Login
Not endorsed by or affiliated with SAP	Follow BOB on Twitter! (Opens a new window)
Index \| About	Sponsors \| Contact Us \| Calendar \| FAQ \| Rules and Guidelines \| Privacy Policy \| Search

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Last name

Search this topic... | Search DI: Designer and Job Design... | Search Box

Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design

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: 143

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

Display posts from previous:

Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design

Page 1 of 1 All times are GMT - 5 Hours

Jump to:

Index | About | FAQ | RAG | Privacy | Search | Register | Login
Get community updates via Twitter: Follow @BOB_Board

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0275 seconds using 17 queries. (SQL 0.0029 Parse 0.0009 Other 0.0238)
CCBot/2.0 (https://commoncrawl.org/faq/)

Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com