deleting leading zeroes from data file

[cmwirish]

Hi there,

 

I know this can be done ina an excel file but my boss wants to know if there is a way to delete leading zeroes from a data base; such as 000001. I just did an insert data (is that what it is called? sorry I am a graphics person - very right brain sided and lots of this is confusing) in my text box - everything worked wonderful except that we don't want the leading zeroes.

 

Any help would be greatly appreciated.

 

Sincerely,

 

chrissy

[Jordanh]

try this:

 

Var1 = parseInt(Field("YourField"), 10)

 

Return Var1

 

that should delete the zeros.

 

let me know if this fixes your problem

[rpaterick]

Is this just a sequence number campaign?

 

Since learning about how FP can do "custom" sequence numbers right in FP without a database file, I will never have to create an excel file and drag until I get the correct count.

 

Thanks to Dan for showing me how to do this.

[cmwirish]

Dear rpatrick,

 

Thank you for your help. I worked around the issue with excel for the file, but had a few moments down time so made a new file with zeroes and made a new rule "Deleting zeros", but kept getting a syntax error when trying to save the rule. I am really lost when it comes to all this - (but am a quick reader!) so will try to figure it out from the manual.

 

 

mmm not a sequence number campaign I don't think - not sure what that is...

 

Thank you again!

 

c

[Dan Korn]

If you copied Jordanh's code verbatim, you might get a syntax error because the keyword "return" is not correctly capitalized. Try this:

return Int(Field("YourField"));

[rpaterick]

mmm not a sequence number campaign I don't think - not sure what that is...

 

c

 

Are you creating a database file that is 1-XXXXX???

 

FP will eliminate the need for creating a data file just for a sequence number.

 

Basically you are starting at 1 and ending at "whatever number you would like."