CSV Data/Import Issues

R

riverspree

Afternoon,

While I not necessarily brand new to Excel I've honestly never com
across an issue quite like this, so hoping perhaps someone else has ha
a similar issue come up before.

First of all my apologies if a similar topic may have existed somewhere
but a search for terms I felt relevant to my issue did not yield an
appropriate answers. Also if anything is not 100% clear, please let m
know, as I am honestly not sure how exactly to word this.

The issue my coworker and I are having is as follows:

We have an Excel spreadsheet with varying data types and the firs
column contains various alphanumeric values. This first column has bee
set up with a custom format so that only 8 characters and always a
least 8 characters are given (spaces/blanks for missing values). Th
reasoning behind this is so that when we import the files into ou
mainframe the data is formatted correctly.

For example:
Cell A1 may contain the value DBLDLIFE
Cell A2 may contain the value LVRVDBLLT
Cell A3 may contain the value LCS

However, they should appear as follows when imported:
DBLDLIFE
LVRVDBLL
LCS_____ (Where _ is a blank character)

The problem occurs when we import, the custom format is not saved fo
some reason on this first column. Other values with custom formats d
save, however, they are all numeric values.

Is there no way to keep the formats on non-numerical values when savin
the file as a CSV?

We have tried importing as a tabbed delimited file as well as a .tx
file. A similar file was uploaded a few years ago but no one ca
remember if the change was done on the Excel side or on the mainfram
side after import. Any assistance is much appreciated, thank you
 
R

riverspree

riverspree;1601852 said:
Afternoon,

While I not necessarily brand new to Excel I've honestly never com
across an issue quite like this, so hoping perhaps someone else has ha
a similar issue come up before

First of all my apologies if a similar topic may have existed somewhere
but a search for terms I felt relevant to my issue did not yield an
appropriate answers. Also if anything is not 100% clear, please let m
know, as I am honestly not sure how exactly to word this

The issue my coworker and I are having is as follows

We have an Excel spreadsheet with varying data types and the firs
column contains various alphanumeric values. This first column has bee
set up with a custom format so that only 8 characters and always a
least 8 characters are given (spaces/blanks for missing values). Th
reasoning behind this is so that when we import the files into ou
mainframe the data is formatted correctly.

For example
Cell A1 may contain the value DBLDLIF
Cell A2 may contain the value LVRVDBLL
Cell A3 may contain the value LC

However, they should appear as follows when imported
DBLDLIF
LVRVDBL
LCS_____ (Where _ is a blank character

The problem occurs when we import, the custom format is not saved fo
some reason on this first column. Other values with custom formats d
save, however, they are all numeric values.

Is there no way to keep the formats on non-numerical values when savin
the file as a CSV

We have tried importing as a tabbed delimited file as well as a .tx
file. A similar file was uploaded a few years ago but no one ca
remember if the change was done on the Excel side or on the mainfram
side after import. Any assistance is much appreciated, thank you

Fell free to close this post, although the issue has not yet bee
resolved it appears that most of these threads have a hundred if no
thousands of views each but replies are few and far in-between. Going t
post elsewhere thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top