Fixed Length Records

Yahoo Archive
1
Try this: create a new page and use the following formula:



=Page1!A1&REPT(" ",10-Len(Page1!A1))



Copy the formula for all the applicable columns and rows changing the 10
to 30 or whatever length you're going for.

Export this page as csv.

Note: Don't remember if you use & or + but hopefully this will get you
started.



Butch



________________________________

From: Richard Bailey [mailto:rbailey@...]
Sent: Monday, November 22, 2004 8:58 AM
To: UserGroup
Subject: [Vantage] Fixed Length Records



A simple requirement but I can't see it!
I want to save the values from an Excel spreadsheet as fixed length CSV

Extract Part detail from Vantage (partnumber,description and counter) to
Excel.
Want to generate a csv file with fixed length records where partnum is
10
characters, description is 20 and counter is 1
e.g,
ABC123 ,Widget Type AAAA ,1
XYZ789 ,Widget Type Z. ,2
RSB123 ,Widget Type X Ver2 ,3

I can manage the partnumber using concatenate but I'm struggling with
the
description because it varies so much in length across our product
range.

Any bright ideas anyone?
Regards,
Richard

Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links





Yahoo! Groups Sponsor

ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129if9b0c/M=298184.5584357.6650215.3001176/
D=groups/S=1705007183:HM/EXP=1101230307/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>


<http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=group
s/S=:HM/A=2434971/rand=829364073>



________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



[Non-text portions of this message have been removed]
2
A simple requirement but I can't see it!
I want to save the values from an Excel spreadsheet as fixed length CSV

Extract Part detail from Vantage (partnumber,description and counter) to
Excel.
Want to generate a csv file with fixed length records where partnum is 10
characters, description is 20 and counter is 1
e.g,
ABC123 ,Widget Type AAAA ,1
XYZ789 ,Widget Type Z. ,2
RSB123 ,Widget Type X Ver2 ,3

I can manage the partnumber using concatenate but I'm struggling with the
description because it varies so much in length across our product range.

Any bright ideas anyone?
Regards,
Richard

Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...
3
I am not really following :( but how about just using crystal and a 3 left X
functions?



Frank Zeigafuse

Innovative Office Products

General Manager

Direct Phone: 610-559-6369

Email: fzeigafuse@...



-----Original Message-----
From: Richard Bailey [mailto:rbailey@...]
Sent: Monday, November 22, 2004 11:58 AM
To: UserGroup
Subject: [Vantage] Fixed Length Records


A simple requirement but I can't see it!
I want to save the values from an Excel spreadsheet as fixed length CSV

Extract Part detail from Vantage (partnumber,description and counter) to
Excel.
Want to generate a csv file with fixed length records where partnum is 10
characters, description is 20 and counter is 1
e.g,
ABC123 ,Widget Type AAAA ,1
XYZ789 ,Widget Type Z. ,2
RSB123 ,Widget Type X Ver2 ,3

I can manage the partnumber using concatenate but I'm struggling with the
description because it varies so much in length across our product range.

Any bright ideas anyone?
Regards,
Richard

Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129if9b0c/M=298184.5584357.6650215.3001176/D=gr
oups/S=1705007183:HM/EXP=1101230307/A=2434971/R=0/SIG=11eeoolb0/*http://www.
netflix.com/Default?mqso=60185400> click here

<http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=groups/S=
:HM/A=2434971/rand=829364073>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .



<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards

This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.

Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).



[Non-text portions of this message have been removed]
4
Create a calculated field for your description.
iif(LENGTH(PartDescription) < 20, PartDescription + FILL(" ",20 -
length(PartDescription)), SUBSTRING(PartDescription,20,))

Shirley

_____

From: Richard Bailey [mailto:rbailey@...]
Sent: Monday, November 22, 2004 11:58 AM
To: UserGroup
Subject: [Vantage] Fixed Length Records

A simple requirement but I can't see it!
I want to save the values from an Excel spreadsheet as fixed length CSV

Extract Part detail from Vantage (partnumber,description and counter) to
Excel.
Want to generate a csv file with fixed length records where partnum is 10
characters, description is 20 and counter is 1
e.g,
ABC123 ,Widget Type AAAA ,1
XYZ789 ,Widget Type Z. ,2
RSB123 ,Widget Type X Ver2 ,3

I can manage the partnumber using concatenate but I'm struggling with the
description because it varies so much in length across our product range.

Any bright ideas anyone?
Regards,
Richard

Richard Bailey
Dudley Industries
W:+44(0)1253 738311
M:+44(0)7836 550360
Mailto: rbailey@...



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129if9b0c/M=298184.5584357.6650215.3001176/D=gr
oups/S=1705007183:HM/EXP=1101230307/A=2434971/R=0/SIG=11eeoolb0/*http:/www.n
etflix.com/Default?mqso=60185400> click here


<http://us.adserver.yahoo.com/l?M=298184.5584357.6650215.3001176/D=groups/S=
:HM/A=2434971/rand=829364073>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

Tracking #: F98C5E1F122CF3489043243C24D0000AFC4DD882


[Non-text portions of this message have been removed]