topic Re: How to only keep data from a column that has a particular structure? in App Development

How to only keep data from a column that has a particular structure?

Manuel174102 — Thu, 28 Jul 2022 15:02:42 GMT

Hello, I have the following data. For my analisis I only need the AB numbers, they all have the same structure which is AB0*****. How can I only keep them?

Greetings

What I have

Number

AB028394

AB057493

AN48394

KA75984

AN47398

What I need:

Number

AB028394

AB857493

Re: How to only keep data from a column that has a particular structure?

Or — Thu, 28 Jul 2022 15:23:32 GMT

Load Number

From YourTable

Where WildMatch(Number,'AB*');

Re: How to only keep data from a column that has a particular structure?

Manuel174102 — Mon, 01 Aug 2022 07:10:08 GMT

thanks. it worked