topic Re: Getting particular value from string in a new column in App Development

Getting particular value from string in a new column

poojashribanger — Tue, 30 Nov 2021 18:17:33 GMT

Hi,

I have one column which has value like 101,202,303 so for each ID i need to populate newcolumn using my Tran column.

condition is like i have to take value starting from '3' only.

expected Output

Any help would be kindly appreciated.

Thanks & Regards,

Poojashri

kaushiknsolanki — Fri, 02 Jul 2021 19:14:05 GMT

Try this.

Data:
Load * inline [
ID; Tran
101;101,201,301,401,501,601
102;302,504
103;109,303,200
104;204,140,309
105;304,205
] (delimiter is ';');

Temp:
Load ID, Tran,SubField(Tran,',') as NewField
Resident Data ;

Drop table Data;

Final:
NoConcatenate Load * Resident Temp where WildMatch(NewField,'3*');

Drop table Temp;

avinashelite — Sat, 03 Jul 2021 00:12:47 GMT

You could try like this also

Load ID, Tran,

SubField(Tran,',', wild match(Tran,'3*') ) as NewField
Resident Data ;

poojashribanger — Mon, 05 Jul 2021 06:20:40 GMT

Thanks Kaushik, It did work for me 🙂

kaushiknsolanki — Mon, 05 Jul 2021 06:21:40 GMT

Good to know that @poojashribanger.

Wish you also understood how to do such things.

poojashribanger — Mon, 05 Jul 2021 06:33:21 GMT

Yes, thanks i was adding the 3rd parameter because of that it was giving me wrong result.