find space in cell value

[#1]

hi all,

i have column with values as below:

asvd as.wert

zxcv .wert

objective is to create new column by identifying the space and take all the left values for example

id                         calc

asvd as.wert          asvd

zxcv .wert              zxcv

please advise the expression

thanks

[Brice-SACCUCCI]

Hello,

try subfield(id, ' ', 1)

-BAA

[MayilVahanan]

HI

try like this

=SubField('zxcv .wert ',' ')

Load subfield(FieldName,' ') as FieldName from tablename;

Hope that helps