Sponsored Content
Full Discussion: Delimeter used in data
Top Forums Shell Programming and Scripting Delimeter used in data Post 102178 by hcclnoodles on Thursday 16th of March 2006 06:45:14 AM
Old 03-16-2006
ok, one of the deveolpers of the system that outputs the source file has just popped over to my desk saying theyre gonna change the delimiter to a * so all my problems have now been solved

thanks all for your input
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do you represent a field delimeter that is a space???

you know like if you want to work on a specified field in the password file. you would specify the field your interested in my telling the script that the fields are separated by a colon. now, my problem is that I want to specify a field that is not separated by a colon but by a space or tab... (1 Reply)
Discussion started by: TRUEST
1 Replies

2. Shell Programming and Scripting

Add Delimeter,

I want to add the delimiter in particular positions in one txt file. My file is : 123450000000000testing 898983920202020testfil . . . 1-5 -- after 5th position add , 6-10 -- after 10th position add , 11-7 -- like wise.. Expecting output is: 12345,0000000000,testing... (5 Replies)
Discussion started by: Jairaj
5 Replies

3. Shell Programming and Scripting

Count the delimeter from a file and delete the row if delimeter count doesnt match.

I have a file containing about 5 million rows, in the file there are some records which has extra delimiter at random position. (we dont know the positions), now we have to Count the delimeter from each row and if the count of delimeter is not matching then I want to delete those rows from the... (5 Replies)
Discussion started by: Akumar1
5 Replies

4. Shell Programming and Scripting

Attaching an end delimeter

Hi, I have a file below I want to attach an end delimeter '{}' after the time stamp input file 22113350444356|Status:Assigned,Notes: APP PRD |Sep 28 2011 12:12:55:660PM 22113350398356|Status:Assigned,Notes: APP PRD |Sep 28 2011 12:12:55:660AM 22113350621356|Status:Assigned,Notes:... (6 Replies)
Discussion started by: ratheeshjulk
6 Replies

5. Shell Programming and Scripting

missing comma delimeter in columns

hi if comma delimeter missing in columns treat them as bad file and if it is not then gudfiles. only checking columns not data. id,name,sal,deptno =======> gudfile 1,awa,200,10 2,aba,100,20 3,cdc,300,30 idname,sal,deptno ========> badfile since its missing (.)... (8 Replies)
Discussion started by: awais290
8 Replies

6. Shell Programming and Scripting

Replacing the delimeter with other delimeter

Hi Friends, I have a file1.txt as below 29123973Ç2012-0529Ç35310124Ç000000000004762Ç00010Ç20Ç390ÇÇÇÇF 29123974Ç20120529Ç35310125Ç0000000000046770Ç00010Ç20Ç390ÇÇÇÇF 29123975Ç20120529Ç35310126Ç0000000000046804Ç00010Ç20Ç390ÇÇÇÇF 29123976Ç20120529Ç35310127Ç0000000000044820Ç00010Ç20Ç390ÇÇÇÇF i have a file2.txt... (4 Replies)
Discussion started by: i150371485
4 Replies

7. Shell Programming and Scripting

Put delimeter in data based on value

Hi Friends, I have a file as below source.txt 12345JackYKing32N 1235 JulyYoig 31N i am using cut command for cutting the fields cut -c 1-5 source.txt 12345 1235 like above i have to use each time to cut all the fieds manually. I have a file(pre.txt) which tells... (3 Replies)
Discussion started by: i150371485
3 Replies

8. Shell Programming and Scripting

awk substr delimeter

Hi All, I have an awk command that uses the substr function - At the moment I know the length of the values so can use the example below i.e substr(i,0,1) However in future these lengths may change so wondered if you can use a delimiter within a substr? Like in bash you could use cut -d ';',... (6 Replies)
Discussion started by: Ads89
6 Replies

9. Shell Programming and Scripting

Replace every second instance of delimeter

Hi, Need help on replacing every second instance of delimeter. Scenario: var="Name1,Value1,Name2,Value2,Name3,Value3,Name4,Value" I want every second "," to replace with "|" I tried like below echo $var| sed 's/,/|/2' But, it's not working. Expected output: ... (4 Replies)
Discussion started by: Sumanthsv
4 Replies

10. Shell Programming and Scripting

awk with tab delimeter

Hi Team below test file contains tab delimeter file and i am excepting the number of files 3. File : test.txt a b c awk -vFPAT='\t' -vOFS="\t" -v a="0" -v b="10" ' NR>a {if (NF != b ) print NR"@"NF }' test.txt current output is 1@2 required output is 1@3 Cloud you please help... (7 Replies)
Discussion started by: bmk123
7 Replies
dc(1)							      General Commands Manual							     dc(1)

NAME
dc - desk calculator SYNOPSIS
[file] DESCRIPTION
is an arbitrary precision arithmetic package. Ordinarily it operates on decimal integers, but one may specify an input base, output base, and a number of fractional digits to be maintained. (See bc(1), a preprocessor for that provides infix notation and a C-like syntax that implements functions. also provides reasonable control structures for programs.) The overall structure of is a stacking (reverse Polish) calculator. If an argument is given, input is taken from that file until its end, then from the standard input. An end of file on stan- dard input or the command stop dc. The following constructions are recognized: number The value of the number is pushed on the stack. A number is an unbroken string of the digits or It can be preceded by an underscore to input a negative number. Numbers can contain decimal points. The top two values on the stack are added subtracted multiplied divided remaindered or exponentiated The two entries are popped off the stack; the result is pushed on the stack in their place. Any fractional part of an exponent is ignored and a warning generated. The remainder is calculated according to the current scale factor; it is not the integer modulus function. yields .1 (one tenth) if scale is 1 because is 2.3 with .1 as the remainder. The top of the stack is popped and stored into a register named x, where x can be any character. If the is capitalized, x is treated as a stack and the value is pushed on it. The value in register x is pushed on the stack. Register x is not altered. All registers start with zero value. If the is capitalized, register x is treated as a stack and its top value is popped onto the main stack. The top value on the stack is duplicated. The top value on the stack is printed. The top value remains unchanged. interprets the top of the stack as an ASCII string, removes it, and prints it. All values on the stack are printed. exits the program. If executing a string, the recursion level is popped by two. If is capitalized, the top value on the stack is popped and the string execution level is popped by that value. treats the top element of the stack as a character string and executes it as a string of commands. replaces the number on the top of the stack with its scale factor. puts the bracketed ASCII string onto the top of the stack. Strings can be nested by using nested pairs of brackets. The top two elements of the stack are popped and compared. Register x is evaluated if they obey the stated relation. Replaces the top element on the stack by its square root. Any existing fractional part of the argument is taken into account, but otherwise the scale factor is ignored. Interprets the rest of the line as an HP-UX system command (unless the next character is or in which case appropriate relational operator above is used). All values on the stack are popped. The top value on the stack is popped and used as the number radix for further input. pushes the input base on the top of the stack. The top value on the stack is popped and used as the number radix for further output. See below for notes on output base. pushes the output base on the top of the stack. the top of the stack is popped, and that value is used as a non-negative scale factor: the appropriate number of places are printed on output, and maintained during multipli- cation, division, and exponentiation. The interaction of scale factor, input base, and output base will be reason- able if all are changed together. pushes the scale factor on the top of the stack. The stack level is pushed onto the stack. replaces the number on the top of the stack with its length. A line of input is taken from the input source (usually the terminal) and executed. Used by for array operations. Generates debugging output for itself. The input base may be any number, but only the digits 0-9 and A-F are available for input, thus limiting the usefulness of bases outside the range 1-16. All 16 possible digits may be used in any base; they always take their conventional values. The output base may be any number. Bases in the range of 2-16 generate the "usual" results, with the letters A-F representing the values from 10 through 16. Bases 0 and 1 generate a string of whose length is the value of the number. Base -1 generates a similar string con- sisting of Other bases have each "digit" represented as a (multi-digit) decimal number giving the ordinal of that digit. Each "digit" is signed for negative bases. "Digits" are separated by spaces. Given the definition of output base, the command always yields "10" (in a representation appropriate to the base); yields useful information about the output base. DIAGNOSTICS
Where x is an octal number. There are insufficient elements on the stack to do what was asked. The free list is exhausted (too many digits). Too many numbers are being kept around. Too many items are on the stack. There are too many levels of nested execution. EXAMPLES
This example prints the first ten values of n! (n factorial): SEE ALSO
bc(1). tutorial in dc(1)
All times are GMT -4. The time now is 06:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy