I have a column [name]=rohitan abcd@gmail.com
I need only rohitan text...
I don't need email ...
please anyone tell me..
Solved! Go to Solution.
Have you tried this?
LEFT([name],
FIND(" ", [name]) - 1
)
Assume that,
-there's a space between name and email ALWAYS.
-NO additional space within name.
BTW I would suggest using format like
Rohitan MiddleName LastName,abcd@gmail.com
or
Rohitan MiddleName LastName, abcd@gmail.com
or
Rohitan MiddleName LastName , abcd@gmail.com
then use,
TRIM(LEFT([name],
FIND(",", [name]) - 1
))
to get "Rohitan MiddleName LastName"
I have no idea what you're asking. Perhaps ask in your native language?
I have a column name column.
[name]=rohitan abcd@gmail.com
I need only rohitan text...in Virtual column..
I don't need email ...
I Need [Name virtual column]= rohitan
Have you tried this?
LEFT([name],
FIND(" ", [name]) - 1
)
Assume that,
-there's a space between name and email ALWAYS.
-NO additional space within name.
BTW I would suggest using format like
Rohitan MiddleName LastName,abcd@gmail.com
or
Rohitan MiddleName LastName, abcd@gmail.com
or
Rohitan MiddleName LastName , abcd@gmail.com
then use,
TRIM(LEFT([name],
FIND(",", [name]) - 1
))
to get "Rohitan MiddleName LastName"
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |