String Format

Radzen Studio Angular
1

Hello,

In a datagrid, I have the following structure of string data in a column:

  • word_number_unnecessary
  • another_one_unncessary
  • next_unnecessary
    ...

Here, I need to strip the "_unnecessary" part of each row of this column. Can you please give me a clue how to do this? I checked the column's Format and FormatString properties but could not understand how can I use it?

Thanks,

2

Hi @ozgur_agi,

Is the "unnecessary" part of the column data? Can you paste here how the actual data looks in JSON format? Or a screenshot of it?

3

Hello,
Thank you for your quick reply.
I cannot show the actual data but a visualization is in the picture.

format_string
format_string735×137 3.25 KB

So, basically I need to strip out the part after the last underscore.

4

In that case you can use the replace method of the string to remove it. Try setting the Template property of the DataGrid column to something like ${data.column2.replace("_unnecessary", "")}

5

Thank you for this reply, it is actually working.

When I need regular expressions, how can I do that?

I tried:

  • ${data.column2.replace(/^(.*)_([A-Z]+)$/g,"\$1")}
  • ${data.column2.replace(/^(.*)_([A-Z]+)$/g,"$1")}

I actually need this since in other datagrids, I will have non constant string "_unnecessary" at the end of the data, like "_STRING", "_INT".

Best,

6

Hello,

can you please help with this regular expression question?

Thanks :slight_smile:

7

As far as I know Angular doesn't support regular expression literals in its Templates. You will need to add a method to your page.component.ts file which does the replace.

class YourPageComponent extends YourPageComponentGenerated {
     replace(value) {
        return value.replace(/^(.*)_([A-Z]+)$/g,"\$1");
     }
}

Then set the template like this:

${replace(data.column2)}

1 Like
8

Solved the issue.

Thank you @korchev :slight_smile: