topic Re: subfield in App Development

subfield

nvijay5757 — Thu, 10 Nov 2022 03:47:10 GMT

Hi,

i am trying subfield function,

my data looks like this

2017_P558_08m_RB_20838_INTd_Single-FCS-Upper_RC_Acceleration_Custom Filter_100Hz_2O

from this i want to extract 08m_RB_20838

i have tried this only one string is showing like 08m

SubField(Test,'_',3) as Test1,

please help me thanks

Re: subfield

salonicdk28 — Thu, 10 Nov 2022 07:18:54 GMT

Hi,

Try this -

Left(Right(mid(Test,Index(Data,'_',2),Index(Test,'_',-9)),Len(mid(Test,Index(Test,'_',2),Index(Test,'_',-9)))-1),Len(mid(Test,Index(Test,'_',2),Index(Test,'_',-9)))-2) as Test1

Thanks!

Re: subfield

settu_periasamy — Thu, 10 Nov 2022 07:22:43 GMT

Hi,

Try with Index and Mid function.

=Mid(Text, Index(Text,'_',2)+1,Index(Text,_',5)-Index(Text,'_',2)-1)

Or combine the value using subfield

=SubField(Text,'_',3)&'_'&SubField(Text,'_',4)&'_'&SubField(Text,'_',5)

Re: subfield

nvijay5757 — Thu, 10 Nov 2022 08:04:48 GMT

Hi,

Thanks. subfield is working.