Search Results

Hi Ravinder /Rudic
I am using Unix operating system . I have mentioned my scenario in my first post itself along with the code . Can you please help ?

Regards,
Sankalp

Can you help with zipping the files ?

Hi ,
I want to zip files present in the directories listed under a parent directory without zipping the directory itself
my parent directory path is
...

Thank You so much for your help. This worked:)

Thank You so much Don

Hi ,
I have a situation where I need to search an xml file for the presence of a tag
<FollowOnFrom> and also , presence of partial part of the following tag <ContractRequest _LoadId and if these...

Hi I want to know how to handle the spaces in the below scenario.
I have a file (CON_zip_path_1.txt) which has some directory paths with spaces in directory names . My requirement is to unzip these...

I want to keep the same file names .How do I get that with out a loop ? there are multiple source files

Thank you :)

yes I tried this . But it did not work ..


for FILE in *_ContractDocuments.csv
do grp=$( echo $FILE | awk -F '_' '{print $1}' )
cut -d ',' -f 1,2,3,4,5,6 < $FILE >...

sample .csv files with 7 columns.I want to delete the last column from each of the below files but retain their file names (1_ContractDocuments.csv,2_ContractDocuments.csv etc.)
There can be more...

sample xml file part


<?xml version="1.0" encoding="UTF-8"?><ContractWorkspace xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" _LoadId="export_AJ6iAFmh+pQHq1"...

Hi Ravinder ..This was very useful . Thank you for your help:)

Hi Ravinder ,
I had tried this already .The LocalId tag repeats in the file so I wanted to get the value of LocalId tag only if the Workspace value has the string "Contract Request".

sample xml file part
<DocumentMinorVersion>0</DocumentMinorVersion>
<DocumentVersion>1</DocumentVersion>
<EffectiveDate>2017-05-30T00:00:00Z</EffectiveDate>
<FollowOnFrom>
...

Hi Ravinder ,
Just to clarify 1,2,3,4 are the new folders to be created on the fly in a totally different path say /dirM/XX according to the grouping names in(Column 4)
In the above example:
...

Hi can you please help with the below ?

source file:
Column1,Column2,Column3,Column4
abc,123,dir1/FXX/F19,1
abc,123,dir1/FXX/F20,1
abc,123,dir1/FXX/F23,2
abc,123,dir1/FXX/C25,2...

Hi can you please help with the below ?

source file:
Column1,Column2,Column3,Column4
abc,123,dir1/FXX/F19,1
abc,123,dir1/FXX/F20,1
abc,123,dir1/FXX/F23,2
abc,123,dir1/FXX/C25,2...

Hi Ravinder ,
Thank you so much .. I slightly changed the code that you provided and it seems to be working now.
Thank you all:)


awk -v val=1 -F, 'NR==N-1{print;next} {SUM+=$2}...

Hi Ravinder ,
Its not working :( grouping column is incorrect . PFB the output
-bash-4.2$ awk -v val=1 -F, 'NR==1{print;next} {SUM+=$2} SUM>12{val++;SUM=$2} SUM<=12{print $0 FS val}' ...

Hi Rudic , zaxxon
Below is another example of what I am looking for :
Can you all please help ?

sample file.txt
Line,count,symbol
1,3,A
2,4,B
3,5,C
4,1,D
5,2,E
6,6,F
7,7,G
8,8,H
...

zaxxon . You are close :)

Hi all ,
The below is the expected result . Reset at every point the cumulative sum becomes greater than 12 .
...

Hi ,
I am executing a while loop .The only condition is , as far as the cumulative sum of the 2nd column from each line passed from the txt file reaches value of 12 , echo those lines .But once the...