[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Unstring "ing" a dynamic length input file
- Subject: RE: [sqr-users] Unstring "ing" a dynamic length input file
- From: Aleksandr Slobodyanik <aslobody@yahoo.com>
- Date: Wed, 21 Sep 2005 18:53:56 -0700 (PDT)
- Delivery-date: Wed, 21 Sep 2005 20:54:59 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=rLlp1ZRLB3Z03faXPPDSH+PmI4CruFDxy0WxmowbxL9vIOkdcMCp0FYtNAkupRSIdtU1/d2VrzWP5WCAuctpsiiLsWTvWS3St03p2tuIYZdsMvsv3XjrPdLwqkIAZeM8SSbSj2a8J/VtSliY4zPKlxZCewkEUjm8tC9ux9FJAh0=;
- In-reply-to: <CC5702C624CD4B4399F971F17C1E2E350DB4D3@itomae2km09.AD.QINTRA.COM>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Use instring() function.
I will provide code tomorrow night, coz all internet email blocked by firewall
at my work.
"Turner, Ivan" <Ivan.Turner@qwest.com> wrote:
Why can't you use unstring? You say the field delimiter it comma.
That's what unstring needs to work. I believe you would get nulls in
the variables that are not are superfluous.
-----Original Message-----
From: sqr-users-bounces+ivan.turner=qwest.com@sqrug.org
[mailto:sqr-users-bounces+ivan.turner=qwest.com@sqrug.org] On Behalf Of
Ashok Kuttan
Sent: Tuesday, August 23, 2005 1:02 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Unstring "ing" a dynamic length input file
I have a file whose length is dynamic. Employee A might have 5 columns,
whereas Employee B might have 10 columns. Hence I cannot use the
traditional Unstring command to place in variables. Since this file is a
comma delimited file, I was thinking of using "find" command to look for
commas and then store the respective values in an array. Can anyone help
me with the proper find loop or any other better solution ?
File layout example (just one line): E,010,4500
Any help will be appreciated.
Thanks
JR
---------------------------------
Start your day with Yahoo! - make it your home page
_______________________________________________
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
---------------------------------
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users