Trying to parse out a text file in a BAQ


(system) #1

Thanks Vic!

 

Regards,

 

Chris Wineinger

ERP Specialist

Interior Systems, Inc.

241 N Broadway Ste 600

Milwaukee, WI 53202

Office # 414.224.0957 X2051

Direct# 414.847.0701

Cell # 414.840.6594

 

IT related problem? Contact helpdesk@...

 


(system) #2

I'm trying to setup calculated fields in BAQ to break out a text file into several fields.

I know in SQL there's the Locate command where I can locate the first space, not sure what the progress version of this.

Also open to other ideas. trying to parse out the log text field in change log.

 

Thanks,

Chris Wineinger

ERP Specialist

Interior Systems Inc


(system) #3

Use the INDEX function. It doesn’t sound like it would do what you want, but it does.

 

Use INDEX() along with SUBSTRING()

 

 

 

INDEX Function

Returns an integer that indicates the position of the target string within the source string.

 

SYNTAX

source

A character expression.

 

target

A character expression whose position you want to locate in source. If target does not

exist within source, INDEX returns a 0.

 

starting

An integer that specifies at which left-most position in the string to start the search. For

example, INDEX("abcdefabcdef","abc",6) returns 7.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cwineinger@...
Sent: Friday, October 11, 2013 12:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Trying to parse out a text file in a BAQ

 

 

I'm trying to setup calculated fields in BAQ to break out a text file into several fields.

I know in SQL there's the Locate command where I can locate the first space, not sure what the progress version of this.

Also open to other ideas. trying to parse out the log text field in change log.

 

Thanks,

Chris Wineinger

ERP Specialist

Interior Systems Inc


(system) #4

Here is the online Progress reference guide:

 

INDEX()Â http://bit.ly/GJCce1

 

SUBSTRING()Â http://bit.ly/16Bvfpv

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cwineinger@...
Sent: Friday, October 11, 2013 12:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Trying to parse out a text file in a BAQ

 

 

I'm trying to setup calculated fields in BAQ to break out a text file into several fields.

I know in SQL there's the Locate command where I can locate the first space, not sure what the progress version of this.

Also open to other ideas. trying to parse out the log text field in change log.

 

Thanks,

Chris Wineinger

ERP Specialist

Interior Systems Inc


(system) #5

If you have SQL you can just build it as a SQL view and then use an External BAQ.  You end up with a view for each BAQ but they are insanely fast and upgrading them to E10 will be very simple since it's all SQL.


John 



---In vantage@yahoogroups.com, <vic.drecchio@...> wrote:

Here is the online Progress reference guide:

 

INDEX()  http://bit.ly/GJCce1

 

SUBSTRING()  http://bit.ly/16Bvfpv

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of cwineinger@...
Sent: Friday, October 11, 2013 12:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Trying to parse out a text file in a BAQ

 

 

I'm trying to setup calculated fields in BAQ to break out a text file into several fields.

I know in SQL there's the Locate command where I can locate the first space, not sure what the progress version of this.

Also open to other ideas. trying to parse out the log text field in change log.

 

Thanks,

Chris Wineinger

ERP Specialist

Interior Systems Inc