MVSFORUMS.com

sub · Beginner Joined: 30 Jan 2007 Posts: 20 Topics: 12

I have a file which looks like as given below
NO , NAME , ACCT NBR , AMT
01 , XXXXX , 00121232 , =" 20,000"
02 , AAAAA , 34354545 , ="200,000"
03 , RRRRR , 45454554 , ="150,000"

I am sending it by e-mail in .CSV format. The file should have only 4 columns but the AMT column is getting split at the comma when i open in the excel. The AMT value ="20,000" comes as ="20 in 4th column and 000" in the 5th column. If I don't use comma the excel is fine but can someone help me to get comma for the AMT column. Is there a solution to send the numbers with comma separator and not getting split into 2 columns?

Thanks
sub

kolusu · Posted: Mon Jan 26, 2009 12:29 pm Post subject:

sub,

Change the delimiter to Tab character(X'05') instead of comma . check this link for examples.

http://www.mvsforums.com/helpboards/viewtopic.php?p=1793#1793
_________________
Kolusu
www.linkedin.com/in/kolusu

bauer · Posted: Tue Jan 27, 2009 9:47 am Post subject:

Doesn't mean using TAB instead of comma to change the dataformat from CSV to TAB separated, with other extension at the pc.

I would prefere to use ; as delimiter.

Wyh is the equal sign part of the data? Removing the equal sign is the other possibility.

regards,
bauer

kolusu · Posted: Tue Jan 27, 2009 1:47 pm Post subject: