slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Find/Replace with Regular Expressions

Jordan Peacock
Posts: 2

Find/Replace with Regular Expressions Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Sep 06 11:10 AM

Hello

I'm feeling a little out of my depth here, as I've never programmed in VB and only just started using SalesLogix.

However, we have a bunch of poorly formatted data from a legacy program that we carried over into SalesLogix. All the data is crowded into the first cell, and the next 2 cells are void of data.

An example would be:
S#: ##### M#: ### P#: ##
all in the first cell, when in reality we want only the numbers, and in three different columns

There are a couple variations on this theme, but that's the gist of it. My primary question is; is this possible to script in SalesLogix? If so, where can I start to learn how to do that?

Thank you.

[Reply][Quote]

RJ Eaton
Posts: 234

Re: Find/Replace with Regular Expressions Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Sep 06 1:55 PM

Jordan yes you can create a small vb script and run it from a button inside of SLX to do what your asking..

The method I might try is:

1. Create a recordset of the data
2. Parse the field into seperate variables as you need them
3. Update the database with the return values after parsing.

I'm not sure if you need an example of code for that or just the concept.

Rich

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Find/Replace with Regular Expressions Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Sep 06 2:51 PM

Quote:

Originally posted by Jordan Peacock

Hello

I'm feeling a little out of my depth here, as I've never programmed in VB and only just started using SalesLogix.

.....
Thank you.

I'd strongly suggest you hook up w/someone to assist you and do a "technology transfer" to you. There are good folks out there who can get you thru this .. and a lot who don't know which end of the mouse to hold onto.

You could try to "hack" your way thru w/hints, etc.. but there's nothing lik e learning from a "master"

It will save you a lot of time and be well worth it.
--
rjl

[Reply][Quote]

Jordan Peacock
Posts: 2

Re: Find/Replace with Regular Expressions Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Sep 06 9:12 AM

Good advice. I've actually found some people to work with this; thanks for the excellent site and forums.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/26/2024 6:38:52 PM