Search Results

Hi,

I am receiving a file with last day of the month in the filename. Ex: SRC_YYYYMMDD.DAT (SRC_20161031.DAT) and while I will generate my target file after processing the source file, it should...

Thanks Ravinder. but I am getting the below error.

date: illegal option -- d
Usage: date [-u] [+Field Descriptors]
bash-4.3$

Hi,

I have a requirement where I am getting date in string format (20161130). I need to add 20 days(not no. 20) to the above string. The o/p should 20161220.

In case of 20170228, it should show...

Hi,
Thanks for quick response.. Yes my actual input is quite big sometime it splitted into 50 lines and sometime its 10 lines only. The above command is giving correct o/p for the above example but...

Hi Experts,

I have a requirement like, I have to search between 2 words (<deviceDetails> and </deviceDetails>) and merge all lines in between into 1 line.
Example:...

Could you please explain the functionality of the above code..

My requirement is to search for a string in each line and print that line if it starts with ABC_XY_*
And those are not start with...

Hi,

I have a file which contains the below details.. My requirement is to fetch all the lines which are starting with "ABC_XY_" into 1 file and rest of the lines (not starting with "ABC_XY_") into...

Hi,
I have a requirement to merge multiple lines based on search pattern. The search criteria is : it will search for CONSTRAINT and when it found CONSTRAINT, it will merge all lines to 1 line till...

Thanks for the quick response. Its working fine.

Cheers,
Satya..

Hi,

I have a requirement to search for a pattern in each line in a file and remove the in between words till the 3rd occurrence of double quote (").

Ex: CREATE TABLE...

Thanks all for the reply. Both the options are working fine..

Cheers,
Satya :b:

Hi,

I have a file containing the DDLs of tables in a schema. From that I need to remove all the lines from a starting string till a specific string. Here is an example.
File1.txt
-------------
...

Hi,

I have a delimited (|) file having millions of rows. Sometime the file comes with less number of delimiters than expected. In this scenario I want to delete the row having unmatched...

Thanks Ranga for your reply. Now its formatting is working correctly. Could you please explain a little bit for each steps how its doing??

Hi,
I have file in which fields are pipe (|) separated and the record separator is new line (\n). But sometime I am getting a field value which is spread across multiple line. Basically I am getting...

Hi.

Thanks for the reply.

Now i removed the whitespace and it is working fine.

Thanks,
Satya.

Hi,

I am trying to execute the above attached script. and i am getting the error as syntax error at line 8: `<<' is not matched.

While i am trying to run that particular line (cat <<EOF >...

Thanks Scott for the quick reply.

The command is working fine.


--Satya

Hi,

I wanted to extract the data from a particular comma from each line.

My file contains some 10000 lines and each lines are separated by commas. There are 60 fields which are separated by 59...