How can I replace the value from the right column to current column and replicate the same

I have a column which is of type VWstring and contains both number and text.(refer "Gross Amount" column in screenshot attached) I want to filter the rows containing text and numbers separately. How can I do that? I tried using 'Isnumber' in formula tool but it is of no use as column type is VWstring.

Apart from that I also want to replace the value in the right column to current column, in the current column and repeat the same for the following columns. How can I do that?

Screenshot 2025-02-04 195644.png

Dynamic Processing

Accepted answers

davidskaife

Hi @Kartik21

For your first query you can use the following formula in the Filter tool. This will filter where the field contains letters only:

regex_match([Gross Amount],'[a-z]+')

For your second query, an example might be helpful as I'm not quite sure I understand what you're after

All comments

binu_acs

@Kartik21 use the regex_match function

davidskaife

Hi @Kartik21

For your first query you can use the following formula in the Filter tool. This will filter where the field contains letters only:

regex_match([Gross Amount],'[a-z]+')

For your second query, an example might be helpful as I'm not quite sure I understand what you're after

Kartik21

Thank you both of you. Problem is now solved. 😊👍

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335