Skip to Content (Press Enter)
UserImage.jpg
Kevin Perkins
860Views
8Comments
Solved
removing leading zeroes from text variable
Question

I have a input variable that contains leading zeroes. I need to removed the leading zeroes to use as a filter into a table. I can use 

s = s.replace(/^0+/, '')

to remove the leading zeroes via java script. But I cannot find out how to use this as part of a filter on a table. Any suggestions?

Thanks

Kevin

0
0
16 Dec 2019
Copy Link
2017-07-24 06-43-32
Erik Brzozowski
Solution

Hello Kevin, 


The result is in the Regex_Replace.result variable. 

  • In the first var1 I assign 00001500
  • In the second var1 I asign the result of the Regex_Replace to var1. You need this last step to update the original variable 





See solution in context
4
0
17 Dec 2019
Copy Link
2021-08-30 15-28-09
Leandro Correa

You can use the regex_replace action and assign to a variable and use it in the filter.

Regards,

Leandro.

1
0
16 Dec 2019
Copy Link
UserImage.jpg
Kevin Perkins

Leandro Correa wrote:

You can use the regex_replace action and assign to a variable and use it in the filter.

Regards,

Leandro.

Leandro

I tried using Regex_Replace with the text string with leading zeroes, the Pattern "/^0+/ and replace string "". This does not seem to work. It is not replacing my leading zeroes. You mention using the replace. How would that work with replacing the leading zeroes? I did seen any examples using the replace with regex.

Kevin


0
0
16 Dec 2019
Copy Link
2021-08-30 15-28-09
Leandro Correa

Or Just the Replace() function.

1
0
16 Dec 2019
Copy Link
2017-07-24 06-43-32
Erik Brzozowski
Solution

Hello Kevin, 


The result is in the Regex_Replace.result variable. 

  • In the first var1 I assign 00001500
  • In the second var1 I asign the result of the Regex_Replace to var1. You need this last step to update the original variable 





4
0
17 Dec 2019
Copy Link
2021-08-30 15-28-09
Leandro Correa

If you to convert the text var to integer using the TextToInteger() function will works too! ;)

0
0
17 Dec 2019
Copy Link
UserImage.jpg
Kevin Perkins

Leandro Correa wrote:

I had everything that Erik has provided but was using the "/" in the Pattern. Once I removed the "/", it worked. Thanks everyone for providing suggestions. 

 

If you to convert the text var to integer using the TextToInteger() function will works too! ;)



0
0
17 Dec 2019
Copy Link
UserImage.jpg
Kevin Perkins

Marked Erik's response as the solution. Again, thanks to everyone.

0
0
17 Dec 2019
Copy Link
2021-08-30 15-28-09
Leandro Correa

Glad to hear you solved it!

0
0
17 Dec 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.