how can I sort a saved search by a field that it's type text but it's value it's actually a number? is there a way to convert a text to a number in order to sort?

AI generated answer (using internal Slack threads):

In NetSuite, you can convert a text field to a number in a saved search by using a formula field. The TO_NUMBER() function can be used to convert the text into a number. Here's how you can do it: 1. Create a new saved search or edit an existing one. 2. In the Results tab, click on the 'New Field' button. 3. In the 'Summary Type' dropdown, select 'Group'. 4. In the 'Field' dropdown, select 'Formula (Numeric)'. 5. In the 'Formula' text box, enter

TO_NUMBER({your_field})

where 'your_field' is the internal ID of the field you want to convert. 6. Click 'Save'. This will create a new column in your saved search results where the text field values are converted to numbers. You can then sort your results by this new column. Please note that this method will only work if the text field values are actually numeric. If the text field contains non-numeric characters, the TO_NUMBER() function will return an error. If your text field contains multiple numbers separated by a character (like '/'), you would need to use additional functions to split the text and convert each part to a number. This can get complex and may not be possible in all cases. For example, if your text field contains '15/20/40', you could use the following formula to sum the numbers:

TO_NUMBER(SUBSTR({your_field}, 1, INSTR({your_field}, '/') - 1)) + TO_NUMBER(SUBSTR({your_field}, INSTR({your_field}, '/') + 1, INSTR(SUBSTR({your_field}, INSTR({your_field}, '/') + 1), '/') - 1)) + TO_NUMBER(SUBSTR({your_field}, INSTR(SUBSTR({your_field}, INSTR({your_field}, '/') + 1), '/') + INSTR({your_field}, '/') + 1))

. This formula splits the text at the '/' characters and converts each part to a number, then adds them together. However, this formula assumes that there are always two '/' characters in the text field. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******