topic Re: Separate or Trim Field into 2 values in App Development

Separate or Trim Field into 2 values

Thabang231 — Wed, 15 May 2024 15:27:07 GMT

Hi There, I would like assistance on separating field or trimming it into 2 parts, so i can connect that field with the other field from other file. see examples

DEV25, DEV29,DEV45,DEV19,PRO23,PRO353,PRO43,PRO22

I need to only be able to focus on the DEV or PRO part and separate them to numbers, because the field i want to connect with has only numbers such as 25,29,45,19,23,353,43,22,

Your help will be highly appreciated.

Re: Separate or Trim Field into 2 values

Or — Wed, 15 May 2024 15:28:36 GMT

Left(Field,3) and Mid(Field,4,999) should be the simplest way in this scenario.

Re: Separate or Trim Field into 2 values

Thabang231 — Wed, 15 May 2024 16:15:15 GMT

Thanks so much the solution works,

now i need to create a field which returns Yes else No,

in a scenario where field1 value is 3421 and if it matches with value on other data source field return Yes if not return No.

Re: Separate or Trim Field into 2 values

Sayed_Mannan — Wed, 15 May 2024 17:16:07 GMT

You can achieve this by using IF statement

IF(Field2=Field1,'yes','no') as flag

Where Field2 is other Data Source Field.

Please note for doing this you need to connect both tables first either making both fieldname common or by using joins, then you can apply above logic.

Re: Separate or Trim Field into 2 values

Sayed_Mannan — Wed, 15 May 2024 17:19:06 GMT

you can also apply below logic

Left(Field1,3) -> It will give Dev OR Pro
Right(Field1,(Len(Field1)-3)) -> It will give numbers i.e 25,29 etc

Re: Separate or Trim Field into 2 values

Thabang231 — Thu, 16 May 2024 07:28:32 GMT

Thank you @Or and @Sayed_Mannan The solutions worked.