Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Converting CSV to ascii format
Top Forums Shell Programming and Scripting Converting CSV to ascii format Post 302593309 by Johanni on Thursday 26th of January 2012 12:40:12 PM
Old 01-26-2012
Converting CSV to ascii format
Hej All,

I have a file like this which is a comma dilimited:

input:

Code:
6000318,-263.011520678,-59.05869872409,587.67924868792
6000319,-265.6996842902,-50.24902479999,590.65693082607
6000320,-238.1333898366,-288.801232595,633.75332173496
6000321,-238.0466734864,-290.7217772662,623.60922656308
6000322,-237.8308371431,-291.5919339073,613.85206092817
6000323,-237.6900817526,-281.0114436973,613.12390164076
6000324,-238.0551925104,-270.3998913848,611.9122076891
6000325,-237.7062987535,-279.5289804322,623.0771105491
6000326,-237.7545552067,-276.8706392,633.45978643332
6000327,-237.8064447543,-268.6579344511,621.6766956356
6000328,-237.8039226993,-273.3144349458,643.99521886477
6000329,-237.7138565922,-265.9359211197,632.01000386728
6000330,-237.699411038,-260.1218696827,643.38639576584
6000331,-238.037499527,-252.9476448912,636.14668632827
6000332,-238.5361360976,-243.2849203525,637.19146375821


and want to convert it to an ascii file, which the first column is 8bit and other columns are 16 bit and the output would be like this:

output:

Code:
 6000318  -263.011520678 -59.05869872409 587.67924868792
 6000319 -265.6996842902 -50.24902479999 590.65693082607
 6000320 -238.1333898366  -288.801232595 633.75332173496
 6000321 -238.0466734864 -290.7217772662 623.60922656308
 6000322 -237.8308371431 -291.5919339073 613.85206092817
 6000323 -237.6900817526 -281.0114436973 613.12390164076
 6000324 -238.0551925104 -270.3998913848  611.9122076891
 6000325 -237.7062987535 -279.5289804322  623.0771105491
 6000326 -237.7545552067    -276.8706392 633.45978643332
 6000327 -237.8064447543 -268.6579344511  621.6766956356
 6000328 -237.8039226993 -273.3144349458 643.99521886477
 6000329 -237.7138565922 -265.9359211197 632.01000386728
 6000330  -237.699411038 -260.1218696827 643.38639576584
 6000331  -238.037499527 -252.9476448912 636.14668632827
 6000332 -238.5361360976 -243.2849203525 637.19146375821

How could I do this conversion with bash scripting?

tnx
 

10 More Discussions You Might Find Interesting

1. Programming

converting hex to ascii

Hi everyone! I was wondering if anyone knows how to change hex code back into ascii. when i process a form: " / " turn to " %2F " " @ " turns to " %40 " " ' " turns to " %27 " " ( " turns to " %28 " " ) " turns to " %29 " this is my code so far: order.txt thanks, primal p.s.... (1 Reply)
Discussion started by: primal
1 Replies

2. UNIX for Advanced & Expert Users

converting Opentype to ASCII (for groff)

I'm trying to convert different versions of helvetica neue from Opentype to ascii so that groff can use them in conjunction with VI (I believe everything is printed to postscript after). Ultimately i need to be able to use these specific helvetica fonts in VI, but in order to do this i must convert... (1 Reply)
Discussion started by: abby
1 Replies

3. UNIX for Advanced & Expert Users

Converting ASCII to Binary mode

Dear All, Business Users are transfering ( FTP ) a CSV file into the IBM AIX box with transfer mode as ASCII. But I want to convert the CSV file from ASCII mode into binary mode, as my script expects file in binary mode. Is it possible to do through Unix commands? Thanks in Advance, RK (1 Reply)
Discussion started by: srajeshmca
1 Replies

4. Shell Programming and Scripting

converting text to csv format

I am trying to check each line and based on first two digits, the comma needs to be place. I checked in the earlier post where the text is converted to csv with a tab delimited. Here is the test file that needs to be changed to csv 11 051701 22 051701 330123405170105170112345... (13 Replies)
Discussion started by: gthokala
13 Replies

5. Shell Programming and Scripting

converting config file to csv format

Hello, For 2 days now i've been searching for a solution to this. I am now beginning to doubt this is even possible. It's even harder when you don't know how to search for it. (which keywords generate enough relevancy etc..) I need to parse a config file to generate a CSV file in return. It... (7 Replies)
Discussion started by: zer0dvide
7 Replies

6. UNIX for Dummies Questions & Answers

To convert multi format file to a readable ascii format

Hi I have a file which has ascii , binary, binary decimal coded,decimal & hexadecimal data with lot of special characters (like öƒ.ƒ.„İİ¡Š·œƒ.„İİ¡Š· ) in it. I want to standardize the file into ASCII format & later use that as source . Can any one suggest a way a logic to convert such... (5 Replies)
Discussion started by: gaur.deepti
5 Replies

7. UNIX for Advanced & Expert Users

Cutting two colums and converting them to ascii (.txt) format

