how to update multiple selected records?

[MikeG]

Re: how to update multiple selected records?

Thanks Al... I will try...

[MikeG]

Re: how to update multiple selected records?

Thanks Stan...
This did the trick... Thank you very much ...

[Al Buchholz]

Re: how to update multiple selected records?

I went a little farther than Stan to show what is happening..

Load this as an xbasic script and run it

namelist=<<%nl%
DeVante Parker*RR, SN156
Melvin Gordon*RR, SN45
Nelson Agholor*RR, SN178
Breshad Perriman*RR, SN115
Phillip Dorsett*RR, SN108
T.J. Yeldon*RR, SN576
Devin Smith*RR, SN121
Dorial Green-Beckham*RR, SN87
Devin Funchess*RR, SN126
Ameer Abdullah*RR, SN39
Jason Pierre-Paul*SN420
Paul Posluszny*SN639
Darrelle Revis*SN328
Haloti Ngata*SN255 
%nl%
msgg= ""
for each name in namelist

p1 = name+"~"
p2 = alltrim(name)+"~"
p3a = len(alltrim(name))
p3b = at("SN",name)+1
p3 = len(alltrim(name))- at("SN",name)+1
p4 = right(alltrim(name),len(alltrim(name))- at("SN",name)+1)
p5 = strtran(alltrim(name),right(alltrim(name),len(alltrim(name))- at("SN",name)+1),"")

msgg= msgg+ \
"p1: "+p1+crlf()+\
"p2: "+p2+crlf()+\
"p3a: "+p3a+crlf()+\
"p3b: "+p3b+crlf()+\
"p3: "+p3+crlf()+\
"p4: "+p4+crlf()+\
"p5: "+p5+crlf(2)

next name

a5_show_variable(msgg)

[Stan Mathews]

Re: how to update multiple selected records?

strtran(alltrim(name),right(alltrim(name),len(alltrim(name))- at("SN",name)+1),"")

this will leave the ", " or "*" but those are easily removed later.

[MikeG]

Re: how to update multiple selected records?

Mike

Can you give a more complete example of the data?

Instead of telling us about it in words, give a list of sample data with the complete value and how you want to select.

Thanks.

Al,
Here is a sample of the data that is listed in the Name Field : The SN# is always at the end but can vary in size, there could be from 1 to 4 digits after "SN"

DeVante Parker*RR, SN156
Melvin Gordon*RR, SN45
Nelson Agholor*RR, SN178
Breshad Perriman*RR, SN115
Phillip Dorsett*RR, SN108
T.J. Yeldon*RR, SN576
Devin Smith*RR, SN121
Dorial Green-Beckham*RR, SN87
Devin Funchess*RR, SN126
Ameer Abdullah*RR, SN39
Jason Pierre-Paul*SN420
Paul Posluszny*SN639
Darrelle Revis*SN328
Haloti Ngata*SN255

[Al Buchholz]

Re: how to update multiple selected records?

On the same lines of this thread.. I have created an Update Operation to delete part of the string in "Name" based off of the following:
The Field Name is "Name" the Expression is : STRTRAN(NAME,"SN1550""") and the Filter Expression is : right(alltrim(name),len("SN1550")) = "SN1550". I would change this to other SN#'s to delete many strings at one time.
Everything works fine...
I am now down to a bunch of records that have part of the string that starts with "SN" and end with a bunch of different numbers; IE: 207,159,483 etc. etc. , but only have a few related matches...
This is the last word in the string. Is there anyway, I can get the rest of these with one Expression ??? I have tried using ""SN***" with no results...

Mike

Can you give a more complete example of the data?

Instead of telling us about it in words, give a list of sample data with the complete value and how you want to select.

Thanks.

[Stan Mathews]

Re: how to update multiple selected records?

A bit confused but it seems you are looking for

left(name,2) = "SN"

[MikeG]

Re: how to update multiple selected records?

On the same lines of this thread.. I have created an Update Operation to delete part of the string in "Name" based off of the following:
The Field Name is "Name" the Expression is : STRTRAN(NAME,"SN1550""") and the Filter Expression is : right(alltrim(name),len("SN1550")) = "SN1550". I would change this to other SN#'s to delete many strings at one time.
Everything works fine...
I am now down to a bunch of records that have part of the string that starts with "SN" and end with a bunch of different numbers; IE: 207,159,483 etc. etc. , but only have a few related matches...
This is the last word in the string. Is there anyway, I can get the rest of these with one Expression ??? I have tried using ""SN***" with no results...

[fddizon]

Re: how to update multiple selected records?

problem solved

thanks Stan

[fddizon]

Re: how to update multiple selected records?

MoGrace,

it is linked only into a primary table for lookup. no transactions made yet
no records will be orphaned

[fddizon]

Re: how to update multiple selected records?

Thanks Stan

i will try

[MoGrace]

Re: how to update multiple selected records?

Is the Employee ID field used to link to other tables?

[Stan Mathews]

Re: how to update multiple selected records?

? strtran("TCM-MC-000777","TCM","TMC")
= "TMC-MC-000777"

So you could run an update operation on the Employee_ID field with the expression

strtran(Employee_ID,"TCM","TMC")

and if you wanted to be extra explicit filter for records where

left(Employee_ID,3) = "TCM"

[fddizon]

hi to all


its been a while the last time i used alpha five. im kinda rusty right now.
a client of mine came to a problem and i need to modify selected records on my employee table
filtered with card_expiry in between these dates 1/26/2018 to 04/27/2018
and id like to modify the Employee_ID 2nd and 3rd characters

here is the sample thats in the records
TCM-MC-000777
and should be
TMC-MC-000777

i dont know how to create the update operation
please help
thanks