Subfield

[mahendragaur]

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

[mahendragaur]

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

[vinieme12]

Try below

LOAD Capitalize(Trim(subfield(Upper(Name),'X',1))) as Name Inline [

Name

Mahendra X22

Prasadx 55

Pranav

Mahendrax 11

Prasad X54

Pranav

];

[mahendragaur]

Thank You So much once again.

Perfect answer...