Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Writing multiple outputs in to separate cells of CSV file Post 302908099 by RudiC on Thursday 3rd of July 2014 02:45:36 PM
Old 07-03-2014
1 .csv file will be imported into 1 sheet. It is not designed to address cells in other sheets, nor to address random cells. If you want an entry into A15, you need to do it like
Code:
,,,,,,,,,,,,,data

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

writing to a csv file

Hi buddies i have doubt. I 'm new to unix script and learning. I have a req. I need to find the values mentioned in the double quoutes of each line and write it into a csv file. How do I handle this? Please help me. SCTY_ISS_ID (SCTY_ISS_ID:Dec18Fixed.0:): "37927320080309" TRD_DT... (6 Replies)
Discussion started by: pstanand
6 Replies

2. Shell Programming and Scripting

How to create a CSV File by reading fields from separate files

SHELL SCRIPT Hi, I have 3 separate files within a folder. Every File contains data in a single column like File1 contains data mayank sushant dheeraj File2 contains DSA_AT MG_AT FLAT_09 File3 contains data 123123 232323 (2 Replies)
Discussion started by: mayanksargoch
2 Replies

3. Shell Programming and Scripting

Add color in CSV cells

hi, i have text file that file contains below information. Name,Roll,Mark,Total Sivasankar,2120,89,410 Raja,2212,87,425 i need to convert text file to CSV file also the heading(Name,Roll,Mark,Total) font should be BOLD and color should be RED. how can i set fonts in csv (5 Replies)
Discussion started by: rsivasan
5 Replies

4. Shell Programming and Scripting

Need help in writing a routine for sorting a CSV file

Hi, I have a CSV file in following manner: server1,env1,patch1 server1,env1,patch2 server1,env1,patch3 server1,env2,patch1 server1,env2,patch3 server2,env3,patch1 server2,env3,patch5 server2,env4,patch1 server3,env6,patch1 server3,env7,patch2 server3,env7,patch3 I want to... (6 Replies)
Discussion started by: avikaljain
6 Replies

5. Shell Programming and Scripting

Reading from a CSV and writing in same CSV file

Hi, I am tryng to read from a csv file and based on some grep command output I will modify one of the column in the same csv. Example:- Input CSV:- 20120829001415,noneAA,google.com 20120829001415,dfsafds,google.com 20120829001415,noneAA,google.com Intermediate Step:- If 2nd column of... (3 Replies)
Discussion started by: kmajumder
3 Replies

6. Shell Programming and Scripting

Need help with awk statement to break nth column in csv file into 3 separate columns

Hello Members, I have a csv file in the format below. Need help with awk statement to break nth column into 3 separate columns and export the changes to new file. input file --> file.csv cat file.csv|less "product/fruit/mango","location/asia/india","type/alphonso" need output in... (2 Replies)
Discussion started by: awk-admirer
2 Replies

7. Shell Programming and Scripting

Csv file separate using awk

Hi, I have file like below apple,orange,pineapple,pappya,guva,avocado want to store as apple orange pineapple pappya I tried below command to seprate first field command1: (3 Replies)
Discussion started by: stew
3 Replies

8. Shell Programming and Scripting

How to separate data coming in one column of CSV file?

I am running an ISQL command on Sybase DB and getting output of a query in an CSV file. The issue is that all the data comes in to the same column, i want them to be separated in different columns. SQL_COMMAND=command.sql file=file.txt formatFile=formatFile.txt report=report.csv echo... (1 Reply)
Discussion started by: Sharma331
1 Replies

9. Shell Programming and Scripting

Consolidating multiple outputs in one file

Dears, i am stuck here i have 3 scripts running at one time and all the three scripts finish at different time and each script generate 1 file with different name. so i will have three files. i dnt know which script finish first i want to have a script which check if all the there files are... (6 Replies)
Discussion started by: mirwasim
6 Replies

10. UNIX for Beginners Questions & Answers

How to Dump data into CSV file which is Separate by <tab>?

Dear Team, please help me to solve this problem using Linux command. I want to dump this data into an excel sheet, Suppose I have a string like: ABC PQR XYZ ASD then I expect output as a ABC XYZ PQR ASD (3 Replies)
Discussion started by: Shubham1182
3 Replies
thai/thcell.h(3)						      libthai							  thai/thcell.h(3)

NAME
thai/thcell.h - Thai string cell custering. SYNOPSIS
Data Structures struct thcell_t Thai char cell representation. Functions void th_init_cell (struct thcell_t *cell) Initialize a Thai cell. size_t th_next_cell (const thchar_t *s, size_t len, struct thcell_t *cell, int is_decomp_am) Get first cell from string. size_t th_prev_cell (const thchar_t *s, size_t pos, struct thcell_t *cell, int is_decomp_am) Get previous cell from string. size_t th_make_cells (const thchar_t *s, size_t len, struct thcell_t cells[], size_t *ncells, int is_decomp_am) Tokenize string into cells. Detailed Description Thai string cell custering. Function Documentation void th_init_cell (struct thcell_t *cell) Initialize a Thai cell. Parameters: cell : pointer to the cell to initialize Initializes values in the Thai cell struct. size_t th_make_cells (const thchar_t *s, size_tlen, struct thcell_tcells[], size_t *ncells, intis_decomp_am) Tokenize string into cells. Parameters: s : the string len : the length of string cells : the array of output cells buffer ncells : the address of integer storing the number of cells provided by the buffer, and to keep the number of resulting cells on return is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells Returns: total characters consumed Tokenizes the string bounded by s and len into cells, and stores at most *ncells resulting cells in the cells buffer. On return, *ncells is also set to the total cells stored in cells[]. size_t th_next_cell (const thchar_t *s, size_tlen, struct thcell_t *cell, intis_decomp_am) Get first cell from string. Parameters: s : the string len : the length of string cell : the output buffer is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells Returns: total chars consumed by the cell Gets first cell from the string bounded by s and len, and, if cell is not null, stores the cell data in it. size_t th_prev_cell (const thchar_t *s, size_tpos, struct thcell_t *cell, intis_decomp_am) Get previous cell from string. Parameters: s : the string pos : the position in string to get cell previous to cell : the output buffer is_decomp_am : whether SARA AM is to be decomposed into NIKHANIT and SARA AA and to be in separate cells Returns: total chars consumed by the cell Gets last cell from the string bounded by s and pos, and if cell is not null, stores the cell data in it. Author Generated automatically by Doxygen for libthai from the source code. Version 0.1.14 Tue Jun 17 2014 thai/thcell.h(3)
All times are GMT -4. The time now is 08:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy