Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 23rd July 2010, 07:39
ashishjain's Avatar
ashishjain ashishjain is offline
Member
 
Join Date: Jan 2009
Location: Pune (INDIA)
Posts: 69
ashishjain is on a distinguished road
Baan: IVc - DB: oracle - OS: UNIX
Truncate leading zeros in exported excel file from BaaN
Baan: Baan IVc4
C/S: Both

Hi All,

We are havin a session to export some data from baan to excel. There is a string field of length 3 called "Revision Number" in our report. The excel file is delimited by pipe (|) symbol. When we delimit (text to column) this file the leading zeros of field "Revision Number" gets truncated. We want the record in excel must be as it is in baan table.

Example: Revision No. in BaaN table is 001, 010 etc. but in excel it's showing as 1, 10 respectively. We want the output as 001, 010 in excel.

Quick response would be appreciated.
__________________
Regards,
Ashish Jain
* You are the only one who can use your ability. It is an awesome responsibility *
Reply With Quote
Sponsored Links
  #2  
Old 23rd July 2010, 11:46
norwim's Avatar
norwim norwim is offline
Guru
 
Join Date: Oct 2001
Location: Germany Moenchengladbach
Posts: 450
norwim is on a distinguished road
Baan: some - DB: more - OS: many
Hi there,

this is a feature of excel (automagically formatting the imported data).
You have to declare the column as "text", then leading zeros will be kept.

regards

Norbert
__________________
Have a nice day
Reply With Quote
  #3  
Old 23rd July 2010, 18:41
shah_bs's Avatar
shah_bs shah_bs is offline
Guru
 
Join Date: Jan 2002
Location: Lewisville, Texas
Posts: 387
shah_bs is on a distinguished road
Baan: BAAN IVc3 with A&D2.2b - DB: ORACLE 9 - OS: HPUX
Since you are manually 'importing' the data into EXCEL, Norbert's suggestion is better - mark each column and specify what type it should be.

But the following will also work - but requires you to modify your session: if you enclose the field which has leading zeroes with a =" and ", then the leading zeros will be 'preserved'.

For example, if your output file is as follows:

="001"| 001
="A001"| A001

This has two columns. Save this as a text file and try your 'import' steps on it.
Reply With Quote
  #4  
Old 26th July 2010, 18:06
ashishjain's Avatar
ashishjain ashishjain is offline
Member
 
Join Date: Jan 2009
Location: Pune (INDIA)
Posts: 69
ashishjain is on a distinguished road
Baan: IVc - DB: oracle - OS: UNIX
Thanks shah. It works for me
__________________
Regards,
Ashish Jain
* You are the only one who can use your ability. It is an awesome responsibility *
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
OLE Zugriff von MS Word auf Baan Daten Locher Deutsches Forum 9 28th May 2006 20:32
seq.open berthe Miscellaneous 4 12th May 2005 10:20
Not authorized to run as user baan positive Tools Administration & Installation 7 29th June 2004 08:56
Baan World Users conference in Orlando chadwickh General Discussion & Chat 7 3rd November 2001 21:55
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44


All times are GMT +2. The time now is 08:43.


©2001-2017 - Baanboard.com - Baanforums.com