Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have issues how to split full name into first name and last name and coma is there in between first name and last name
for example:
full name first name last name
Jose , alex jose alex
Ha, Rishi Ha Rishi
Siri , kanth Siri kanth
with subfield function
Source:
load * inline [
full name
Jose , alex
Ha, Rishi
Siri , kanth
] (delimiter is '@');
Left Join (Source)
load
[full name],
SubField([full name], ',', 1) as [first name],
SubField([full name], ',', 2) as [last name]
Resident Source;
with subfield function
Source:
load * inline [
full name
Jose , alex
Ha, Rishi
Siri , kanth
] (delimiter is '@');
Left Join (Source)
load
[full name],
SubField([full name], ',', 1) as [first name],
SubField([full name], ',', 2) as [last name]
Resident Source;
Use substring function:
LOAD [Full name]
,SubField([Full name], ',', 1) as [First name]
,SubField([Full name], ',', 2) as [Last name]
INLINE [
Full name
"Jose, Alex"
"Ha, Rishi"
"Siri, Kanth"
];
Results as you required: