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 |
Hi Vineeth,
What if there is no space between "Name and X" or "x and Age". It is not taking subfield in different column
MahendraX 22 |
Prasad x55 |
Pranav |
Mahendra x 11 |
Prasad X 54 |
Pranav |
Try below
LOAD Capitalize(Trim(subfield(Upper(Name),'X',1))) as Name Inline [
Name
Mahendra X22
Prasadx 55
Pranav
Mahendrax 11
Prasad X54
Pranav
];
Thank You So much once again.
Perfect answer...