Hello Gurus, I have a file in which two columns contains binary data i want to cut those two binary columns convert them to ascii and process the file. i tried using cut command..i am able to cut but how can i convert them from binary to ascii and paste them in their original position. ... (1 Reply)
Discussion started by: mora
1 Replies

8. Shell Programming and Scripting

Converting hex to ascii/decimal

I am writing a bash script to do some parsing on a log and I am running into a problem when it comes to converting only certain sections of the file from hex to ascii or hex to decimal. Data Example: The hex values after Hardware and SW Version I need to convert from Hex to ASCII and the... (16 Replies)
Discussion started by: Shiftkey
16 Replies

9. Shell Programming and Scripting

Format problem while converting text file to csv

Hi , I need a help in following scenario.I tried searching in google but couldn't able to find the exact answer. Sorry if i am re-posting already answered query. While i am trying to convert into log file into csv i couldn't able to get the format which i am looking for. I converted file... (4 Replies)
Discussion started by: varmas424
4 Replies

10. Shell Programming and Scripting

Converting csv to html format

Below is the code I have - How can I convert the data in the csv into 3 tables in html. instead of 1 table. Attached is the format I am getting. (1 Reply)
Discussion started by: archana25
1 Replies

LEARN ABOUT OPENSOLARIS

iconv_mac_cyr

iconv_mac_cyr(5)                                        Standards, Environments, and Macros                                       iconv_mac_cyr(5)

NAME

       iconv_mac_cyr - code set conversion tables for Macintosh Cyrillic

