Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replace a number

Status
Not open for further replies.
gabydrdoom

gabydrdoom

Programmer
Jul 1, 2020
12
RO

Hello
How do I replace a number with a string that has the last number identical to the number

Example:

Excel1
NR
1
1
1
2
2
2
3
3
3

Excel2
INT
int_RR_001
int_RR_002
int_RR_003
int_RR_004
int_RR_005

Thanks
 
Sort by date Sort by votes
The result will be form:

Excel3
Nr
int_RR_001
int_RR_001
int_RR_001
int_RR_002
int_RR_002
int_RR_002
int_RR_003
int_RR_003
int_RR_003
etc...
 
Upvote 0 Downvote
Gabydrdoom,

The result of
Code: 
TRANSFORM(theSourceOfTheNumber, "@RL int_RR_999")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SitesMasstec
  • Locked
  • Question
Conditional number formatting in report 3
Replies
9
Views
278
Chris Miller
Chris Miller
Dronner
  • Locked
  • Question
How do I get the column number of a cell in a foxpro grid Visually?
Replies
5
Views
263
Dronner
Dronner
Bondjames
  • Locked
  • Question
Page number x of y in reports
Replies
3
Views
171
Bondjames
Bondjames
Filip Brnic
  • Locked
  • Question
On init of a textbox, insert random numbers and letters
Replies
13
Views
314
Filip Brnic
Filip Brnic
carolx
  • Locked
  • Question
Setting up the Application so that only an Executable of a Specific Version Number is Allowed 5
2
Replies
25
Views
357
GriffMG
GriffMG

Part and Inventory Search

Sponsor

Back
Top