[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Reading from a tab delimited file
- Subject: RE: [sqr-users] Reading from a tab delimited file
- From: "Overcashier, Patricia" <Patricia.Overcashier@aam.com>
- Date: Wed, 4 Oct 2006 14:54:53 -0400
- Delivery-date: Wed, 04 Oct 2006 14:57:41 -0400
- In-reply-to: <C852F4914A306E47A4164876318083F802D429E3@mpmail1>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: Acbn5Zf8+sjFoI+/RfShSz6GSNB73wAALbmQ
- Thread-topic: [sqr-users] Reading from a tab delimited file
Her is the code. I read int the file and unstring it by the tab into
variableks.
encode <09> into $tab
open 'MasterMatch.TXT' as 1 for-reading record=1500 status=#filestat
! read 1 into $in_rec:1500 status=#filestat
unstring $in_rec by $tab into
$EmplId
$Last_Name
$Location
$Empl_Type
$Email_Addr
-----Original Message-----
From: sqr-users-bounces+patricia.overcashier=aam.com@sqrug.org
[mailto:sqr-users-bounces+patricia.overcashier=aam.com@sqrug.org] On
Behalf Of Ryan, David
Sent: Wednesday, October 04, 2006 2:48 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Reading from a tab delimited file
Hello,
I'm trying to read from a tab delimited .txt file and insert values into
variables.
I do not now know what the length of each field within the file is.
Could someone provide an example that would allow me to
start at the beginning of a line, read from the beginning to the first
tab, insert into a variable; read from the first tab to second tab,
insert into a variable.....and so on...
thanks
The information contained in this email is strictly confidential and
subject to the Confidentiality Notice at
http://www.stratosglobal.com/email-privacy.html
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users