remove values after space in field

[#1]

Hi all

Field has values like below. 

Desired output:

5as

1

nbg5

Thanks.

[daveamz]

Hi,

Try subfield(s, 'delimiter' [ , index ] )

[MK_QSL · Accepted solution]

Left(Value,Index(Value,' ')-1)

[MarcoWedel]

Subfield(field, ' ', 1)

[saurabh5]

hi Koushik,

if you have two delimiters you can use the below expression,

=SubField(Replace(F1,',','-') ,'-',1)

where F1 is the field with your values.

Regards

Saurabh

[#6]

Thanks guys. Lets say I have something like

2:45AM - 2:50PM 0.08 (5)  or  8:30AM - 8PM 11.5 (3)

and I would like to display only  AM and PM values such as 2:45AM - 2:50PM ; 8:30AM - 8PM

Regards

[MK_QSL]

Convert

2:50PM 0.08 to 2:50PM as below

=TIME(Time#('2:50PM 0.08','h:mmTT f.ff'),'h:mmTT')

[anbu1984]

Load Subfield(Time,'P',1) & 'PM' Inline [

Time

2:45AM - 2:50PM 0.08 (5)

8:30AM - 8PM 11.5 (3) ];

Load SubField(Txt,' ',1) & ' - '  SubField(Txt,' ',3) & ' ; ' SubField(Txt,' ',7) & ' - '  SubField(Txt,' ',9) Inline [

Txt

2:45AM - 2:50PM 0.08 (5)  or  8:30AM - 8PM 11.5 (3)

];

[#9]

Thanks guys. Got it.