Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I want to get the name from a column which contains either 'x' or 'X' character in between Name and Age. How can I get name using or functionality in SubField?
Mahendra X 22 |
Prasad x 55 |
Pranav |
Mahendra x 11 |
Prasad X 54 |
Pranav |
Try below
LOAD SubField(Name,if(findoneof(Name,'X'),' X ',' x '),1) as NAME,SubField(Name,if(findoneof(Name,'X'),' X ',' x '),2) as Age Inline [
Name
Mahendra X 22
Prasad x 55
Pranav
Mahendra x 11
Prasad X 54
Pranav
];
What was the expected output here
hi ,
use subfield('fieldname','symbol(X)')
Regards,
Balakrishnan.R
Expected Output:
Mahendra |
Prasad |
Pranav |
Mahendra |
Prasad |
Pranav |
Try below
LOAD SubField(Name,if(findoneof(Name,'X'),' X ',' x '),1) as NAME,SubField(Name,if(findoneof(Name,'X'),' X ',' x '),2) as Age Inline [
Name
Mahendra X 22
Prasad x 55
Pranav
Mahendra x 11
Prasad X 54
Pranav
];
Use this
LOAD SubField(Name,' ',1) as Name, RowNo() as ID Inline [
Name
Mahendra X 22
Prasad x 55
Pranav
Mahendra x 11
Prasad X 54
Pranav
];
try
SubField(YourField,' ',1)
or Just This
LOAD subfield(Capitalize(Name),' X ',1) as Name Inline [
Name
Mahendra X 22
Prasad x 55
Pranav
Mahendra x 11
Prasad X 54
Pranav
];
you are work with uper
Load *,
upper(subfield( uppername , 'X' ,1)) as NameNew2
;
load
upper(Name) as uppername,
upper(subfield( Name , 'X' ,1)) as NameNew
inline [Name
hallo x 22
hallihallo
myname X 46
];
greetings gerry
Thank you Buddy.