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

[Anil_Babu_Samineni]

What was the expected output here

[#3]

hi ,

use subfield('fieldname','symbol(X)')

Regards,

Balakrishnan.R

[mahendragaur]

Expected Output:

Mahendra

Prasad

Pranav

Mahendra

Prasad

Pranav

[vinieme12 · Accepted solution]

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

];

[Anil_Babu_Samineni]

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

];

[annafuksa1]

try

SubField(YourField,' ',1)

[vinieme12]

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

];

[gerry_hdm]

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

[mahendragaur]

Thank you Buddy.