DESCRIPTION

       The following code set conversions are supported:

       +---------------------------------------------------------------------+
       |                   Code Set Conversions Supported                    |
       +--------------+--------+--------------+--------+---------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |       Target        |
       +--------------+--------+--------------+--------+---------------------+
       |Output        |        |              |        |                     |
       +--------------+--------+--------------+--------+---------------------+
       |Mac Cyrillic  |mac     |ISO 8859-5    |iso5    | ISO 8859-5 Cyrillic |
       +--------------+--------+--------------+--------+---------------------+
       |Mac Cyrillic  |mac     |KOI8-R        |koi8    | KOI8-R              |
       +--------------+--------+--------------+--------+---------------------+
       |Mac Cyrillic  |mac     |PC Cyrillic   |alt     | Alternative PC      |
       +--------------+--------+--------------+--------+---------------------+
       |Cyrillic      |        |              |        |                     |
       +--------------+--------+--------------+--------+---------------------+
       |Mac Cyrillic  |mac     |MS 1251       |win5    | Windows Cyrillic    |
       +--------------+--------+--------------+--------+---------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   Mac Cyrillic to ISO 8859-5
       For the conversion of Mac Cyrillic to ISO 8859-5, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |                     Conversions Performed                       |
       | Mac Cyrillic     ISO 8859-5      Mac Cyrillic      ISO 8859-5   |
       |24               4               276              252            |
       |200              260             277              372            |
       |201              261             300              370            |
       |202              262             301              245            |
       |203              263             302-311          40             |
       |204              264             312              240            |
       |205              265             313              242            |
       |206              266             314              362            |
       |207              267             315              254            |
       |210              270             316              374            |
       |211              271             317              365            |
       |212              272             320-327          40             |
       |213              273             330              256            |
       |214              274             331              376            |
       |215              275             332              257            |
       |216              276             333              377            |
       |217              277             334              360            |
       |220              300             335              241            |
       |221              301             336              361            |
       |222              302             337              357            |
       |223              303             340              320            |
       |224              304             341              321            |
       |225              305             342              322            |
       |226              306             343              323            |
       |227              307             344              324            |
       |230              310             345              325            |
       |231              311             346              326            |
       |232              312             347              327            |
       |233              313             350              330            |
       |234              314             351              331            |
       |235              315             352              332            |
       |236              316             353              333            |
       |237              317             354              334            |
       |240-246          40              355              335            |
       |247              246             356              336            |
       |250-252          40              357              337            |
       |253              242             360              340            |
       |254              362             361              341            |
       |255              40              362              342            |
       |256              243             363              343            |
       |257              363             364              344            |
       |260-263          40              365              345            |
       |264              366             366              346            |
       |265-266          40              367              347            |
       |267              250             370              350            |
       |270              244             371              351            |
       |271              364             372              352            |
       |272              247             373              353            |
       |273              367             374              354            |
       |274              251             375              355            |
       |275              371             376              356            |
       |375              370                                             |
       +-----------------------------------------------------------------+

   Mac Cyrillic to KOI8-R
       For the conversion of Mac Cyrillic to KOI8-R, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       | Mac Cyrillic  |    KOI8-R      | Mac Cyrillic   |    KOI8-R     |
       |24             | 4              |276             |272            |
       |200            | 341            |277             |252            |
       |201            | 342            |300             |250            |
       |202            | 367            |301             |265            |
       |203            | 347            |302-311         |40             |
       |204            | 344            |312             |240            |
       |205            | 345            |313             |261            |
       |206            | 366            |314             |241            |
       |207            | 372            |315             |274            |
       |210            | 351            |316             |254            |
       |211            | 352            |317             |245            |
       |212            | 353            |320-327         |40             |
       |213            | 354            |330             |276            |
       |214            | 355            |331             |256            |
       |215            | 356            |332             |277            |
       |216            | 357            |333             |257            |
       |217            | 360            |334             |260            |
       |220            | 362            |335             |263            |
       |221            | 363            |336             |243            |
       |222            | 364            |337             |321            |
       |223            | 365            |340             |301            |
       |224            | 346            |341             |302            |
       |225            | 350            |342             |327            |
       |226            | 343            |343             |307            |
       |227            | 376            |344             |304            |
       |230            | 373            |345             |305            |
       |231            | 375            |346             |326            |
       |232            | 377            |347             |332            |
       |233            | 371            |350             |311            |
       |234            | 370            |351             |312            |
       |235            | 374            |352             |313            |
       |236            | 340            |353             |314            |
       |237            | 361            |354             |315            |
       |240-246        | 40             |355             |316            |
       |247            | 266            |356             |317            |
       |250-252        | 40             |357             |320            |
       |253            | 261            |360             |322            |
       |254            | 241            |361             |323            |
       |255            | 40             |362             |324            |
       |256            | 262            |363             |325            |
       |257            | 242            |364             |306            |
       |260-263        | 40             |365             |310            |
       |264            | 246            |366             |303            |
       |265-266        | 40             |367             |336            |
       |267            | 270            |370             |333            |
       |270            | 264            |371             |335            |
       |271            | 244            |372             |337            |
       |272            | 267            |373             |331            |
       |273            | 247            |374             |330            |
       |274            | 271            |375             |334            |
       |275            | 251            |376             |300            |
       |375            | 370            |                |               |
       +---------------+----------------+----------------+---------------+

   Mac Cyrillic to PC Cyrillic
       For the conversion of Mac Cyrillic to PC Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       | Mac Cyrillic  |  PC Cyrillic   | Mac Cyrillic   | PC Cyrillic   |
       |24             | 4              |355             |255            |
       |240-334        | 40             |356             |256            |
       |335            | 360            |357             |257            |
       |336            | 361            |360             |340            |
       |337            | 357            |361             |341            |
       |340            | 240            |362             |342            |
       |341            | 241            |363             |343            |
       |342            | 242            |364             |344            |
       |343            | 243            |365             |345            |
       |344            | 244            |366             |346            |
       |345            | 245            |367             |347            |
       |346            | 246            |370             |350            |
       |347            | 247            |371             |351            |
       |350            | 250            |372             |352            |
       |351            | 251            |373             |353            |
       |352            | 252            |374             |354            |
       |353            | 253            |375             |355            |
       |354            | 254            |376             |356            |
       |303            | 366            |                |               |
       +---------------+----------------+----------------+---------------+

   Mac Cyrillic to MS 1251
       For the conversion of Mac Cyrillic to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       | Mac Cyrillic  |    MS 1251     | Mac Cyrillic   |   MS 1251     |
       |24             | 4              |255             |40             |
       |200            | 300            |256             |201            |
       |201            | 301            |257             |203            |
       |202            | 302            |260-263         |40             |
       |203            | 303            |264             |263            |
       |204            | 304            |266             |264            |
       |205            | 305            |267             |243            |
       |206            | 306            |270             |252            |
       |207            | 307            |271             |272            |
       |210            | 310            |272             |257            |
       |211            | 311            |273             |277            |
       |212            | 312            |274             |212            |
       |213            | 313            |275             |232            |
       |214            | 314            |276             |214            |
       |215            | 315            |277             |234            |
       |216            | 316            |300             |274            |
       |217            | 317            |301             |275            |
       |220            | 320            |302             |254            |
       |221            | 321            |303-306         |40             |
       |222            | 322            |307             |253            |
       |223            | 323            |310             |273            |
       |224            | 324            |311             |205            |
       |225            | 325            |312             |240            |
       |226            | 326            |313             |200            |
       |227            | 327            |314             |220            |
       |230            | 330            |315             |215            |
       |231            | 331            |316             |235            |
       |232            | 332            |317             |276            |
       |233            | 333            |320             |226            |
       |234            | 334            |321             |227            |
       |235            | 335            |322             |223            |
       |236            | 336            |323             |224            |
       |237            | 337            |324             |221            |
       |240            | 206            |325             |222            |
       |241            | 260            |326             |40             |
       |242            | 245            |327             |204            |
       |243            | 40             |330             |241            |
       |244            | 247            |331             |242            |
       |245            | 267            |332             |217            |
       |246            | 266            |333             |237            |
       |247            | 262            |334             |271            |
       |250            | 256            |335             |250            |
       |252            | 231            |336             |270            |
       |253            | 200            |337             |377            |
       |254            | 220            |362             |324            |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so             conversion modules

       /usr/lib/iconv/*.t              conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10                                                          18 Apr 1997                                                   iconv_mac_cyr(5)
All times are GMT -4. The time now is 03:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy