I thought we talked about this before but I couldn’t find it in the archives. I have data from Excel. It is SSNs. Some begin with 00. An example is 001-12-1234. I’m losing the leading 00’s when importing into BO. Does anyone have the easy solution?
Cindy Clayton - Business Objects Consultant AT&T
336.698.2144
Give people more than they expect and do it cheerfully. Talk slowly but think quickly.
Smile when picking up the phone. The caller will hear it in your voice. Mind your own business.
Learn the rules then break some.
Judge your success by what you had to give up in order to get it.
Is your object a dimension or measure? If it’s a dimension, it should bring back the whole thing. Also, you might try formating it in Excel as a text string.
Michael Welter
Sr. Technical Analyst
AirTouch
I thought we talked about this before but I couldn’t find it in the archives. I have data from Excel. It is SSNs. Some begin with 00. An example is 001-12-1234. I’m losing the leading 00’s when importing into BO. Does anyone have the easy solution?
You might try this as a basis. You could expand it with more “IF’s and Else’s” to cover conditions where leading zero’s are 1, 2 or 3.
=If Length()=9 Then (“00”&) Else
is your SSN field.
I reckon the LeftPad function would be a lot easier to use, saving you a lot of if the elses…
alternatively, adding a single quote to the left of the values in excel will convert see to it that they’re stored as strings.
good luck,
mirko
“The information in this e.mail and any attachments is confidential and is intended for the addressee only. Reading, copying, disclosure or use by anybody else is not authorised. The contents do not represent the opinion of SGS SociÈtÈ GÈnÈrale de Surveillance Holding SA or any of its affiliates except to the extent that it relates to their official business. If you are not the intended recipient, please delete this message and any attachments and advise the sender by return e.mail”