Thanks Vic!
Regards,
Chris Wineinger
ERP Specialist
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@...
Thanks Vic!
Regards,
Chris Wineinger
ERP Specialist
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@...
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
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
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
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