Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Field has values like below.
Desired output:
5as
1
nbg5
Thanks.
Left(Value,Index(Value,' ')-1)
Hi,
Try subfield(s, 'delimiter' [ , index ] )
Left(Value,Index(Value,' ')-1)
Subfield(field, ' ', 1)
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
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
Convert
2:50PM 0.08 to 2:50PM as below
=TIME(Time#('2:50PM 0.08','h:mmTT f.ff'),'h:mmTT')
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)
];
Thanks guys. Got it.