Data Tools only work for Windows XP. Click Here for a solution

Written by:
7/28/2011 7:53 AM 

Question:

How do you write a series of sequential numbers to the records in the target?

Answer:

In the Map Fields tab, use the Serial() function in the RIFL expression builder to write an expression in the affected target field. Inside the parentheses, enter the starting ""number minus 1"" that you want written to the first target record. For example, if you want the first target record to contain ""1"", enter a zero, so the expression would look like this:

Serial(0)

You can also embed the Serial Function inside the Format Function to achieve special formatting of the target data, such as left-padding the value with zeros:

Format(Serial(0), ""00000"")

Trackback Print

Tags:

Categories:

Location: Blogs Pervasive DataTools

Your name:
Your email:
	(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel